Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 8.1.7 Recover database until time
Hello...
8.1.7 on Win2kServ. I'm experimenting with recovery options, but they are failing.
We do cold backups nightly.I grabbed the backups files from 03/05/05. I copied&pasted:
In sqlplusw, I ran:
SQL> recover database until time '2005-04-11:23:00:00';
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
(the sql responses were very quick, almost instantaneous.)
I restarted the database, but data after 03/05/05 is still not there.
Any suggestions? (BTW, I can't upgrade the 8.1.7: management decision)
Thx,
D.
Received on Mon Apr 25 2005 - 15:29:49 CDT