ORA-01113:file 1 needs media recovery - Page 2
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,132
    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.
    this space intentionally left blank

  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,132
    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?
    this space intentionally left blank

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