4 Replies Latest reply: Oct 17, 2012 1:22 AM by ancientDX RSS

    ORA-00704: bootstrap process failure and SYSTEM datafile corrupt

    jeff81
      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
          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
            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
              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
                if the same case in OEL then how to do that?