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

In this article we will see RMAN duplicate target database for standby using active database command to prepare auxiliary database.

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

Database  Detail :

Step 1 : Connect to RMAN using netservice we have created at primary side :

Step 2 : Prepare a script to perform RMAN duplicate command :

We can see in above script, we have set all parameters which will be needed for Physical Standby database.

Step 3 : run above script to create standby database .

Now check physical standby database :

Step 4 : Check database role in Primary :

Step 5 : Check database role at standby :

Step 6 : Check max archive log sequence at primary :

Step 7 : Check max archive log sequence at standby :

Step 8 : Switch archive log at Primary database :

Step 9 : Again check max archive log sequence at Standby database:

We can see here archive log is transferred to standby database.

In next article, we will create standby with RMAN Restore

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.