DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: ORA-01113:file 1 needs media recovery

  1. #11
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Whats teh contents of the alert log.

    Did you try to restart the instance ?

    regards
    Hrishy

  2. #12
    Join Date
    Apr 2006
    Posts
    7
    hi,
    i had restarted the instance again and my databse is running again.
    thanks for everyone, helped me to solve this issue.

  3. #13
    Join Date
    Apr 2006
    Posts
    7

    ORA-01113: file 1 needs media recovery

    hi,
    i had restarted the instance again and my databse is running again.
    thanks for everyone helped me to solve this issue.

  4. #14
    Join Date
    Nov 2009
    Posts
    1

    file needs file recovery

    Hi

    I think u need whole database recovery

    sql>Recover Database

    Try this

  5. #15
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by udaysap View Post
    Hi

    I think u need whole database recovery

    sql>Recover Database

    Try this
    It is a bit late to offer help on this post.
    You should check the date before responding to old posts.

  6. #16
    Join Date
    Mar 2017
    Posts
    1
    SQL> startup
    ORACLE instance started.

    Total System Global Area 1068937216 bytes
    Fixed Size 2260048 bytes
    Variable Size 629146544 bytes
    Database Buffers 432013312 bytes
    Redo Buffers 5517312 bytes
    Database mounted.
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'


    SQL> select name,open_mode from v$database;

    NAME OPEN_MODE
    --------- --------------------
    XE MOUNTED
    SQL> SELECT MEMBER FROM V$LOG G, V$LOGFILE F WHERE G.GROUP# = F.GROUP# AND G.STA
    TUS = 'CURRENT';

    MEMBER
    --------------------------------------------------------------------------------

    C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_DD4MKPHY_.LOG

    SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
    ORA-00279: change 409803 generated at 03/14/2017 11:02:59 needed for thread 1
    ORA-00289: suggestion :
    C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2017_03_15\O1_MF_1_5_%U_

    .ARC
    ORA-00280: change 409803 for thread 1 is in sequence #5


    Specify log: {=suggested | filename | AUTO | CANCEL}
    C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_DD4MKPHY_.LOG
    Log applied.
    Media recovery complete.
    SQL> alter database open resetlogs;

    Database altered.

    SQL> select name,open_mode from v$database;

    NAME OPEN_MODE
    --------- --------------------
    XE READ WRITE

    SQL>

  7. #17
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by vijaya lakshmi View Post
    SQL> startup
    ORACLE instance started.

    Total System Global Area 1068937216 bytes
    Fixed Size 2260048 bytes
    Variable Size 629146544 bytes
    Database Buffers 432013312 bytes
    Redo Buffers 5517312 bytes
    Database mounted.
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'


    ...
    Do you think that the original poster is going to see your response and do you
    think that they are still having the same issue after 11 years?

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