Database Software

Hello,

I'm in a terrible hurry!!

I have dropped an important database, without want, with the Database Configuration Assistant (tables, datafiles, stored procedures, ... all) and I need to recover it from my last backup, but it doesn't works.

The steps that I'm doing are:

1. I've created a new database with the same name with Database Configuration Assistant.

2. I've run the recover utility with the Oracle Enterprise Manager, but when I run the job it crashes with this out message:

(continue after the message)

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
connected to target database: ALEX (DBID=1824348317)
using target database controlfile instead of recovery catalog

RMAN>
RMAN> run {
2> allocate channel Canal1 type disk format 'C:\oracle\oradata\backups\COPIA_01GBOHL0_1_1';
3> restore ( database);
4>
5> }
allocated channel: Canal1
channel Canal1: sid=10 devtype=DISK

Starting restore at FEB 02 2005 20:15:15

released channel: Canal1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/02/2005 20:15:16
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>
RMAN> **end-of-file**

RMAN>

Recovery Manager complete.

child process exited abnormally


3. For more information, the out message of the backup was:


Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
connected to target database: ALEX (DBID=1819909973)
using target database controlfile instead of recovery catalog

RMAN>
RMAN> run {
2> allocate channel Canal1 type disk format 'C:\oracle\oradata\backups\copia_%u_%p_%c';
3> backup
4> ( database include current controlfile );
5>
6> backup ( archivelog all delete input );
7>
8> }
allocated channel: Canal1
channel Canal1: sid=11 devtype=DISK

Starting backup at FEB 02 2005 14:15:40
channel Canal1: starting full datafile backupset
channel Canal1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=C:\ORACLE\ORADATA\ALEX\SYSTEM01.DBF
input datafile fno=00002 name=C:\ORACLE\ORADATA\ALEX\UNDOTBS01.DBF
input datafile fno=00005 name=C:\ORACLE\ORADATA\ALEX\EXAMPLE01.DBF
input datafile fno=00010 name=C:\ORACLE\ORADATA\ALEX\XDB01.DBF
input datafile fno=00006 name=C:\ORACLE\ORADATA\ALEX\INDX01.DBF
input datafile fno=00009 name=C:\ORACLE\ORADATA\ALEX\USERS01.DBF
input datafile fno=00003 name=C:\ORACLE\ORADATA\ALEX\CWMLITE01.DBF
input datafile fno=00004 name=C:\ORACLE\ORADATA\ALEX\DRSYS01.DBF
input datafile fno=00007 name=C:\ORACLE\ORADATA\ALEX\ODM01.DBF
input datafile fno=00011 name=C:\ORACLE\ORADATA\ALEX\ALEX.ORA
input datafile fno=00008 name=C:\ORACLE\ORADATA\ALEX\TOOLS01.DBF
input datafile fno=00012 name=C:\ORACLE\ORADATA\ALEX\ALEX_IDX.ORA
channel Canal1: starting piece 1 at FEB 02 2005 14:16:41
channel Canal1: finished piece 1 at FEB 02 2005 14:21:18
piece handle=C:\ORACLE\ORADATA\BACKUPS\COPIA_01GBOHL0_1_1 comment=NONE
channel Canal1: backup set complete, elapsed time: 00:05:18
Finished backup at FEB 02 2005 14:21:18

Starting backup at FEB 02 2005 14:21:19
specification does not match any archive log in the recovery catalog
Finished backup at FEB 02 2005 14:21:21
released channel: Canal1

RMAN> allocate channel for maintenance device type disk;
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=11 devtype=DISK

RMAN> delete obsolete device type disk;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found

RMAN>
RMAN> **end-of-file**

RMAN>

Recovery Manager complete.


Somebody can tell me what can we do???

Thank you very much...