現場故障案例：控制文件損壞

時間

目的

操作

09:50

正常巡檢，開啟告警日志，

檢查數據庫時間、狀態

#tail -f /u01/app/oracle/admin/metro/bdump/alert_metro.log

SQL> SELECT sysdate from dual;

SYSDATE

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

21-05-14 09:50:24

SQL> select status from v$instance;

STATUS

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

OPEN

09:51

發現告警日志中

一條cannot提示信息

Wed May 21 09:47:15 2014

Thread 1 cannot allocate new log, sequence 104

Checkpoint not complete

Current log# 3 seq# 103 mem# 0: /u01/app/oracle/oradata/metro/redo03.log

Current log# 3 seq# 103 mem# 1: /disk1/metro/redofile/redo03a.log

Thread 1 advanced to log sequence 104

Current log# 1 seq# 104 mem# 0: /u01/app/oracle/oradata/metro/redo01.log

Current log# 1 seq# 104 mem# 1: /disk1/metro/redofile/redo01a.log

09:53

發現告警日志中

連續出現ORA-00202告警信息

Wed May 21 09:53:25 2014

Hex dump of (file 0, block 1) in trace file /u01/app/oracle/admin/metro/bdump/metro_arc0_385212.trc

Corrupt block relative dba: 0x00000001 (file 0, block 1)

Completely zero block found during control file header read

Wed May 21 09:53:25 2014

Errors in file /u01/app/oracle/admin/metro/bdump/metro_arc0_385212.trc:

ORA-00202: control file: '/disk2/metro/control_file/control03.ctl'

Wed May 21 09:53:26 2014

Errors in file /u01/app/oracle/admin/metro/bdump/metro_arc0_385212.trc:

ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)

ORA-00202: control file: '/disk2/metro/control_file/control03.ctl'

10:10

到數據庫下進行手工歸檔，

報錯并斷開連接

SQL> alter system switch logfile;

alter system switch logfile

*

ERROR at line 1:

ORA-03135: connection lost contact

10:12

嘗試啟庫，失敗，報錯

SQL> startup

ORACLE instance started.

Total System Global Area 612368384 bytes

Fixed Size 2022800 bytes

Variable Size 226493040 bytes

Database Buffers 377487360 bytes

Redo Buffers 6365184 bytes

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

10:13

根據啟庫時提示信息

及告警日志信息，

初判控制文件存在問題

啟庫時提示：

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

告警日志中提示：

ORA-00202: control file: '/disk2/metro/control_file/control03.ctl'

10:16

根據提示轉儲disk2下控制文件

[oracle@aix203]$cd /disk2/metro/control_file

[oracle@aix203]$ls

control03.ctl

[oracle@aix203]$mv control03.ctl control03.ctl.bak

[oracle@aix203]$cd /disk1/metro/control_file

[oracle@aix203]$ls

control02.ctl

[oracle@aix203]$cp control02.ctl /disk2/metro/control_file/control03.ctl

10:19

啟庫，成功

SQL> startup;

ORACLE instance started.

Total System Global Area 612368384 bytes

Fixed Size 2022800 bytes

Variable Size 226493040 bytes

Database Buffers 377487360 bytes

Redo Buffers 6365184 bytes

Database mounted.

Database opened.

10:20

刪除有問題的控制文件

[oracle@aix203]$ls

control03.ctl control03.ctl.bak

[oracle@aix203]$rm control03.ctl.bak

[oracle@aix203]$ls

control03.ctl

10:22

0級全備

[oracle@aix203]$cd /home/oracle/

[oracle@aix203]$ls

ctl.sh scripts smit.log smit.script smit.transaction

[oracle@aix203]$cd scripts

[oracle@aix203]$ls

bin log tmp

[oracle@aix203]$cd bin

[oracle@aix203]$ls

rmanlevel0.sh rmanlevel0.sh.bak rmanlevel1.sh rmanlevel1.sh.bak

[oracle@aix203]$sh rmanlevel0.sh

10:28

完成全備

10:29

切歸檔

SQL> alter system archive log current;

System altered.