Oracle控制檔案在缺失歸檔日誌的情況下的恢復

眾所周知，恢復控制檔案時“recover database”命令可能需要使用歸檔日誌。所謂缺失歸檔日誌，是指控制檔案從備份還原之後，在執行“recover database”命令恢復時報告找不到相應的日誌導致恢復終止的情況。

這種情況下的恢復操作主要步驟如下：

①　首先還原控制檔案，方式不限

②　執行“recover database”命令將報RMAN-06054錯誤，即找不到某歸檔日誌

③　檢視相關的動態效能檢視，對問題定位，確認問題與控制檔案，而不是資料檔案相關（與資料檔案相關必須進行不完全恢復）

④　利用create controlfile 命令重建控制檔案

⑤　再次執行“recover database”命令，還會報RMAN-06054錯誤，這次是找不到另一個歸檔日誌，其序列號應該大於第二步中的

⑥　檢視v$log檢視確定第5步中所要的是哪個日誌

⑦　執行SQLPLUS的”recover database using backup controlfile“命令，等”Specify log：“提示符出現後給出正確的線上日誌路徑，直到命令成功結束。

⑧　以resetlogs方式開啟資料庫

⑨　由於建立的控制檔案內不會有臨時資料檔案的資訊，需要重新將其新增回臨時表空間

⑩　將控制檔案內其他丟失的資訊用catalog和configure等命令再新增回去。

當前current日誌序列號為：5，此時進行控制檔案備份

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch

Oldest online log sequence 3

Next log sequence to archive 5

Current log sequence 5

SQL>

RMAN> backup current controlfile;

Starting backup at 2015-02-04 16:28:13

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_1: starting piece 1 at 2015-02-04 16:28:14

channel ORA_DISK_1: finished piece 1 at 2015-02-04 16:28:15

piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/1vpuel4t_1_1 tag=TAG20150204T162813 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 2015-02-04 16:28:15

RMAN>

多次切換日誌後，現在的CURRENT日誌是20號，所有控制檔案丟失並且第15號歸檔日誌丟失，資料庫啟動後停留在了nomount狀態：

SQL> alter system switch logfile;

。。。。。。。。

System altered.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch

Oldest online log sequence 18

Next log sequence to archive 20

Current log sequence 20

SQL>

RMAN> delete archivelog sequence 15;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=257 device type=DISK

List of Archived Log Copies for database with db_unique_name LILOVE

=====================================================================

Key Thrd Seq S Low Time

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

44 1 15 X 2015-02-04 16:29:58

Name: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_15_870711361.dbf

Do you really want to delete the above objects (enter YES or NO)? yes

deleted archived log

archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_15_870711361.dbf RECID=44 STAMP=870798598

Deleted 1 objects

RMAN>

[root@rhel6_lhr ~]# ll /u01/app/oracle/oradata/utf8test/*

-rw-r----- 1 oracle asmadmin 10076160 Feb 4 16:40 /u01/app/oracle/oradata/utf8test/control01.ctl

-rw-r----- 1 oracle oinstall 10076160 Feb 4 16:40 /u01/app/oracle/oradata/utf8test/control02.ctl

-rw-r----- 1 oracle asmadmin 52429312 Feb 4 16:30 /u01/app/oracle/oradata/utf8test/redo01.log

-rw-r----- 1 oracle asmadmin 52429312 Feb 4 16:40 /u01/app/oracle/oradata/utf8test/redo02.log

-rw-r----- 1 oracle asmadmin 52429312 Feb 4 16:30 /u01/app/oracle/oradata/utf8test/redo03.log

-rw-r----- 1 oracle asmadmin 608182272 Feb 4 16:39 /u01/app/oracle/oradata/utf8test/sysaux01.dbf

-rw-r----- 1 oracle asmadmin 775954432 Feb 4 16:39 /u01/app/oracle/oradata/utf8test/system01.dbf

-rw-r----- 1 oracle asmadmin 10493952 Feb 3 16:15 /u01/app/oracle/oradata/utf8test/tbs_read01.dbf

-rw-r----- 1 oracle asmadmin 20979712 Feb 4 11:15 /u01/app/oracle/oradata/utf8test/temp01.dbf

-rw-r----- 1 oracle asmadmin 52436992 Feb 4 16:39 /u01/app/oracle/oradata/utf8test/undotbs01.dbf

-rw-r----- 1 oracle asmadmin 10493952 Feb 4 16:30 /u01/app/oracle/oradata/utf8test/users01.dbf

[root@rhel6_lhr ~]# rm -rf /u01/app/oracle/oradata/utf8test/control0*