| Please Help with Corrupt DR01.DBF [message #49866] |
Thu, 14 February 2002 13:08  |
Phil Murnane
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
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:oraclenew_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:ORACLEORADATATHEBEASTDR01.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:oracleoradatathebeast>for %f in (*.dbf) do dbv file=%f blocksize=8192
C:oracleoradatathebeast>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:oracleoradatathebeast>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:oracleoradatathebeast>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:oracleoradatathebeast>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:oracleoradatathebeast>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:oracleoradatathebeast>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:oracleoradatathebeast>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:oracleoradatathebeast>
Thanks in Advance,
--Phil
|
|
|
|
| Re: Please Help with Corrupt DR01.DBF [message #49890 is a reply to message #49866] |
Fri, 15 February 2002 07:49  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
It isn't your control file. When you do the "alter database backup controlfile to trace" it goes out to each file header and it found DR01.DBF to be corrupt. Based on your DBVERIFY output all your data should be in tact. Read 28814.1 Handling Oracle Block Corruption in 7/8/8i/9i.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
