Rebuild Stand By database when PDB restored from restore point/Issue with the PDB

Share via:

Hello Readers,

In this article, we will see Recovery models in SQL Server.


1. Take backup of the primary database

2. Create standby control file from primary database.

3. Transfer backup pieces along with control file from primary server to standby server.

SCP backup pieces to standby database

4. Take standby database controlfile backup to trace from standby database

5. Stop the standby database using srvctl utility.

6. Open standby database to unmount mode using srvctl utility.

7. Connect to RMAN and restore the control file , catalog the backup pieces and restore the database.

8. Drop the stand by redo log and create redo log

9. Start mrp process of the database and verify archive log is applying into database.

10. Monitor the shipping and logs apply status

11. Enable Active Dataguard mode



Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook :
LinkedIn :
Twitter :
YouTube :
Instagram :

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Add Comment