Control file Recovery with backup

CP +data/ora11g/backup/control01.ctl +data/ora11g/controlfile/control01.ctl

Alter system set control_files= ' +data/ora11g/controlfile/control01.ctl ' scope=spfile;

Shutdown immediate

Startup Mount

Select Group#,status from V$log;

Select Group#,member from V$logfile;

Select group#,thread#,sequence# from V$archive;

Recover database using Backup controlfile until cancel;

ALTER DATABASE open resetlogs;

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

Example

ALTER DATABASE backup Controlfile to ' +data/ora11g/backup/control01.ctl ';

ALTER DATABASE backup Controlfile to trace;

ALTER DATABASE backup Controlfile to trace as '/u02/app/trace123.trc ';

[Email protected] trace]$ pwd

/u02/app/diag/rdbms/ora11g/ora11g/trace

[[email protected] trace]$ LS-TL view time Recent trace file (ORA11G_ORA_*.TRC) with all commands to create control files

Total 968

-RW-R-----1 Oracle asmadmin 20320 DEC 10:31 ora11g_mmon_3942.trc

-RW-R-----1 Oracle asmadmin 2198 DEC 10:31 ORA11G_MMON_3942.TRM

-RW-R-----1 Oracle asmadmin 48189 DEC 10:18 alert_ora11g.log

-RW-R-----1 Oracle asmadmin 6959 DEC 10:18 ora11g_ora_31212.trc

-RW-R-----1 Oracle asmadmin 194 DEC 10:18 ORA11G_ORA_31212.TRM

[Email Protected]>startup

ORACLE instance started.

Total System Global area 830930944 bytes

Fixed Size 2231048 bytes

Variable Size 629146872 bytes

Database buffers 192937984 bytes

Redo buffers 6615040 bytes

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

CP +data/ora11g/backup/control01.ctl +data/ora11g/controlfile/control01.ctl

Alter system set control_files= ' +data/ora11g/controlfile/control01.ctl ' scope=spfile;

[Email protected]>alter database mount;

ERROR at line 1:

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

[Email Protected]>shutdown Immediate

Ora-01507:database not mounted

ORACLE instance shut down.

[Email Protected]>startup Mount

ORACLE instance started.

Total System Global area 830930944 bytes

Fixed Size 2231048 bytes

Variable Size 629146872 bytes

Database buffers 192937984 bytes

Redo buffers 6615040 bytes

Database mounted.

[Email protected]>select group#,status from V$log;

group# STATUS

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

1 INACTIVE

3 INACTIVE

2 Current

[Email protected]>select group#,member from V$logfile;

group# MEMBER

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

3 +data/ora11g/onlinelog/group_3.266.833721683

3 +data/ora11g/onlinelog/group_3.267.833721685

2 +data/ora11g/onlinelog/group_2.264.833721681

2 +data/ora11g/onlinelog/group_2.265.833721683

1 +data/ora11g/onlinelog/group_1.262.833721677

1 +data/ora11g/onlinelog/group_1.263.833721679

[Email protected]>select group#,thread#,sequence# from v$archive;

[Email protected]>recover database using Backup controlfile until cancel;

Ora-00279:change 1104788 generated at 12/11/2013 13:27:34 needed for thread 1

Ora-00289:suggestion: +data

Ora-00280:change 1104788 for thread 1 are in sequence #8

Specify log: {<ret>=suggested | AUTO | CANCEL}

+data/ora11g/onlinelog/group_2.264.833721681

Log applied.

Media recovery complete.

[Email protected]>recover database using Backup controlfile until cancel;

Ora-00279:change 1105381 generated at 12/19/2013 11:07:09 needed for thread 1

Ora-00289:suggestion: +data

Ora-00280:change 1105381 for thread 1 are in sequence #8

Specify log: {<ret>=suggested | AUTO | CANCEL}

+data/ora11g/onlinelog/group_2.265.833721683

Log applied.

Media recovery complete.

[Email protected]>alter database open resetlogs;

Database altered.

Control file Recovery with backup