Sync. Primary and Standby
edited Aug 24, 2009 6:15PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
Hi,
I have following results. How do I synchronize Primary and Secondary?
1) Primary
.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /Dbase/archive/shaprod/SHA
Oldest online log sequence 142
Next log sequence to archive 144
Current log sequence 144
SQL> quit
2) Standby
SQL> connect / as sysdba;
Connected.
a) SQL> select max(sequence#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
--------------
143
Thanks a lot,
Arun
0