We have seen preparing Primary Database for Dataguard and creating Oracle network service on both sides.

In this article, we will see Physical Standby creation using RMAN duplicate database for standby command.

Note: For this process, we need to copy password file from primary side to standby side under $ORACLE_HOME/dbs

Database Detail :

Connect to Primary Database :

Step 1: Take backup :

Connect to RMAN and take full database backup using rman backup database command.

Step 2: Transfer backup :

Connect to standby database and transfer backup from Primary to Standby server.

Step 3 : Transfer pfile :

Step 4 : Transfer password file.

Step 5: Start database in nomount stage.

Step 6: Connect to RMAN with a target and auxiliary database :

Check Physical Standby Database Synchronization :

Step 7: Check role of primary database :

Step 8: Check role of Standby database :

Step 9: Check max archive log sequence from the Primary database :

Step 10: Check max archive log sequence from Standby database :

Step 11: Switch logfile in Primary database :

Step 12: Check sequence from Standby 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

 

 

Leave a Reply

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