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

Thread: ORA-01113: file 1 needs media recovery

  1. #1
    Join Date
    Oct 2002

    ORA-01113: file 1 needs media recovery

    SVRMGR> startup
    ORACLE instance started.
    Total System Global Area 18538956345 bytes
    Fixed Size 76934 bytes
    Variable Size 363345334 bytes
    Database Buffers 457235340 bytes
    Redo Buffers 34637221 bytes
    Database mounted.
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: '/oracle/SAP/sapdata1/system_1/system.data1'


    from the link ,
    "If the database is a standby database then check the procedure for copying the file in the first place. A common mistake is to perform a hot backup of a database but without issuing a ‘alter tablespace ... begin backup ... end backup’ for the tablespace in question.

    Once the media error has been recovered from the database can be opened normally (i.e. ‘startup’ or ‘alter database open’).

    is it right?

  2. #2
    Join Date
    Oct 2001
    Madrid, Spain
    Nop, as the error say your file needs media recovery.

    Try first:

    sqlplus> recover database;
    sqlplus> alter database open;


  3. #3
    Join Date
    Oct 2002
    can i do the below?

    alter database mount;

    basically, do these two

    alter database open;

    alter database datafile 'output of the above' end backup;

    and then repeats, depending on the number of datafiles which are affected?

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