DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: ORA-01113:file 1 needs media recovery

  1. #1
    Join Date
    Apr 2006
    Posts
    7

    ORA-01113:file 1 needs media recovery

    hi,
    i am using oracle 9i on windows XP,
    when i try to open the database i found system file needs media recovery,
    the following error occurs

    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: datafile 1:'D:\ORACLE\ORADATA\SONA\SYSTEM01.dbf'

    the important point to remember is I DONT HAV ANY BACKUP of 'SYSTEM' datafile.....

    NOW HOW CAN I RECOVER THE SYSTEM DATAFILE?
    i m running my database in archive log mode
    can anyone plz help to resolve this issue.....


    thanks in advance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    first of all, what did you do to make it need recovery

  3. #3
    Join Date
    Apr 2006
    Posts
    7
    hi,
    actually i try to open the database at that time i found this error so i want to do recovery.....

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no what did you do before that, to make the file need recovery, just opening the database wouldnt cause that

  5. #5
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    ...and what is the point of running in archive log mode if you don't have a backup?
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  6. #6
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    Is this a prodcution db? If not, why dont you try doing a recover database since you said you are in archive log mode
    thomasp

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Did you try running the recover command and letting recover using the archive logs? You may not need to restore anything.

  8. #8
    Join Date
    Apr 2006
    Posts
    7
    hi,
    i try to recover the system file by giving the following command and try to open the database but it once again shows the same error with different datafile that it needs recovery........

    this is wat i did to recover:
    SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\SYSTEM01.DBF';
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 2 needs media recovery
    ORA-01110: data file 2: 'D:\ORACLE\ORADATA\SONA\UNDOTBS01.DBF'

    SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\UNDOTBS01.DBF';
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 3 needs media recovery
    ORA-01110: data file 3: 'D:\ORACLE\ORADATA\SONA\CWMLITE01.DBF'


    SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\CWMLITE01.DBF'
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 4 needs media recovery
    ORA-01110: data file 4: 'D:\ORACLE\ORADATA\SONA\DRSYS01.DBF'


    SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\DRSYS01.DBF'
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 5 needs media recovery
    ORA-01110: data file 5: 'D:\ORACLE\ORADATA\SONA\EXAMPLE01.DBF'
    ..............

    wat to do now?
    i hav control file backup.can i recover it by "recover database using backup control file until cancel" ?

    any suggestions plz......
    sorry itz my mistake that not having any backup.....
    plz help me to solve this issue.....

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what did you do to get it to this point, its important and makes a different

    Why didnt you recover the eample01.dbf file?

  10. #10
    Join Date
    Apr 2006
    Posts
    7
    i issued the same following this and try to recover all file but at last it shows error "ORA-01092: ORACLE instance terminated. Disconnection forced"
    here i listed wat i did
    SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\SYSTEM01.DBF';
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 2 needs media recovery
    ORA-01110: data file 2: 'D:\ORACLE\ORADATA\SONA\UNDOTBS01.DBF'

    SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\UNDOTBS01.DBF';
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 3 needs media recovery
    ORA-01110: data file 3: 'D:\ORACLE\ORADATA\SONA\CWMLITE01.DBF'


    SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\CWMLITE01.DBF'
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 4 needs media recovery
    ORA-01110: data file 4: 'D:\ORACLE\ORADATA\SONA\DRSYS01.DBF'


    SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\DRSYS01.DBF'
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 5 needs media recovery
    ORA-01110: data file 5: 'D:\ORACLE\ORADATA\SONA\EXAMPLE01.DBF'
    SQL> recover datafile 'D:\ORACLE\ORADATA\SONA\EXAMPLE01.DBF'
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 6 needs media recovery
    ORA-01110: data file 6: 'D:\ORACLE\ORADATA\SRASDEV\INDX01.DBF'


    SQL> recover datafile 'd:/oracle/oradata/srasdev/indx01.dbf';
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 7 needs media recovery
    ORA-01110: data file 7: 'D:\ORACLE\ORADATA\SRASDEV\TOOLS01.DBF'


    SQL> recover datafile 'd:/oracle/oradata/srasdev/tools01.dbf';
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 8 needs media recovery
    ORA-01110: data file 8: 'D:\ORACLE\ORADATA\SRASDEV\USERS01.DBF'


    SQL> recover datafile 'd:/oracle/oradata/srasdev/users01.dbf';
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 9 needs media recovery
    ORA-01110: data file 9: 'D:\ORACLE\ORADATA\SRASDEV\SAAS_UNIV_DATA01.DBF'


    SQL> recover datafile 'd:/oracle/oradata/srasdev/saas_univ_data01.dbf';
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 10 needs media recovery
    ORA-01110: data file 10: 'D:\ORACLE\ORADATA\SRASDEV\SIS_DB_DATA01.DBF'


    SQL> recover datafile 'd:/oracle/oradata/srasdev/SIS_DB_DATA01.dbf';
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 11 needs media recovery
    ORA-01110: data file 11: 'D:\ORACLE\ORADATA\SRASDEV\SAAS_WEBREF_DATA01.DBF'


    SQL> recover datafile 'd:/oracle/oradata/srasdev/saas_WEBREF_DATA01.dbf';
    Media recovery complete.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced
    so wat to do now?
    any suggestions plz......
    plz help me to solve this issue.....

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