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;

Comments