db startup fails because of ORA-01578, help!

From: <fraund_at_uiuc.edu>
Date: 30 Mar 2007 22:32:12 -0700
Message-ID: <1175319132.472368.142530@o5g2000hsb.googlegroups.com>

I had been having problems trying to repair a bad block with dbms_repair, so i shutdown the database, ran dbverify which showed that it was the only affected block:

Page 50619 is marked corrupt
Corrupt block relative dba: 0x0040c5bb (file 1, block 50619) Bad check value found during dbv:
Data in bad block:
 type: 6 format: 2 rdba: 0x0040c5bb
 last change scn: 0x0000.04c8c7cc seq: 0x1 flg: 0x06  spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xc7cc0601
 check value in block header: 0x6140
computed block checksum: 0x2000

...but then the database would not start up and checking the alert log, it is the bad block keeping the database from opening!

SMON: enabling cache recovery
Fri Mar 30 23:56:07 2007
Successfully onlined Undo Tablespace 1.
Fri Mar 30 23:56:07 2007
SMON: enabling tx recovery
Fri Mar 30 23:56:07 2007

---

WARNING: The following temporary tablespaces contain no files.

         This condition can occur when a backup controlfile has
         been restored.  It may be necessary to add files to these
         tablespaces.  That can be done using the SQL statement:

         ALTER TABLESPACE <tablespace_name> ADD TEMPFILE

         Alternatively, if these temporary tablespaces are no longer
         needed, then they can be dropped.
           Empty temporary tablespace: TEMP


*********************************************************************

Database Characterset is WE8ISO8859P15
Fri Mar 30 23:56:07 2007
Hex dump of (file 1, block 50619) in trace file /home/oracle/product/ 10.1.0/Db_1/rdbms/log/wg73_smon_14415.trc Corrupt block relative dba: 0x0040c5bb (file 1, block 50619) Bad check value found during buffer read Data in bad block:
 type: 6 format: 2 rdba: 0x0040c5bb
 last change scn: 0x0000.04c8c7cc seq: 0x1 flg: 0x06  spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xc7cc0601
 check value in block header: 0x6140
computed block checksum: 0x2000
Reread of rdba: 0x0040c5bb (file 1, block 50619) found same corrupted data
Fri Mar 30 23:56:07 2007
Errors in file /home/oracle/product/10.1.0/Db_1/rdbms/log/ wg73_smon_14415.trc:

ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 50619)
ORA-01110: data file 1: '/home/oracle/databases/WG73/system.dbf'

Fri Mar 30 23:56:07 2007
Errors in file /home/oracle/product/10.1.0/Db_1/rdbms/log/ wg73_ora_14421.trc:
ORA-01578: ORACLE data block corrupted (file # 1, block # 50619) ORA-01110: data file 1: '/home/oracle/databases/WG73/system.dbf' Fri Mar 30 23:56:07 2007
Error 1578 happened during db open, shutting down database USER: terminating instance due to error 1578 Instance terminated by USER, pid = 14421 ORA-1092 signalled during: ALTER DATABASE OPEN...

I need to get the database up and running by Monday. There is currently no database backup. Is there any way to repair the block on a closed database? Or start it up ignoring the 01578 error? Please advise.

Philipp Received on Sat Mar 31 2007 - 00:32:12 CDT