I am using RMAN, oracle 8.0.5 on unix
I have base backup (level 0) on Monday, and incremental backup (level 2) on Tuesday 2AM.
by mistaken I delete a data file /ora/dat2/oradata/DBA1/data_01.dbf
and temp file /ora/dat2/oradata/DBA1/temp_01.db on Tuesday afternoon.
Now I am doing restore/recovery
from rman, I issue
from svrmgrl issue
Media recovery complete.
I bounce the database, open no error.
when I get in sqlplus try to access database, I got:
ORA-00376: file 6 cannot be read at this time
ORA-01110: data file 6: '/ora/dat2/oradata/DBA1/data_01.dbf'
restore, recover both no error, instance can start/shutdown not error. I can see the new data file and temp file been restore on the disk. why I can not access it?
what I did wrong? could anyone give me some thought?
what is the status of the datafile in v$datafile ???
At the time of restore did you take the tablespace off line?
1. Do the restore and recovery through rman and not through the database level
2. Don't worry about restoring the temp file, you can just drop it and recreate one.
I restore through rman, recover db from svrmgrl.
I checked v$datafile, yes, both files (data & temp) are offline.
when I deleted files, I use sbutdown abort. I guess some where during restore or recover oracle brought these 2 files offline.
Q: if these 2 files offline, does recover still work on these 2 files?
Q: can I just bring these 2 file on line then DB back to normal?
Do u have anything in
1) alert file
2) any trace generated
3) any rows in v$recover_file.
Here is what I did:
SVRMGR> alter database open;
SVRMGR> recover tablespace data;
SVRMGR> recover tablespace temp;
SVRMGR> alter tablespace temp online;
SVRMGR> alter tablespace data online;
SVRMGR> alter system disable restricted session;
thanks for your nice input.
could anyone knows
when oracle bring these 2 files offline?
In what kind of condition, oracle will bring a tablespace or
Thanks in advance