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

Thread: Media Recovery

Threaded View

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374

    Media Recovery

    Hi
    I received the following error
    ORA-01113: file 6 needs media recovery
    ORA-01110: data file 6: 'F:\ORACLE\ORADATA\RECSYS\INDX1.DBF'

    My database is in Archive log mode. I recovered the datafile by applying the suggested logfile until I received the following Message
    "MEDIA RECOVERY COMPLETE"
    I then open the database and users where connected. I checked the v$recover_file as follows:

    SQL> SELECT FILE#, CHANGE# FROM V$RECOVER_FILE;
    no rows selected
    I then brought the recovered datafile online but j
    ALTER DATABASE DATAFILE ''F:\ORACLE\ORADATA\RECSYS\INDX1.DBF' ONLINE;
    Database altered.
    But I just cannot find that datafile. I query the Index tablespace which originally has 2 datafiles
    INDX1
    INDX2
    But Now I am only showing INDX2. if my result says that the is index1 is ONLINE and v$recover_file show no rows where is the INDX1;

    Please advise
    Last edited by Ablakios; 05-19-2003 at 02:19 PM.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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