由于主机中途断电,数据库启动报错:

ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/u01/oracle/oradata/lnumps/control01.ctl'
ORA-27072: File I/O error
Linux-x86_64 Error: 5: Input/output error
Additional information: 4
Additional information: 1
Additional information: -1

修改pfile用其他两个controlfile报同样错,估计是断电导致

以下重建:
CREATE CONTROLFILE REUSE DATABASE "lnumps" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/oracle/oradata/wichina/redo01.dbf' SIZE 50M,
GROUP 2 '/u01/oracle/oradata/wichina/redo02.dbf' SIZE 50M,
GROUP 3 '/u01/oracle/oradata/wichina/redo03.dbf' SIZE 50M
DATAFILE
'/u01/oracle/oradata/wichina/example01.dbf',
'/u01/oracle/oradata/wichina/sysaux01.dbf',
'/u01/oracle/oradata/wichina/system01.dbf',
'/u01/oracle/oradata/wichina/undotbs01.dbf',
'/u01/oracle/oradata/wichina/users01.dbf'
CHARACTER SET ZHS16GBK ;

RECOVER DATABASE

ALTER DATABASE OPEN;

正常打开...

ITPub博客

重建控制文件

最新文章