Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> 8.1.7 Recover database until time

8.1.7 Recover database until time

From: dsmcd <dsmcd_at_stopspamdormouse.net>
Date: Mon, 25 Apr 2005 20:29:49 GMT
Message-ID: <1rcbe.44$pc.11007@news.uswest.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US