| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: unhacking file$
John,
The obvious answer is to perform a point-in-time recovery to just before this happened.
Having said the correct thing, you could try something else.
Like create a new dummy database (one that you will throw away) with a minimal number of tablespaces (System, Undo & Users). Add a couple of data files to the users tablespace.
Do exactly what your "well meaning but soon to have fingers hacked off" DBA did.
Then insert a record back into file$.
And then see what happens. The problem with this kind of testing is that you never will know if everything is ok. It may run fine for awhile. But the next migration or Rman backup may kill you.
I still would opt for choice #1 and make the other DBA do the recovery and explain to everyone what happened. A tough lesson, but one he/she needs to learn.
Good Luck!
Tom
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of john d parker
Sent: Tuesday, February 21, 2006 2:22 PM
To: oracle-l
Subject: unhacking file$
I need to "unhack" file$. A well meaning DBA deleted a row from file$ while trying to remove an unneeded datafile from a tablespace.
Currently, I can see the file thru v$datafile and it's status is online. I cannot see the file thru dba_data_files which feeds from file$.
Any suggestions on putting the entry back in file$? If it helps any, this is 9.2.0.6 on AIX.
John Parker
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 21 2006 - 13:40:42 CST
 |
 |