DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Media recovery error

Hybrid View

  1. #1
    Join Date
    May 2009
    Posts
    24

    Media recovery error

    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

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

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

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