This discussion is archived
4 Replies Latest reply: Oct 16, 2012 11:22 PM by ancientDX RSS

ORA-00704: bootstrap process failure and SYSTEM datafile corrupt

jeff81 Newbie
Currently Being Moderated
We have an Oracle 10g Express database that is getting the following error on startup.

ORA-00704: bootstrap process failure

It is also showing that the SYSTEM datafile is corrupt. And unfortunately the backups are gone. Is there any way to recover from this without a backup? Maybe some hidden undocumented parameter???
We do have some full database exports from a couple weeks ago so it is not a complete loss but would really like a full recover.
  • 1. Re: ORA-00704: bootstrap process failure and SYSTEM datafile corrupt
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl post OS details and the last 100 lines from the alert log.

    Without valid backups, recovery is unlikely

    HTH
    Srini
  • 2. Re: ORA-00704: bootstrap process failure and SYSTEM datafile corrupt
    jeff81 Newbie
    Currently Being Moderated
    Windows XP

    We have tried allowresetlogs_corruption and allowread_only_corruption and no luck so far.

    ALTER DATABASE MOUNT
    Thu Aug 09 08:49:28 2012
    Setting recovery target incarnation to 2
    Thu Aug 09 08:49:28 2012
    Successful mount of redo thread 1, with mount id 2672004948
    Thu Aug 09 08:49:28 2012
    Database mounted in Exclusive Mode
    Completed: ALTER DATABASE MOUNT
    Thu Aug 09 08:49:50 2012
    alter database open upgrade
    Thu Aug 09 08:49:50 2012
    Beginning crash recovery of 1 threads
    Thu Aug 09 08:49:50 2012
    Started redo scan
    Thu Aug 09 08:49:50 2012
    Completed redo scan
    0 redo blocks read, 0 data blocks need recovery
    Thu Aug 09 08:49:50 2012
    Started redo application at
    Thread 1: logseq 84298, block 3, scn 10745981851
    Thu Aug 09 08:49:50 2012
    Recovery of Online Redo Log: Thread 1 Group 4 Seq 84298 Reading mem 0
    Mem# 0 errs 0: D:\DATA\ORACLE\ORADATA\XE\REDO04A.LOG
    Mem# 1 errs 0: D:\DATA\ORACLE\ORADATA\XE\REDO04B.LOG
    Thu Aug 09 08:49:50 2012
    Completed redo application
    Thu Aug 09 08:49:50 2012
    Completed crash recovery at
    Thread 1: logseq 84298, block 3, scn 10746001852
    0 data blocks read, 0 data blocks written, 0 redo blocks read
    Thu Aug 09 08:49:51 2012
    LGWR: STARTING ARCH PROCESSES
    ARC0 started with pid=18, OS id=2524
    Thu Aug 09 08:49:51 2012
    ARC0: Archival started
    ARC1 started with pid=20, OS id=2956
    Thu Aug 09 08:49:52 2012
    ARC1: Archival started
    LGWR: STARTING ARCH PROCESSES COMPLETE
    Thread 1 advanced to log sequence 84299
    Thread 1 opened at log sequence 84299
    Current log# 2 seq# 84299 mem# 0: D:\DATA\ORACLE\ORADATA\XE\REDO02A.LOG
    Current log# 2 seq# 84299 mem# 1: D:\DATA\ORACLE\ORADATA\XE\REDO02B.LOG
    Successful open of redo thread 1
    Thu Aug 09 08:49:52 2012
    ARC1: STARTING ARCH PROCESSES
    Thu Aug 09 08:49:52 2012
    ARC0: Becoming the 'no FAL' ARCH
    ARC0: Becoming the 'no SRL' ARCH
    Thu Aug 09 08:49:52 2012
    SMON: enabling cache recovery
    Thu Aug 09 08:49:52 2012
    ARC2: Archival started
    Thu Aug 09 08:49:52 2012
    ARC1: STARTING ARCH PROCESSES COMPLETE
    ARC1: Becoming the heartbeat ARCH
    ARC2 started with pid=21, OS id=3916
    Thu Aug 09 08:49:54 2012
    Successfully onlined Undo Tablespace 1.
    Thu Aug 09 08:49:54 2012
    SMON: enabling tx recovery
    Thu Aug 09 08:49:54 2012
    Database Characterset is WE8MSWIN1252
    Thu Aug 09 08:49:56 2012
    Hex dump of (file 1, block 39) in trace file c:\oraclexe\app\oracle\admin\xe\bdump\xe_smon_876.trc
    Corrupt block relative dba: 0x00400027 (file 1, block 39)
    Bad check value found during buffer read
    Data in bad block:
    type: 6 format: 2 rdba: 0x00400027
    last change scn: 0x0002.7fee0b69 seq: 0x1 flg: 0x06
    spare1: 0x0 spare2: 0x0 spare3: 0x0
    consistency value in tail: 0x0b690601
    check value in block header: 0x8f6c
    computed block checksum: 0x1000
    Reread of rdba: 0x00400027 (file 1, block 39) found same corrupted data
    Thu Aug 09 08:49:56 2012
    Stopping background process MMNL
    Thu Aug 09 08:49:56 2012
    Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_smon_876.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01578: ORACLE data block corrupted (file # 1, block # 39)
    ORA-01110: data file 1: 'D:\DATA\ORACLE\ORADATA\XE\SYSTEM.DBF'

    Thu Aug 09 08:49:57 2012
    Stopping background process MMON
    Starting background process MMON
    Starting background process MMNL
    MMON started with pid=11, OS id=1012
    Thu Aug 09 08:49:58 2012
    ALTER SYSTEM enable restricted session;
    MMNL started with pid=12, OS id=3584
    Thu Aug 09 08:49:58 2012
    ALTER SYSTEM SET systemtrig_enabled=FALSE SCOPE=MEMORY;
    Thu Aug 09 08:49:58 2012
    ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;
    Thu Aug 09 08:49:58 2012
    Errors in file c:\oraclexe\app\oracle\admin\xe\udump\xe_ora_324.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01578: ORACLE data block corrupted (file # 1, block # 39)
    ORA-01110: data file 1: 'D:\DATA\ORACLE\ORADATA\XE\SYSTEM.DBF'

    Thu Aug 09 08:49:58 2012
    Error 604 happened during db open, shutting down database
    USER: terminating instance due to error 604
    Thu Aug 09 08:49:59 2012
    Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_pmon_3120.trc:
    ORA-00604: error occurred at recursive SQL level

    Thu Aug 09 08:49:59 2012
    Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_psp0_3444.trc:
    ORA-00604: error occurred at recursive SQL level

    Thu Aug 09 08:49:59 2012
    Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_mman_2592.trc:
    ORA-00604: error occurred at recursive SQL level

    Thu Aug 09 08:49:59 2012
    Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_dbw0_932.trc:
    ORA-00604: error occurred at recursive SQL level

    Thu Aug 09 08:49:59 2012
    Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_ckpt_1156.trc:
    ORA-00604: error occurred at recursive SQL level

    Thu Aug 09 08:50:00 2012
    Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_lgwr_1508.trc:
    ORA-00604: error occurred at recursive SQL level

    Thu Aug 09 08:50:00 2012
    Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_reco_2700.trc:
    ORA-00604: error occurred at recursive SQL level

    Thu Aug 09 08:50:00 2012
    Errors in file c:\oraclexe\app\oracle\admin\xe\bdump\xe_smon_876.trc:
    ORA-00604: error occurred at recursive SQL level
  • 3. Re: ORA-00704: bootstrap process failure and SYSTEM datafile corrupt
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Underscore parameters should only be set under the guidance of Oracle Support.

    Why is the command "alter database open upgrade" being issued ?

    If you do not have a backup, recovery is unlikely.

    If the data in this database is important, contact Oracle Consulting - they may be able to recover - this will not be cheap

    If you have access to My Oracle Support, this MOS Doc may help

    ORA-1578 Main Reference Index for Solutions [ID 830997.1]

    HTH
    Srini
  • 4. Re: ORA-00704: bootstrap process failure and SYSTEM datafile corrupt
    ancientDX Newbie
    Currently Being Moderated
    if the same case in OEL then how to do that?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points