Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check status of sync to standby

790792May 23 2011 — edited May 24 2011

Hi Guys

Whats the best way to check that your standby DB is in sync with the Primary ?

select current_scn from v$database;

Then compare the SCN numbers and ensure they are the same ?

Also archive logs need to be confirmed that they are being SHIPPED and APPLIED on standby ?

Is that enough to conclude that Standby is in sync ?

Thanks
Steve

This post has been answered by Levi Pereira on May 23 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 21 2011

Added on May 23 2011

#11gr2, #performance-availability, #rac, #real-application-clusters

3 comments

60,093 views