Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 21 2011
Added on May 23 2011
#11gr2, #performance-availability, #rac, #real-application-clusters
3 comments
59,940 views