| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Please Help with Corrupt DR01.DBF
I might have wished you'd have trimmed some of the post down a bit!
DR01.DBF is indeed corrupt. So restore it from a prior backup (you can use dbv to verify that *that* version of the file is not corrupt), and then run your 'backup to trace' command once more. That trace file has a line in it that says 'recover database', so you'll get your file recovered for free at the same time as it reconstructs the relevant controlfiles.
And in future, it's a really, really bad idea to wait until your control files are corrupt before suddenly realising that backup to trace is rather a good idea. Do it nightly instead.
Regards
HJR
-- ---------------------------------------------- Resources for Oracle: http://www.hjrdba.com =============================== "Phil Murnane" <pjmurnane_at_yahoo.com> wrote in message news:1052ac4d.0202141509.1da88d3b_at_posting.google.com...Received on Thu Feb 14 2002 - 20:51:30 CST
> 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
 |
 |