OraDataSystems.com

Thursday, November 11, 2010

Recover from corruption of single control file

RECOVER CONTROL FILE; MULTIPLEXED COPIES OF CONTROL FILE EXISTS

SQL> /
alter system switch logfile
*
ERROR at line 1:
ORA-00227: corrupt block detected in control
file: (block , # blocks )

Hex dump of (file 0, block 1) in trace file c:\oracle\product\10.2.0\admin\orcln
ew\bdump\orclnew_lgwr_3352.trc
Corrupt block relative dba: 0x00000001 (file 0, block 1)
Fractured block found during control file header read
Data in bad block:
type: 0 format: 0 rdba: 0x00000000
last change scn: 0x0000.00000000 seq: 0x0 flg: 0x00
spare1: 0x0 spare2: 0x0 spare3: 0x2400
consistency value in tail: 0x00000000
check value in block header: 0x0
block checksum disabled
Tue Oct 13 11:34:08 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_lgwr_3352.tr
c:
ORA-00202: control file: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\CONTROL01.CTL
'

Tue Oct 13 11:34:09 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_lgwr_3352.tr
c:
ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)
ORA-00202: control file: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLNEW\CONTROL01.CTL
'

LGWR: terminating instance due to error 227
Tue Oct 13 11:34:09 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_q001_3532.tr
c:
ORA-00227: corrupt block detected in control file: (block , # blocks )

Tue Oct 13 11:34:09 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_pmon_6136.tr
c:
ORA-00227: corrupt block detected in control file: (block , # blocks )

Tue Oct 13 11:34:10 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_j000_716.trc
:
ORA-00227: corrupt block detected in control file: (block , # blocks )

Tue Oct 13 11:34:10 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_dbw0_5260.tr
c:
ORA-00227: corrupt block detected in control file: (block , # blocks )

Tue Oct 13 11:34:10 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_psp0_2336.tr
c:
ORA-00227: corrupt block detected in control file: (block , # blocks )

Tue Oct 13 11:34:10 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_mman_4128.tr
c:
ORA-00227: corrupt block detected in control file: (block , # blocks )

Tue Oct 13 11:34:14 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_ckpt_128.trc
:
ORA-00227: corrupt block detected in control file: (block , # blocks )

Tue Oct 13 11:34:18 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_reco_4656.tr
c:
ORA-00227: corrupt block detected in control file: (block , # blocks )

Tue Oct 13 11:34:18 2009
Errors in file c:\oracle\product\10.2.0\admin\orclnew\bdump\orclnew_smon_948.trc
:
ORA-00227: corrupt block detected in control file: (block , # blocks )

COPY CONTROL02.CTL TO CONTROL01.CTL

sphilip@seadba01 /cygdrive/c/oracle/product/10.2.0/oradata/orclnew
$ ls -ltr CONTROL*
-rwx------+ 1 sphilip ???????? 7749632 Oct 13 11:34 CONTROL03.CTL
-rwx------+ 1 sphilip ???????? 7749632 Oct 13 11:34 CONTROL02.CTL
-rwx------+ 1 sphilip ???????? 4644319 Oct 13 11:34 CONTROL01.CTL

sphilip@seadba01 /cygdrive/c/oracle/product/10.2.0/oradata/orclnew
$ cp CONTROL02.CTL CONTROL01.CTL

sphilip@seadba01 /cygdrive/c/oracle/product/10.2.0/oradata/orclnew
$ ls -ltr CONTROL*
-rwx------+ 1 sphilip ???????? 7749632 Oct 13 11:34 CONTROL03.CTL
-rwx------+ 1 sphilip ???????? 7749632 Oct 13 11:34 CONTROL02.CTL
-rwx------ 1 sphilip mkgroup-l-d 7749632 Oct 13 11:37 CONTROL01.CTL

sphilip@seadba01 /cygdrive/c/oracle/product/10.2.0/oradata/orclnew

SQL> startup
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1294680 bytes
Variable Size 461377192 bytes
Database Buffers 603979776 bytes
Redo Buffers 7090176 bytes
Database mounted.
Database opened.

No comments:

Post a Comment