Skip to Main Content

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!

Manually shipping the archive logs to the standby site

MaxJan 17 2012 — edited Jan 17 2012
11.2.0.2 on Solaris 10
2 node RAC (both Primary and Standby)

Something has gone wrong with archive log shipping and
select max(sequence#) from v$archived_log where applied='YES';
has confirmed that there is a gap of nearly 100 archive log files (sequence# difference is 100 ). Each file is 150 mb and the arch logs are stored in ASM diskgroup.


I've been asked to bring the standby to sync quickly.

Since the archive logs are in ASM, from primary, Can I backup the archive logs using RMAN and restore it in standby DB's archive log Dest (in ASM Diskgroup) ?


Regarding the original issue:
I can see that the archiver in the PRIMARY and mrp process (ps -ef | grep mrp) in Standby is running fine. Don't quite understand what went wrong
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 14 2012
Added on Jan 17 2012
5 comments
2,787 views