As Oracle Data Guard came up with many advantages, One of its benefits is we can offload backup to Physical Standby Database.

Using the RMAN Recovery Catalog in a Data Guard Configuration

 

We need to user Recover Catalog to offload backup to the standby database.

We will offload backup to the physical standby database in 3 stages and then we will test that backup by restoring it to another server.

  1. Creating Recovery Catalog
  2. Registering database in the recovery catalog.
  3. Taking the backup using Physical Standby.
  4. Restoring a backup to test.

Creating Recovery Catalog : 

Step 1: Checking details of the database to be used for recovery catalog.

Step 2: Create tablespace in recovery catalog :

Step 3: Create the user to be used as recovery catalog owner :

Step 4: grant recovery_catalog_owner grant to a user.

Step 5: Add TNS entry of primary database and standby database in the server where recovery catalog database resides.

Step 6: Connect RMAN with target and catalog clause. target clause contains the primary database and catalog clause contains the catalog database 

Step 7: Apply to create catalog command of RMAN to create recovery catalog.

In this stage recovery catalog is created, now we need to register the primary database.

Step 8: Register the primary database in the recovery catalog

Step 9: We can use report schema recovery catalog command to check the physical structure of the database.

Step 10: List db_unique_name of database.

Step 11: Configure the standby database to the recovery catalog.

Step 12: Now again check the database using list db_unique_name of database command.

Our recovery catalog is ready in this stage. Now we will configure parameters and will take backup

Step 1: Configure controlfile autobackup on.

Step 2: Now connect to the physical standby database as the target and connect to the catalog and take incremental level 0 or full backup

Now we have successfully taken backup from standby database lets transfer it test server and test it.

Step 1: Transfer backup using rsync

Step 2 : Create necessary directories on the test server so we can restore primary database backup here.

Step 3 : Check backup is arrived or not

Step 4 : Connect to RMAN and follow the restore process.

Start database in the nomount stage :

Step 5 : Restore spfile 

Step 6 : Restore controlfile

Step 7 : Mount database

Step 8 : Now let us first check in sql session mounted database role

We can see here database role is primary . So a backup taken from physical standby in data guard broker works fine to restore as a primary database.
Now, we can go further for the restoration process.

Step 9 : Restore database

Step 10 : Recover database

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel : https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

 

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.