oracle 11g 断电 ora-00214 故障恢复一例
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1185853440 bytes
Fixed Size 2252664 bytes
Variable Size 956301448 bytes
Database Buffers 218103808 bytes
Redo Buffers 9195520 bytes
ORA-00214: control file 'e:\app\Administrator\flash_recovery_area\glis10\control02.ctl' version 1323
inconsistent with file 'e:\app\Administrator\oradata\glis10\control01.ctl' version 1298
create pfile='e:\1.ora' from spfile;
修改 1.ora 控制文件只保留 e:\app\Administrator\flash_recovery_area\glis10\control02.ctl
使用 pfile 启动数据库
sqlplus /nolog
connect / as sysdba
shutdown abort
startup pfile='e:\1.ora'
ORA-00600: [kcratr_scan_lastbwr]
出现
ORA-00600: [kcratr_scan_lastbwr]
SQL>shutdown abort
SQL>startup pfile='e:\1.ora' mount
SQL>recover database
SQL>alter database open
正常打开数据库
关闭数据库
备份 control01.ctl
使用 e:\app\Administrator\flash_recovery_area\glis10\control02.ctl 覆盖 control01.ctl ,重新启动数据库,正常恢复数据库。
检查系统自动备份脚本,备份数据库,启动应用结束系统故障处理。