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

In this article, we will see Physical Standby database creation and configuration using RMAN backup and restore.

Step 1: Connect to the Primary database and check if recovery area has enough space configured or not.

Step 2: Connect to RMAN and take backup :

Step 3: Create standby control file from the primary database and create pfile from spfile.

Step 4: Change following parameter in pfile.

Step 5: Connect to Standby database server and create necessary directories.

Step 6: Transfer standby control file to standby database and rename it as defined in control_files initialization parameter.

Step 7: Transfer backup to Standby database server :

Step 8: Transfer pfile to standby database :

Step 9: Transfer password file to standby database.

Step 10: Connect to Standby database and create spfile from pfile.

Step 11: In standby database connect to RMAN and start the database in mount stage.

Step 12: Restore database using restore database command.

Step 13: Connect to SQL prompt of standby database and create redo log files.

Check Standby database synchronization with the Primary database

Step 14: Connect to the Primary database and check the role of the primary database.

Step 15: Connect to Standby database and check the role of the database.

Step 16: Check maximum archive log sequence from the primary.

Step 17: Check maximum archive log sequence from standby database.

Step 18: Switch logfile at primary database :

Step 19: Again check max archive log sequence at the standby database.

Physical standby database using RMAN backup restore is successfully created.


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.