Re: db startup fails because of ORA-01578, help!

On 30 Mar 2007 22:32:12 -0700, "fraund_at_uiuc.edu" <fraund_at_uiuc.edu> wrote:

>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

You probably don't want to hear this.
Right now there are 2 scenarios.
1 ) Get an export (hopefully you have one), recreate the database and import your export
2) Get in Oracle Technical Support with DUL. This will cost you $$ and probably they won't arrive on the spot immediately.

If you can't execute scenario 1, you probably have something to explain for. I can't help it.

-- 
Sybrand Bakker
Senior Oracle DBA