Detailed using Backup Controlfile

The using Backup controlfile is typically used to recover from a situation where the current control file is missing and the previously backed up control file is more than currently changed. Using Backup Controlfile

Recover way once used, the commonly used recover database commands will no longer be available, and you must use the Resetlogs method to open the database, the following is a detailed description of the presentation.

I. Presentation of related changes when using Backup Controlfile

--> View the time information of the database Sybo2sz control file

Sys@sybo2sz> Ho ls-hltr/u02/database/sybo2sz/controlf/

Total 29M

-RW-R-----1 Oracle oinstall 9.7M 2012-09-10 11:59 cntl3sybo2sz.ctl

-RW-R-----1 Oracle oinstall 9.7M 2012-09-10 11:59 cntl2sybo2sz.ctl

-RW-R-----1 Oracle oinstall 9.7M 2012-09-10 11:59 cntl1sybo2sz.ctl

--> View System time

Sys@sybo2sz> Ho Date

Mon Sep 12:00:09 CST 2012

--> view the state of the database Sybo2sz, at which time the database is turned off

Sys@sybo2sz> Ho Ps-ef | grep Pmon_sybo2sz

Oracle 440 32067 0 12:01 pts/4 00:00:00/bin/bash-c ps-ef | grep Pmon_sybo2sz

Oracle 442 440 0 12:01 PTS/4 00:00:00 grep pmon_sybo2sz

sys@sybo2sz> startup Mount;

ORACLE instance started.

Total System Global area 599785472 bytes

Fixed Size 2074568 bytes

Variable Size 381683768 bytes

Database buffers 209715200 bytes

Redo buffers 6311936 bytes

Database mounted.

--> the state and time information of the control file is updated when the database is Mount

Sys@sybo2sz> Ho ls-hltr/u02/database/sybo2sz/controlf/

Total 29M

-RW-R-----1 Oracle oinstall 9.7M 2012-09-10 12:02 cntl3sybo2sz.ctl

-RW-R-----1 Oracle oinstall 9.7M 2012-09-10 12:02 cntl2sybo2sz.ctl

-RW-R-----1 Oracle oinstall 9.7M 2012-09-10 12:02 cntl1sybo2sz.ctl

Sys@sybo2sz> select Instance_name,status,database_status from V$instance;

instance_name STATUS Database_status

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

Sybo2sz Mounted ACTIVE

--> this time the database file has not been updated, still 11:23

Sys@sybo2sz> Ho ls-hltr/u02/database/sybo2sz/oradata/sys*

-RW-R-----1 Oracle oinstall 501M 2012-09-10 11:23/u02/database/sybo2sz/oradata/syssybo2sz.dbf

-RW-R-----1 Oracle oinstall 301M 2012-09-10 11:23/u02/database/sybo2sz/oradata/sysauxsybo2sz.dbf

Sys@sybo2sz> alter session set nls_date_format= ' Yyyymmdd hh24:mi:ss ';

-->author:robinson Cheng-->blog: <a href= "http://blog.csdn.net/robinson_0612" >http://blog.csdn.net/ robinson_0612

</A>--> can also see at this time Controlfile_type is current,open_resetlogs to not allowed

Sys@sybo2sz> SELECT Controlfile_type, controlfile_sequence#, Controlfile_change#,controlfile_time,open_ Resetlogs

2 from V$database;

Control controlfile_sequence# controlfile_change# Controlfile_time open_resetl

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

Current 6012 1151639 20120910 04:30:14 not allowed

--> using the Recover command with the using Backup Controlfile, the Specify log hint appears

--> Another session is now connected to the instance, and the following SQL prompt, which starts with Idle, is another session

sys@sybo2sz> Recover database using Backup controlfile;

Ora-00279:change 1160803 generated at 09/10/2012 11:23:59 for thread 1

Ora-00289:suggestion:/u02/database/sybo2sz/archive/arch_793474012_1_3.arc