现场故障 案例：控制文件损坏 本文出自 深蓝的blog 博客，若转载，请务必保留此出处：http://blog.csdn.net/huangyanlong 1、手工切归档时出错； 2、查看告警信息； 3、转储/disk2下的控制文件； 4、启库，切归档； 5、手工执行0级全备。 时间 目的 操作 09:
现场故障 案例：控制文件损坏
本文出自 “深蓝的blog” 博客，若转载，请务必保留此出处：http://blog.csdn.net/huangyanlong
1、手工切归档时出错；
2、查看告警信息；
3、转储/disk2下的控制文件；
4、启库，切归档；
5、手工执行0级全备。
时间
目的
操作
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.
原创作品，允许转载，转载时请务必注明出处（http://blog.csdn.net/huangyanlong）、作者信息和本声明 。关于涉及版权事宜，作者有权追究法律责任。