-
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.
-
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
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.
-
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
-
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."
-
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.
-
If its there then who cares about DBA-Studio...
Amar
"There is a difference between knowing the path and walking the path."
-
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|