List of Contents

Archive logs:

@ Enable & Disable Archive log mode

@ Deleting Archive logs in Oracle

Database Links:

@ Use of GLOBAL_NAMES parameter with respect to DB links

@ What is Database link and its types

Database Queries:

@ RMAN Backup Status

@ Schema size in the Oracle database

@ Tablespace Usage

@ List of users connected to the database along with SQL Text

@ Redo log switch rate on hourly basis for a week

@ Hit Ratios in Oracle database

@ List of DB objects in a datafile

@ Find Oracle DB name as a normal user

@ Find Oracle DB table size

Export & Import in Oracle

@ Introduction on exp/expdp and imp/impdp utilities

Oracle Data Guard

@ What is Oracle Data Guard?

@ About Physical Standby and the processes involved

@ Physical Standby (Redo Apply) – A detailed process flow

RMAN Concepts & Errors

@ RMAN-06207,RMAN-06208 & RMAN-06214

Roles & Privileges

@ Difference between SYSDBA & SYSOPER system privileges

Oracle 19c Upgrade

@ Fix 'appl_prinicipal' pre-upgrade check