Media recovery error

[rashadyell]

Hi,

I am copied all the datafiles,controlfiles and redo files to original destination from last cold backup. and started the database. it was up.

then i copied archive log files which are generated after cold backup to original destination. and shutdown the database and mounted the database.

then fired command recover database using backup controlfile;

the first archive log file applied successfully. when reading next archive log file it throws following error.

ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [4194313], [1], [3622], [3],
[76], [], []
ORA-10567: Redo is inconsistent with data block (file# 1, block# 9)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: 'O:\ORACLE\ORADATA\ASO\SYSTEM01.DBF'
ORA-10560: block type 'KTU UNDO HEADER W/UNLIMITED EXTENTS'


ORA-01112: media recovery not started


please give me solution.

thanks in advance

[mahajanakhil198]

It seems you have overwritten the current redo log files with the redos of old backup. That's why, it's happening.

[gandolf989]

For one thing you can't mount the database until you do basic recovery.
If you want to do recovery shutdown the database then copy your backup controlfile to the places where your real control files lived, startup nomount, recover database using backup controlfile until cancel, let Oracle run though all of the archive logs it can find the run the previous command one more time and type in cancel when it askes for the next archive log. then you should be able to open the database with reset logs.

But to be able to do any of that you need a valid backup control file.
Which you might not have. If you don't have a valid backup control file,
its possible that you can't restore your backup. Which is why testing database recovery is so critical.