Control file recovery

As we can see above pic there is not available the control file, let’s try for recovery.

Now let’s try to connect with database ……

[oracle@localhost ~]$ sqlplus /as sysdba

As you can see above pic it’s appearing the ERROR .. ORA-00205

Let’s try to resolve it.

First of all let’s see how to find out error by error number,

[oracle@localhost ~]$ oerr ora 00205

Now let’s check the alert file

[oracle@localhost ~]$ cat /etc/oratab

[oracle@localhost trace]$ ls –ltr

[oracle@localhost trace]$ tail -100f alert_prod.log

SQL> show parameter control

SQL>exit

[oracle@localhost ~]$ cd /u01/app/oracle/oradata/prod/

[oracle@localhost prod]$ ls -l

[oracle@localhost ~]$ cd /u01/app/oracle/fast_recovery_area/prod/

[oracle@localhost prod]$ ls -l

[oracle@localhost prod]$ cp control02.ctl /u01/app/oracle/oradata/prod/control01.ctl

[oracle@localhost prod]$ cd /u01/app/oracle/oradata/prod/

[oracle@localhost prod]$ ls -ltr

SQL> alter database mount;

SQL> alter database open;

SQL> select open_mode from v$database;

SQL> select name from v$controlfile;

IT Tidings