| ORA-00471: DBWR process terminated with error [message #291431] |
Fri, 04 January 2008 03:36  |
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
|
Senior Member |
 
|
|
Hi,
Last Sunday i upgraded my production database 9i R2 to 10g R2 (10.2.0.3.0).
But today morning around 3.30 PM my production database down.
May i know what's the problem?
| Quote: |
Fri Jan 04 03:37:33 2008
Hex dump of (file 2, block 9143) in trace file d:\oracle\admin\samidb\bdump\samidb_dbw0_1420.trc
Corrupt block relative dba: 0x008023b7 (file 2, block 9143)
Bad header found during preparing block for write
Data in bad block:
type: 2 format: 2 rdba: 0x008023b7
last change scn: 0x0000.16d3862b seq: 0xd flg: 0x00
spare1: 0x0 spare2: 0x0 spare3: 0x3d3
consistency value in tail: 0x862b020d
check value in block header: 0x0
block checksum disabled
Fri Jan 04 03:37:34 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_dbw0_1420.trc:
ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], []
Fri Jan 04 03:37:36 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_dbw0_1420.trc:
ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], []
DBW0: terminating instance due to error 471
Fri Jan 04 03:37:36 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_lgwr_1632.trc:
ORA-00471: DBWR process terminated with error
Fri Jan 04 03:37:36 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_pmon_632.trc:
ORA-00471: DBWR process terminated with error
Fri Jan 04 03:37:37 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_j000_3596.trc:
ORA-00471: DBWR process terminated with error
Fri Jan 04 03:37:37 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_mman_2892.trc:
ORA-00471: DBWR process terminated with error
Fri Jan 04 03:37:38 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_psp0_1000.trc:
ORA-00471: DBWR process terminated with error
Fri Jan 04 03:37:38 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_ckpt_356.trc:
ORA-00471: DBWR process terminated with error
Fri Jan 04 03:37:41 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_q001_3472.trc:
ORA-00471: DBWR process terminated with error
Fri Jan 04 03:37:44 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_reco_512.trc:
ORA-00471: DBWR process terminated with error
Fri Jan 04 03:37:45 2008
Errors in file d:\oracle\admin\samidb\bdump\samidb_smon_2992.trc:
ORA-00471: DBWR process terminated with error
Fri Jan 04 03:37:45 2008
Instance terminated by DBW0, pid = 1420
|
Babu
|
|
|
|
|
|
| Re: ORA-00471: DBWR process terminated with error [message #291456 is a reply to message #291440] |
Fri, 04 January 2008 04:56  |
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
|
Senior Member |
|
|
Thank you.
ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], []
There is no information in metalink. Actually i have one doubt. Any one of my datafile or datablock corrupted?
| Quote: |
Corrupt block relative dba: 0x008023b7 (file 2, block 9143)
|
Can you explain me the alert log information.
Thanks,
Babu B
|
|
|
|
| Re: ORA-00471: DBWR process terminated with error [message #291461 is a reply to message #291431] |
Fri, 04 January 2008 05:16 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
yes your data block is corrupted.but since you cannot mount your database hence cannot start block media recovery and hence nothing can be done at user's end especially when there is ORA-00600.
If you have metalink,contact and if not then reinstall oracle
|
|
|
|
|
|
|
|
| Re: ORA-00471: DBWR process terminated with error [message #291475 is a reply to message #291431] |
Fri, 04 January 2008 05:46 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
| Quote: |
Reinstalling will not change anything in block corruption
|
Why?
Block corruption means oracle internal error which is present with the current installation.
Reinstallation would be a fresh copy of oracle or to say a reincarnation of oracle.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
