Media Recovery

[Ablakios]

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

[adewri]

Whats the output of...

select name from v$datafile;

is the file there ??

[Ablakios]

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

[marist89]

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.

[adewri]

You mean to say that the file is not present there physically at the location F:\ORACLE\ORADATA\RECSYS\ ??

[Ablakios]

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?

[adewri]

If its there then who cares about DBA-Studio...

[Ablakios]

Thanks to all.

[Mr.Hanky]

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