data file needs media recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: data file needs media recovery

  1. #1
    Join Date
    Mar 2005
    Posts
    143

    data file needs media recovery

    I want to refresh one of my db's from production. I had my backup operator restore my prod db from last nights backup. The database is 9i. I rebuilt the controlfiles from the contents of a backup controlfile to trace command. When I went to open the database with an alter database open resetlogs; command I got the following message.
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'E:\ORACLE\ORADATA\PSUAT\SYSTEM01.DBF' So Then I issue the following command to recover the data file
    recover datafile 'E:\ORACLE\ORADATA\PSUAT\SYSTEM01.DBF';
    and I recieve the following error
    ORA-00283: recovery session canceled due to errors
    ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
    so I issued the recover database using backup control file and it asked for a log file with a certian sequence #. I put the path of the file it wanted and it returned to a sql prompt returning no error message. I guess it worked. so I then went to open the database using the alter database open noresetlogs it says I must use the resetlogs option. So I issue the alter database open resetlogs and I get the original message saying
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'E:\ORACLE\ORADATA\PSUAT\SYSTEM01.DBF'

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You need to recover through the last log backed up, cancel the recovery, and open resetlogs.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Mar 2005
    Posts
    143
    when I open resetlogs I get the error message
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'E:\ORACLE\ORADATA\PSUAT\SYSTEM01.DBF'

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You need to recover through the last log backed up, cancel the recovery, and open resetlogs.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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