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.