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!

Archive log not shipped to standby.

ShankarVijiJun 20 2012 — edited Jun 22 2012
Dear Experts,

We have are using oracle 10.2.0.4.0 on AIX.

And we have configured physical standby database which was working fine till date.

suddenly i found that the MRP process is waiting for gap.
i have all the archive logs on the primary system and all the logs are getting shipped to standby database expect one file.

/oracle/PRD/saparch/PRDarch1_46811_755493268.dbf only this file is not getting shipped to standby database....due to which the standby is waiting for this log.

log applied till 46810
other logs are getting shipped.

However i tried to manually copy this log to standby but it didnt start applying this log.

and i heard that if i copy the log file manually then i need to register it...please let me know how to register it if it is the correct method.

Please help to overcome this issue....

Thanks,
Shankar.

Edited by: Shankar Viji on Jun 19, 2012 10:34 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2012
Added on Jun 20 2012
9 comments
2,035 views