Database Recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Database Recovery

  1. #1
    Join Date
    Jun 2006
    Posts
    12

    Unhappy Database Recovery

    Hi,

    Database failed to restart and the following message appeared;

    Database mounted.
    ORA-01113: file 54 needs media recovery
    ORA-01110: data file 54: 'D:\ORADATA\CMG_01.DBF'

    I did the following and this is what i got:

    SQL> alter database recover datafile 34;
    alter database recover datafile 34
    *
    ERROR at line 1:
    ORA-00279: change 923435034 generated at 01/24/2007 18:39:52 needed for thread
    1
    ORA-00289: suggestion :
    C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2007_01_25\O1_MF_1_
    112724_%U_.ARC
    ORA-00280: change 923435034 for thread 1 is in sequence #112724

    I have no clue on how to handle this, how can I recover the database? There are no archive log files in place. Please advise.

    Thanks.

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    You need the archivelogs If you do not have them, you are in big troubles

  3. #3
    Join Date
    Jun 2006
    Posts
    12
    Can I just bring the database up without the archive logs. Please help. I know there will be data loss.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    what did you do to get into this state in the first place (and dont say you just shutdown the database)

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Did you re-create the control file in NOARCHIVELOG mode?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  6. #6
    Join Date
    Jun 2006
    Posts
    12
    What happenned was 2 datafiles got deleted while users were cleaning up the directory (this is at remote site). The local IT tried to restart the server and found that the database was not coming up. By the time They reported to me this was what I saw and I did the following...now I am stuck...I did not create control file on non archive.

    Appreciate your help.

  7. #7
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    First of all you need to be careful while a recovery.

    Your message says
    Code:
    ORA-01113: file 54 needs media recovery
    ORA-01110: data file 54: 'D:\ORADATA\CMG_01.DBF'
    
    I did the following and this is what i got:
    
    SQL> alter database recover datafile 34;
    alter database recover datafile 34
    *
    Datafile 54 need recovery and you are recovring datafile 34? Why?

    What happened to your archive log files? What is the current archive mode?

    Check the files in C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2007_01_25.
    Last edited by Thomasps; 01-25-2007 at 06:29 AM.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  8. #8
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Please connect as sysdba using SQL Plus and issue
    archive log list
    Put the output here
    Issue
    select file#,name,CHECKPOINT_CHANGE#,status from v$datafile
    where status='RECOVER'
    and put the results here
    Issue
    select CHECKPOINT_CHANGE# from v$database
    and put the results here

    Then we will know where we are and what the options are

    Regards

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