Archivelog in Real-Time Downstream Capture
edited Mar 28, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
Hi,
I'm wondering some points in implementing Real-Time Downstream Capture, I know that we need to set up standby logfile and archivelog destination in replica database.
E.g.
1) SQL> ALTER DATABASE ADD STANDBY <bla bla bla>
2) SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = 'LOCATION=/arc/master_log VALID_FOR=(standby_logfile, primary_role)'
Questions:
1) Since it's real-time provided by existence of standby logfile, why do we still need to store standby archive log in /arc/master_log?
2) Does rman recognize those archive logs ? how to backup ?
3) Assume LOG_ARCHIVE_DEST_1 is destination for local archivelog. To implement bidirectional replication
0