Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

no backup of copy of datafile is found to restore

Status
Not open for further replies.

mancub

Programmer
Jul 24, 2006
13
US
I was testing a recovering scenario, i took a hot backup of my database. Went back in and dropped a table. Then tried to do an incomplete recovery. Apparently i started the recovery with one of the datafile offline. I brought it back online. And since then i get this error when i try do a recovery.

RMAN> restore database until time "to_date('10/08/2006 04:30:00','dd/mm/yyyy hh24:mi:ss')";

Starting restore at 10-AUG-06

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=13 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/10/2006 19:55:34
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 13 found to restore

RMAN>

Can't waite to see the solution from you gurus, i hope i can still recover this database
 
So, Mancub,

Do you have a backup copy of the datafile (13) anywhere (plus all of the archive log files from the date/time of that backup up to the "until" time you specify)? If not, then you probably have a hosed database.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
 

you are right i have a hosed database. Good thing it was only a test db. I took this file offline back in july and tried to drop it. But i forgot to manually remove it instead i moved it to another folder.When i was doing a user managed recovery i restored it with the rest of the files. I've deleted the database. Thanks again for your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top