DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009

    Media recovery error


    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-01112: media recovery not started

    please give me solution.

    thanks in advance

  2. #2
    Join Date
    Oct 2008
    Chandigarh, India
    It seems you have overwritten the current redo log files with the redos of old backup. That's why, it's happening.

  3. #3
    Join Date
    Nov 2000
    Pittsburgh, PA
    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.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.