DataGuard Switchover: 1st shutdown db or GG and how to resume extract and replicat
Customers is having there database environments all in two notes RAC, RDBMS version 10.2.0.5. GoldenGate 11.1.1.1.4.
env A ------> env B (Oracle DataGuard Physical Standby as A primary, B is standby) env A ----------> env C (GoldenGate replication). Customer will test the switchover from A to B, therefore. A becomes the standby and B becomes the primary and then the Goldengate replication will start from env B -------------> env C. After testing, they will switchback over.
Question:
Should Golden Gate shutdown first or should the database (primary) shutdown first?
After switchover, should - Start begin now vs. using an SCN
The main concern is archive logs could be generated after GG is down.