RMAN Physical Standby Database backup is used to create another physical standby database.

Offloading Backup to Standby in Data Guard

I have already taken backup of one of my physical standby database.

Use following steps to restore physical standby backup to create a new physical standby database.

Step 1: Create the directory on the server for the restoration process of RMAN.

Step 2: Transfer backup.

Step 3: Transfer spfile and password file to a new server.

Step 4: Startup database in the nomount stage :

Step 5:  Restore the control file :

Step 6: Mount database

Step 7: Restore Database

Step 8: Recover Database

Step 9: Check database role of physical 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 CChannel: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.