ORA-00227: corrupt block detected in control file: (block 16, # blocks 1)
解决办法:重建控制文件
[oracle@OCPLHR dbs]$ sas
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 29 14:57:47 2019
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@OCPLHR1> startup force
ORACLE instance started.
Total System Global Area 626327552 bytes
Fixed Size 2230952 bytes
Variable Size 553649496 bytes
Database Buffers 62914560 bytes
Redo Buffers 7532544 bytes
ORA-00227: corrupt block detected in control file: (block 16, # blocks 1)
ORA-00202: control file: '/u01/app/oracle/oradata/OCPLHR1/control01.ctl'
[oracle@OCPLHR dbs]$
[oracle@OCPLHR dbs]$ cp snapcf_OCPLHR1.f /u01/app/oracle/oradata/OCPLHR1/control01.ctl
[oracle@OCPLHR dbs]$ sas
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 29 15:06:26 2019
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@OCPLHR1> alter database backup controlfile to trace as '/home/oracle/ctl.txt';
Database altered.
SYS@OCPLHR1> startup force nomount
ORACLE instance started.
Total System Global Area 626327552 bytes
Fixed Size 2230952 bytes
Variable Size 553649496 bytes
Database Buffers 62914560 bytes
Redo Buffers 7532544 bytes
SYS@OCPLHR1> CREATE CONTROLFILE REUSE DATABASE "OCPLHR1" NORESETLOGS ARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 292
7 LOGFILE
8 GROUP 1 '/u01/app/oracle/oradata/OCPLHR1/redo01.log' SIZE 50M BLOCKSIZE 512,
9 GROUP 2 '/u01/app/oracle/oradata/OCPLHR1/redo02.log' SIZE 50M BLOCKSIZE 512,
10 GROUP 3 '/u01/app/oracle/oradata/OCPLHR1/redo03.log' SIZE 50M BLOCKSIZE 512
11 -- STANDBY LOGFILE
12 DATAFILE
13 '/u01/app/oracle/oradata/OCPLHR1/system01.dbf',
14 '/u01/app/oracle/oradata/OCPLHR1/sysaux01.dbf',
15 '/u01/app/oracle/oradata/OCPLHR1/undotbs01.dbf',
16 '/u01/app/oracle/oradata/OCPLHR1/users01.dbf',
17 '/u01/app/oracle/oradata/OCPLHR1/example01.dbf',
18 '/u01/app/oracle/oradata/OCPLHR1/a.dbf',
19 '/u01/app/oracle/oradata/OCPLHR1/ocplhr1_test01.dbf',
20 '/u01/app/oracle/oradata/OCPLHR1/trpdata.dbf'
21 CHARACTER SET ZHS16GBK
22 ;
Control file created.
SYS@OCPLHR1>
SYS@OCPLHR1> startup force
ORACLE instance started.
Total System Global Area 626327552 bytes
Fixed Size 2230952 bytes
Variable Size 553649496 bytes
Database Buffers 62914560 bytes
Redo Buffers 7532544 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/OCPLHR1/system01.dbf'
SYS@OCPLHR1> recover database;
Media recovery complete.
SYS@OCPLHR1>
SYS@OCPLHR1> alter database open;
alter database open
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [0], [3545903], [0], [3551857], [12583040], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [0], [3545902], [0], [3551857], [12583040], [], [], [], [], [], []
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [0], [3545900], [0], [3551857], [12583040], [], [], [], [], [], []
Process ID: 14562
Session ID: 96 Serial number: 3
SYS@OCPLHR1> startup force
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SYS@OCPLHR1> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@OCPLHR dbs]$
[oracle@OCPLHR dbs]$
[oracle@OCPLHR dbs]$ sas
SQL*Plus: Release 11