Google+ Followers

Pages

Saturday, May 19, 2012

Recover of missing controlfile

Problem Generation


i. Shutdown the Database
SQL> SHUTDOWN immediate;

ii. Delete Control file control01.ctl from operating system
[oracle@odb]$ rm -i /u01/app/oracle/oradata/disk1/ocmdb/control01.ctl

iii. Startup Database.
SQL> STARTUP;
ORACLE instance started.
Total System Global Area  536870912 bytes
Fixed Size               1220460 bytes
Variable Size          218103956 bytes
Database Buffers       314572800 bytes
Redo Buffers             2973696 bytes
ORA-00205: error in identifying control file, check alert log for more info


Solution

i. Check the control file location
SQL> SHOW PARAMETER control
NAME                              TYPE     VALUE
———————————— ———– ——————————
control_file_record_keep_time     integer 7
control_files                     string   /u01/app/oracle/oradata/disk1/
                                             ocmdb/control01.ctl, /u01/app/
                                            oracle/admin/ocmdb/control/con
                                           trol02.ctl


ii. Copy control01.ctl from control02.ctl
[oracle@odb]$ cp /u01/app/oracle/admin/ocmdb/control/control02.ctl /u01/app/oracle/oradata/disk1/ocmdb/control01.ctl


iii. Mount the Database and Open it.
SQL> ALTER DATABASE MOUNT;
SQL> ALTER DATABASE OPEN;

No comments:

Post a Comment