no backup of copy of datafile is found to restore

[mancub]

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

 

[SantaMufasa]

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.

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]

 

[mancub]

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.