Oracle 9i System file get corrupted. How to remove the corruption.
534533Oct 13 2008 — edited Oct 14 2008Hello,
I am facing problem during backup of oracle database (Oracle 9i, 32 bit windows). Pls see the following error messages.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sep 16 10:48:41 mnmccbr.mci.sc: * mnmcfs.mci.sc:E:\SC\SC12.1\Databases\Oracleconfig\oraBackupNM45 ORA-19566:
exceeded limit of 0 corrupt blocks for file E:\SC\SC12.1\DATABASES\ORACLECONFIG\SYS1NM45.ORA
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Output of dbverify.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DBVERIFY: Release 9.2.0.6.0 - Production on Sat Oct 11 09:40:42 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = E:\SC\SC12.1\DATABASES\ORACLECONFIG\SYS1NM45.ORA
Page 28093 is marked corrupt ***
Corrupt block relative dba: 0x00406dbd (file 1, block 28093)
Bad check value found during dbv:
Data in bad block -
type: 6 format: 2 rdba: 0x00406dbd
last change scn: 0x0000.09abd22e seq: 0x2 flg: 0x06
consistency value in tail: 0xd22e0602
check value in block header: 0x8b91, computed block checksum: 0x800
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
DBVERIFY - Verification complete
Total Pages Examined : 31616
Total Pages Processed (Data) : 21138
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 7246
Total Pages Failing (Index): 0
Total Pages Processed (Other): 1451
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 1780
Total Pages Marked Corrupt : 1
Total Pages Influx : 0
Highest block SCN : 224578617 (0.224578617)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The Backup is enabled in our machine but we are not able to take backup since we we get the error (6 Sept). I am not sure whether archive log are available since 6th Sept. Even oracle is working fine but backup is not possible.
Pls note that this is customer testbed. Any idea to remove the corruption from the system file.
Thanks
With Regards
Hemant Joshi