Backup/Restore & Sync.
edited Jan 3, 2014 1:22AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 7 commentsAnswered
Our shop is going to perform DR Drill. i.e. It's going to switch from primary DB to backup DB. After drill, it's necessary to resume image before drill. To save time to sync, primary and backup DBs again, will the following steps work?
1. Before Drill, stop both primary and backup DBs, and backup physcial files of backup DB.
2. Bring up backup DB, stop Data Guard, and switch to use backup DB.
3. After Drill, stop backup DB, and restore physcial files of backup DB.
4. Bring up both primary and backup DBs
After restoring physical files of backup DBs, both primary and backup DBs should have the same image before drilling.
0