1 2 Previous Next 21 Replies Latest reply on May 4, 2011 4:28 PM by oraclebooks Go to original post
      • 15. Re: 11g db cannot start
        Chinar
        Now post 30 line of alert.log there again
        • 16. Re: 11g db cannot start
          oraclebooks
          how do i open that xml alert log file in windows. it throws error in internet explorer


          thanks
          • 17. Re: 11g db cannot start
            oraclebooks
            alert log file

            Mem# 0: D:\SIEBELOWB\OWBDB\REDO01.LOG
            Block recovery completed at rba 238.88.16, scn 0.37415032
            ORA-607 encountered when generating server alert SMG-4120
            Errors in file c:\oradb11g_home\diag\rdbms\owbdb\owbdb\trace\owbdb_mmon_5800.trc (incident=220472):
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            Incident details in: c:\oradb11g_home\diag\rdbms\owbdb\owbdb\incident\incdir_220472\owbdb_mmon_5800_i220472.trc
            DEBUG: Replaying xcb 0x5ab51ba0, pmd 0x5b7d215c for failed op 8
            Doing block recovery for file 3 block 419
            Block recovery from logseq 238, block 72 to scn 37415030
            Recovery of Online Redo Log: Thread 1 Group 1 Seq 238 Reading mem 0
            Mem# 0: D:\SIEBELOWB\OWBDB\REDO01.LOG
            Block recovery completed at rba 238.86.16, scn 0.37415031
            Trace dumping is performing id=[cdmp_20110504180504]
            Errors in file c:\oradb11g_home\diag\rdbms\owbdb\owbdb\trace\owbdb_mmon_5800.trc (incident=220473):
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            Incident details in: c:\oradb11g_home\diag\rdbms\owbdb\owbdb\incident\incdir_220473\owbdb_mmon_5800_i220473.trc
            DEBUG: Replaying xcb 0x5ab51ba0, pmd 0x5b7d215c for failed op 8
            Doing block recovery for file 3 block 419
            Block recovery from logseq 238, block 72 to scn 37415030
            Recovery of Online Redo Log: Thread 1 Group 1 Seq 238 Reading mem 0
            Mem# 0: D:\SIEBELOWB\OWBDB\REDO01.LOG
            Block recovery completed at rba 238.86.16, scn 0.37415031
            Errors in file c:\oradb11g_home\diag\rdbms\owbdb\owbdb\trace\owbdb_mmon_5800.trc (incident=220474):
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            DEBUG: Replaying xcb 0x5ab51ba0, pmd 0x5b7d215c for failed op 8
            Doing block recovery for file 3 block 419
            Block recovery from logseq 238, block 72 to scn 37415030
            Recovery of Online Redo Log: Thread 1 Group 1 Seq 238 Reading mem 0
            Mem# 0: D:\SIEBELOWB\OWBDB\REDO01.LOG
            Block recovery completed at rba 238.86.16, scn 0.37415031
            Errors in file c:\oradb11g_home\diag\rdbms\owbdb\owbdb\trace\owbdb_mmon_5800.trc (incident=220475):
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            DEBUG: Replaying xcb 0x5ab51ba0, pmd 0x5b7d215c for failed op 8
            Doing block recovery for file 3 block 419
            Block recovery from logseq 238, block 72 to scn 37415030
            Recovery of Online Redo Log: Thread 1 Group 1 Seq 238 Reading mem 0
            Mem# 0: D:\SIEBELOWB\OWBDB\REDO01.LOG
            Block recovery completed at rba 238.86.16, scn 0.37415031
            Errors in file c:\oradb11g_home\diag\rdbms\owbdb\owbdb\trace\owbdb_mmon_5800.trc (incident=220476):
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            Errors in file c:\oradb11g_home\diag\rdbms\owbdb\owbdb\trace\owbdb_mmon_5800.trc (incident=220477):
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-06512: at "SYS.DBMS_HA_ALERTS_PRVT", line 339
            ORA-06512: at line 1
            Incident details in: c:\oradb11g_home\diag\rdbms\owbdb\owbdb\incident\incdir_220477\owbdb_mmon_5800_i220477.trc
            Trace dumping is performing id=[cdmp_20110504180505]
            DEBUG: Replaying xcb 0x5ab51ba0, pmd 0x5b7d215c for failed op 8
            Doing block recovery for file 3 block 419
            Block recovery from logseq 238, block 72 to scn 37415030
            Recovery of Online Redo Log: Thread 1 Group 1 Seq 238 Reading mem 0
            Mem# 0: D:\SIEBELOWB\OWBDB\REDO01.LOG
            Block recovery completed at rba 238.86.16, scn 0.37415031
            Errors in file c:\oradb11g_home\diag\rdbms\owbdb\owbdb\trace\owbdb_mmon_5800.trc (incident=220478):
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            ORA-06512: at "SYS.DBMS_HA_ALERTS_PRVT", line 339
            ORA-06512: at line 1
            Wed May 04 18:05:06 2011
            DEBUG: Replaying xcb 0x5ab51ba0, pmd 0x5b7d215c for failed op 8
            Doing block recovery for file 3 block 419
            Block recovery from logseq 238, block 72 to scn 37415030
            Recovery of Online Redo Log: Thread 1 Group 1 Seq 238 Reading mem 0
            Mem# 0: D:\SIEBELOWB\OWBDB\REDO01.LOG
            Block recovery completed at rba 238.86.16, scn 0.37415031
            Errors in file c:\oradb11g_home\diag\rdbms\owbdb\owbdb\trace\owbdb_pmon_2692.trc (incident=220359):
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            Errors in file c:\oradb11g_home\diag\rdbms\owbdb\owbdb\trace\owbdb_pmon_2692.trc:
            ORA-00600: internal error code, arguments: [4194], [55], [35], [], [], [], [], []
            PMON (ospid: 2692): terminating the instance due to error 472
            Wed May 04 18:05:07 2011
            ORA-1092 : opidrv aborting process W000 ospid (5912_4544)
            Wed May 04 18:05:08 2011
            ORA-472 : opidrv aborting process S000 ospid (5912_3288)
            Instance terminated by PMON, pid = 2692
            • 18. Re: 11g db cannot start
              Chinar
              This is internal error and need calling Oracle support.But you can refer below doc and can try solving problem firstly.So you need drop and create undo tablespace.But before doing this take backup of database and move to other place.
              *Basic Steps to be Followed While Solving ORA-00600 [4194]/[4193] Errors Without Using Unsupported parameter [ID 281429.1]*
              • 19. Re: 11g db cannot start
                Rajesh Lathwal
                ALTER DATABASE RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE
                Media Recovery Start
                Fast Parallel Media Recovery enabled
                WARNING! Recovering data file 1 from a fuzzy file. If not the current file
                it might be an online backup taken without entering the begin backup command.
                WARNING! Recovering data file 2 from a fuzzy file. If not the current file
                it might be an online backup taken without entering the begin backup command.
                WARNING! Recovering data file 3 from a fuzzy file. If not the current file
                it might be an online backup taken without entering the begin backup command.
                You have restored database from backup and are trying to recover , but as alertlog suggest , the backup you are trying to restore was taken without putting database in bigin backup mode. So this is not a valid backup.

                So take backup again after putting in begin backup mode Or Use RMAN.

                Then restore it again.
                parallel recovery started with 16 processes
                ORA-279 signalled during: ALTER DATABASE RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE ...
                ALTER DATABASE RECOVER CANCEL
                ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ...
                ALTER DATABASE RECOVER CANCEL
                ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...
                Sun Apr 03 23:05:06 2011
                alter database open
                ORA-1589 signalled during: alter database open
                ...
                Shutting down instance: further logons disabled
                Regards
                Rajesh
                • 20. Re: 11g db cannot start
                  oraclebooks
                  now my database is in mount stage.
                  which backup shall i take

                  regards
                  • 21. Re: 11g db cannot start
                    oraclebooks
                    As you have seen my database comes upto mount stage.
                    can I open my database by recreating the controlfile.
                    although I dont have my backup controlfile nor controlfile to trace;

                    regards,
                    1 2 Previous Next