Oracle Database Discussions

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!

could u tell me last applyed archive log in disaster recovery server

techshell81Oct 3 2010 — edited Oct 4 2010

Hi DBA'S,

we are using oracle 9.2.0.8 my production database has dr(our dr is not a stand by it is created in diff way) server every time one cron job sync the database and transfer the new logs from production server to dr server. i want to know last applied archive in dr server.

i am using this query select max(sequence#) from v$log_history; it is showing same results in boath production and dr when ever we backup 2 days before archive to some backup directory sync is going to fail
please tell me correct query to find out the last applied archived log in dr server

Thanks&Regards
Tirupathi

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2010

Added on Oct 3 2010

#general-database-discussions

6 comments

1,868 views