Recreating Physical Standby Database after recovery of Primary Database
In an Oracle 11g Data Guard environment, the following steps will recreate the Physical Standby Database from the Primary Database. Both databases are 2 node RAC using ASM shared storage.
A number of reasons may influence the decision to recreate the Standby database, these include:
- Point in time Recovery (PITR) of Primary database
- The standby (DR) site had to be rebuilt due to hardware failure
- The network link was down for a long period, resulting in a huge backlog of archive logs waiting to be shipped and applied on the Standby database.
All the above have one thing in common; data synchronisation required between Primary and Standby. In terms of restoration time, it may be advantageous to recreate the Standby Database from the Primary. This is easily accomplished using RMAN’s Oracle 11g new feature;
“duplicate target database for standby from active database”…
Read the full article by clicking on the following link:
Advertisement
