How to use RMAN to rebuild physical standby after failover
edited Jul 30, 2013 8:06AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Hi,
Short story:
1. Primary (prd1108) switchover to standby (p1108sb1) success.
2. Switchover back from new primary (p1108sb1) to new standby (prd1108) success.
3. But some problem between DGMGRL and CLUSTWARE, the prd1108 cannot start properly but database role had been changed to 'PRIMARY'. The log_archive_dest_1 was cleared automatically and make archiver process failed. (Found it later).
4. In urgency, I have to shutdwon the prd1108 and use DGMGRL> failover to p1108sb1
5. Right now, the p1108sb1 is working fine, I can start the prd1108 and convert it from 'PRIMARY' to 'PHYSICAL STANDBY'.
6. But I cannot REINSTATE database prd1108
0