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!

How to check if Standby db is working

Beauty_and_dBestFeb 4 2016 — edited Feb 7 2016

Hi ALL,

EBS R12.2.4

11gR2

OL6.5

At my primary db, I run:

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /home/ARCH

Oldest online log sequence 7629

Next log sequence to archive 7630

Current log sequence 7630

Then at my standby db, I run:

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /home/ARCH

Oldest online log sequence 7629

Next log sequence to archive 0

Current log sequence 7630

Is this enough the check?

Does this mean my standby is working good?

Kind regards,

This post has been answered by Pravin Takpire on Feb 4 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2016

Added on Feb 4 2016

#data-guard, #performance-availability

28 comments

33,597 views