Activate 2nd standby database as primary
edited Dec 20, 2016 4:02AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
Hi,
currently we have a primary and 1 physical standby database (PSB) in sync ( max availability mode).
now, I have done the following
1. Added 2nd Physical standby database using online duplicate target database from primary
2. Then, the redo are in sync for both 1st and 2nd PSB w.r.t Primary
3. Next, when I redo log switch , the redo shipping was fine and even applied=YES condition was showing the updated SEQUENCE# as that of Primary
4. But I did not configure the 2nd PSB in dgmgrl.
5. Now, the next step what I did was that , I want to make 2nd PSB as Primary, for that, I made the log_archive_dest_3 as DEFER to top shipping once I confirmed the logs are in sync
0