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

Thread: Media Recovery

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

    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 03:19 PM.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Whats the output of...

    select name from v$datafile;

    is the file there ??
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Amar
    I query the datafile and is there but why is it not showing in the DBA_STUDIO?
    I mean there is no file to recover and the datafile is online but it is not showing in the DBA Studio.
    Do I have to recreate the index? if so how I am supposed to know the name of the index that were in the indx1 datafile?



    G:\ORACLE\ORADATA\RECSYS\SYSTEM01.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS5.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS1.DBF
    I:\ORACLE\ORADATA\RECSYS\TEMP01.DBF
    F:\ORACLE\ORADATA\RECSYS\TOOLS1.DBF
    F:\ORACLE\ORADATA\RECSYS\INDX1.DBF (Here it is)
    F:\ORACLE\ORADATA\RECSYS\DR01.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS2.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS3.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS4.DBF
    H:\ORACLE\ORADATA\RECSYS\RBS1.DBF

    NAME
    ------------------------------------------------

    F:\ORACLE\ORADATA\RECSYS\USERS6.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS7.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS8.DBF
    H:\ORACLE\ORADATA\RECSYS\RBS2.DBF
    G:\ORACLE\ORADATA\RECSYS\SYSTEM02.DBF
    F:\ORACLE\ORADATA\RECSYS\INDX2.DBF (and here is the 2nd one)
    I:\ORACLE\ORADATA\RECSYS\TEMP02.DBF
    G:\ORACLE\ORADATA\RECSYS\OEM_REPOSITORY.ORA
    I:\ORACLE\ORADATA\RECSYS\TEMP101.DBF
    I:\ORACLE\ORADATA\RECSYS\TEMP102.DBF
    I:\ORACLE\ORADATA\RECSYS\TEMP103.DBF

    NAME
    ------------------------------------------------

    F:\ORACLE\ORADATA\RECSYS\USERS9.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS10.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS11.BDF
    H:\ORACLE\ORADATA\RECSYS\RBS3.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS12.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS13.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS14.DBF
    F:\ORACLE\ORADATA\RECSYS\USERS15.DBF
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Another case in point of why NOT to use GUI tools. If you don't understand what the GUI is doing, you shouldn't be using it.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    You mean to say that the file is not present there physically at the location F:\ORACLE\ORADATA\RECSYS\ ??
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    I saw the physical file on the drive and when I query the datafile. But I use Oracle DBA STUDIO to monitor the disk space usage graphically and that's where I do not see it. Is this something I should worry about since querying the datafile shows me that it is there and online?
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    If its there then who cares about DBA-Studio...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Thanks to all.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  9. #9
    Join Date
    Jan 2001
    Posts
    3,131
    DBA Studio is not a perfect science yet. I am looking at archived redo logs in OEM that I deleted well over 6 months ago. I re-checked the directory and they are gone, yet OEM still shows them as existing.

    I will call this a bug

    MH
    I remember when this place was cool.

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