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
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