Please Help with Corrupt DR01.DBF

From: Phil Murnane <pjmurnane_at_yahoo.com>
Date: 14 Feb 2002 15:09:53 -0800
Message-ID: <1052ac4d.0202141509.1da88d3b@posting.google.com>

Folks:

Windows 2000 Server
Oracle 8.1.7

We had an instance crash, and now we can't seem to bring it back. After a startup attempt, the sidALRT.LOG would show "ORA-1122 signalled during: alter database open..." Several documents referred to a possible corrupt control file, so we tried to create a new control file using the "alter database backup controlfile to trace" method.

During execution of the resulting script, we received ORA-01210 & ORA-01110 regarding the DR01.DBF file (see below).

Is there any way to recover from this? All other .dbf files are okay according to dbverify (dbv).

Here's the attempt to create the control file: SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 14 14:27:13 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

SQL> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first SQL> alter database backup controlfile to trace;

Database altered.

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> @c:\oracle\new_control.sql
ORACLE instance started.

Total System Global Area 82622492 bytes

Fixed Size                    75804 bytes
Variable Size              56999936 bytes
Database Buffers           25468928 bytes
Redo Buffers                  77824 bytes

CREATE CONTROLFILE REUSE DATABASE "THEBEAST" NORESETLOGS NOARCHIVELOG *
ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed
ORA-01210: data file header is media corrupt
ORA-01110: data file : 'C:\ORACLE\ORADATA\THEBEAST\DR01.DBF'

SP2-0734: unknown command beginning "Recovery i..." - rest of line ignored.
SP2-0734: unknown command beginning "or if the ..." - rest of line ignored.
ORA-01507: database not mounted

SP2-0734: unknown command beginning "Database c..." - rest of line ignored.
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01507: database not mounted

SP2-0734: unknown command beginning "No tempfil..." - rest of line ignored.
SQL> Here's the dbverify output:
C:\oracle\oradata\thebeast>for %f in (*.dbf) do dbv file=%f blocksize=8192

C:\oracle\oradata\thebeast>dbv file=DR01.DBF blocksize=8192 1>>\temp.txt

DBVERIFY: Release 8.1.7.0.0 - Production on Thu Feb 14 15:01:04 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = DR01.DBF Page 1 is marked corrupt
***
Corrupt block relative dba: 0x01c00001 (file 0, block 1) Bad check value found during dbv:
Data in bad block -
 type: 11 format: 2 rdba: 0x01c00001
 last change scn: 0x0000.00000000 seq: 0x1 flg: 0x04  consistency value in tail: 0x00000b01
 check value in block header: 0x3844, computed block checksum: 0x4b70  spare1: 0x0, spare2: 0x0, spare3: 0x0
***

DBVERIFY - Verification complete

Total Pages Examined         : 2560
Total Pages Processed (Data) : 10
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 42
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 99
Total Pages Empty            : 2408
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 0

C:\oracle\oradata\thebeast>dbv file=INDX01.DBF blocksize=8192 1>>\temp.txt

DBVERIFY: Release 8.1.7.0.0 - Production on Thu Feb 14 15:01:04 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = INDX01.DBF

DBVERIFY - Verification complete

Total Pages Examined         : 2560
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1
Total Pages Empty            : 2559
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

C:\oracle\oradata\thebeast>dbv file=RBS01.DBF blocksize=8192 1>>\temp.txt

DBVERIFY: Release 8.1.7.0.0 - Production on Thu Feb 14 15:01:05 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = RBS01.DBF

DBVERIFY - Verification complete

Total Pages Examined         : 6400
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 6337
Total Pages Empty            : 63
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

C:\oracle\oradata\thebeast>dbv file=SYSTEM01.DBF blocksize=8192 1>>\temp.txt

DBVERIFY: Release 8.1.7.0.0 - Production on Thu Feb 14 15:01:07 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = SYSTEM01.DBF

DBVERIFY - Verification complete

Total Pages Examined         : 35072
Total Pages Processed (Data) : 24213
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 7156
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 928
Total Pages Empty            : 2775
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

C:\oracle\oradata\thebeast>dbv file=TEMP01.DBF blocksize=8192 1>>\temp.txt

DBVERIFY: Release 8.1.7.0.0 - Production on Thu Feb 14 15:01:21 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = TEMP01.DBF

DBVERIFY - Verification complete

Total Pages Examined         : 2560
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 153
Total Pages Empty            : 2407
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

C:\oracle\oradata\thebeast>dbv file=TOOLS01.DBF blocksize=8192 1>>\temp.txt

DBVERIFY: Release 8.1.7.0.0 - Production on Thu Feb 14 15:01:22 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = TOOLS01.DBF

DBVERIFY - Verification complete

Total Pages Examined         : 1280
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1
Total Pages Empty            : 1279
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

C:\oracle\oradata\thebeast>dbv file=USERS01.DBF blocksize=8192 1>>\temp.txt

DBVERIFY: Release 8.1.7.0.0 - Production on Thu Feb 14 15:01:22 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = USERS01.DBF

DBVERIFY - Verification complete

Total Pages Examined         : 2560
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 1
Total Pages Empty            : 2559
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

C:\oracle\oradata\thebeast>

Thanks in Advance,
--Phil Received on Thu Feb 14 2002 - 17:09:53 CST