RMAN Recovery From Missing All Control File

SQL> select dbid from v$database;

DBID

----------

847839442

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S

NCFDBA20.ORA'; # default

RMAN> configure controlfile autobackup on;

RMAN> backup database;

SQL> select name from v$controlfile;

NAME

------------------------------------------------------

C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\CONTROL01.CTL

C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\CONTROL02.CTL

C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\CONTROL03.CTL

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

Delete control files.

SQL> startup;

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 1247876 bytes

Variable Size 83887484 bytes

Database Buffers 75497472 bytes

Redo Buffers 7139328 bytes

ORA-00205: error in identifying control file, check alert log for more info

RMAN> set dbid 847839442

RMAN> restore controlfile from autobackup;

RMAN> alter database mount;

RMAN> restore database;

RMAN> recover database;

RMAN> alter database open resetlogs;