Recover of missing controlfile / Copy other controlfile and mount database


Problem Generation

i. Shutdown the Database
SQL> SHUTDOWN immediate;

ii. Delete Control file control01.ctl from operating system
[oracle@anar]$ rm -i /u01/app/oracle/oradata/disk1/anardb/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/
anardb/control01.ctl, /u01/app/
oracle/admin/anardb/control/con
trol02.ctl

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

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

4 comments

  1. Good day, Anar. What if the files like control02.ctl is missing?

    SQL> show parameter control_files

    NAME TYPE
    ———————————— ———————————
    control_files string

    VALUE
    ——————————
    /u01/app/oracle/product/11.2.0/xe/dbs/ora_control1, /u01/app/oracle/product/11.2.0/xe/dbs/ora_control2

    # ls
    control.dbf sysaux.dbf system.dbf temp.dbf undotbs1.dbf users.dbf

    Thanks

  2. Thank you, very good video.

  3. Thank you. You are welcome!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: