?
Solved

Media Recovery failed with error 16067

Posted on 2006-03-19
2
Medium Priority
?
1,728 Views
Last Modified: 2012-05-05
Hi Experts,

I am getting this error in the Alert log of one of my database running in Standby Mode. This standby database is fed from archive logs extracted from my Production server.



ORA-279 signalled during: ALTER DATABASE RECOVER  standby database  ...
Mon Mar 20 04:07:05 2006
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log /oracle/P71/saparch/P71arch1_388594.dbf
Errors with log /oracle/P71/saparch/P71arch1_388594.dbf.
Recovery interrupted.
Media Recovery failed with error 16067
ORA-283 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
Mon Mar 20 04:07:05 2006
ALTER DATABASE RECOVER CANCEL
ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...
 

 I can confirm that the archive log /oracle/P71/saparch/P71arch1_388594.dbf is NOT corrupt also I have all the previous and successive log files, is there any way to work around this , I have tried stopping and starting the standby database, however it doesnt help.

Regards,
cryptosid
0
Comment
Question by:cryptosid
2 Comments
 
LVL 7

Accepted Solution

by:
vishal68 earned 750 total points
ID: 16233374
Hi

This error indicates that the Activation ID of the Database and that of the Archive log is not matching. Normally this happens if you recreate the Control file with ResetLogs option, but I have seen some bugs reported where the Activatiob ID got changed even though the Controlfile was recreated with NoResetLogs options.

Did you recreated the Control file of your production instance for any reason ?

Vishal
0
 
LVL 5

Author Comment

by:cryptosid
ID: 16233698
Hi Vishal,

Thanks for your reply, I did find that there was some mismatch in the Control file of the production and the standby, we recreated the control file from the production for the standby and updated stop/started the standby.

This resolved the issue.

Thanks for your help.

Regards,
cryptosid
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to take different types of Oracle backups using RMAN.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question