Professional Web Applications Themes

Unable to open database after instance failure with ORA-00600 internal error and management operations on LMT before the failure - Oracle Server

Hello, ALL. Recently I had instance failure and since then I'm unable to open the database. I tried some actions to bring database online but nothing helped. I'm not worried about loss of data. I have only several questions related to the accident: 1. Can anything else be done to recover the database? 2. Had anyone unexpected errors then altering locally managed tablespaces (LMT) offline or execution ALTER TABLE MOVE from/to LMT<->DMT? 3. Does anyone recommend NOT using LMT in 8.1.7.4? Configuration of server is as follows: | DB Version: Oracle EE 8.1.7.4.1 | OS: Windows 2000 AS SP4 | ...

  1. #1

    Default Unable to open database after instance failure with ORA-00600 internal error and management operations on LMT before the failure

    Hello, ALL.

    Recently I had instance failure and since then I'm unable to open the
    database. I tried some actions to bring database online but nothing
    helped. I'm not worried about loss of data. I have only several
    questions related to the accident:
    1. Can anything else be done to recover the database?
    2. Had anyone unexpected errors then altering locally managed
    tablespaces (LMT) offline or execution ALTER TABLE MOVE
    from/to LMT<->DMT?
    3. Does anyone recommend NOT using LMT in 8.1.7.4?


    Configuration of server is as follows:
    | DB Version: Oracle EE 8.1.7.4.1
    | OS: Windows 2000 AS SP4
    | Database purpose: Developer DB
    | Database mode: NOARCHIVELOG

    Instance of the server unexpectedly terminated with
    ORA-00600: internal error.
    Opening of database ends up with the same error. See ACTION1 log at
    the end of this post. Generated orakmuSMON.TRC file contains
    information I'm unable to interpret.

    Two things I want to notice about usage of DB.
    First, there where rare ORA-00600 errors then I used to alter an LMT
    offline to create export dump excluding data of specified tablespace.
    These were memory leak errors. I'm using this trick with offlining a
    tablespace before running EXP as a solution to produce export with only
    system and dictionary data, excluding data of tables with on-line data
    and audit data of our applied system. Running ahead, I want to say,
    these errors didn't disappeared on new database, I created on a reserved
    host. This time all tablespaces except SYSTEM and RBS are LMT.

    Second, in the day of failure I was moving some tables from DMT
    (USERS) to LMT (named WORKTBS) via ALTER TABLE MOVE å
    ALTER INDEX REBUIDå During of execution of script there was an
    ORA-00600: internal error (memory leak). But re-execution of the
    statement succeeded.

    Now abount what I did to recover the DB.
    After failure I copied all db files to a host with the same configuration,
    so I have unchanged files to do further experiments.
    At this separated host tried:
    1. Opening the DB.
    Result: ORA-00600: internal error code,
    arguments: [5120], [0], [16], [369], [2], [], [], [].
    See ACTION1 log.
    2. Opening with RESETLOGS + offline drop of all datafiles
    except belonging to SYSTEM, RBS, and USERS01 (DMT)
    Result: ORA-00600 in SMON, DBW0. See ACTION2 log.
    3. Opening with RESETLOGS + offline drop of all datafiles.
    Only SYSTEM datafile is preserved. The following underscore
    parameters added to initSID.ora file:
    _allow_resetlogs_corruption= TRUE
    _offline_rollback_segments= rbs
    _corrupted_rollback_segments= rbs
    Result: ORA-00600. See ACTION3 log.


    Thank you in advance!

    Best regards,
    Sergey Adamenko.


    +=========================================
    | Log ACTION1
    | Descipton: Opening of DB
    +----------------------------------------------------------------------
    | ALTER DATABASE OPEN
    | Beginning crash recovery of 1 threads
    | Sun Nov 02 13:34:11 2003
    | Thread recovery: start rolling forward thread 1
    | Recovery of Online Redo Log: Thread 1 Group 3 Seq 1344 Reading
    | mem 0
    | Mem# 0 errs 0: D:\ORADATA\REDO01A.LOG
    | Sun Nov 02 13:34:12 2003
    | Thread recovery: finish rolling forward thread 1
    | Thread recovery: 4 data blocks read, 4 data blocks written, 56 redo
    | blocks read
    | Crash recovery completed successfully
    | Sun Nov 02 13:34:12 2003
    | Thread 1 advanced to log sequence 1345
    | Thread 1 opened at log sequence 1345
    | Current log# 1 seq# 1345 mem# 0: D:\ORADATA\REDO03A.LOG
    | Successful open of redo thread 1.
    | Sun Nov 02 13:34:12 2003
    | SMON: enabling cache recovery
    | SMON: enabling tx recovery
    | Sun Nov 02 13:34:14 2003
    | Errors in file C:\oracle\admin\orakmu\bdump\orakmuSMON.TRC:
    | ORA-00600: internal error code, arguments: [5120], [0], [16], [369],
    | [2], [], [], []
    |
    | Sun Nov 02 13:34:15 2003
    | Completed: ALTER DATABASE OPEN
    | Sun Nov 02 13:34:16 2003
    | Errors in file C:\oracle\admin\orakmu\bdump\orakmuSMON.TRC:
    | ORA-00600: internal error code, arguments: [5120], [0], [16], [369],
    | [2], [], [], []

    | Sun Nov 02 13:34:16 2003
    | SMON: terminating instance due to error 600
    | Instance terminated by SMON, pid = 728


    +=========================================
    | Log ACTION2
    | Descipton: Opening of DB with RESETLOGS
    +----------------------------------------------------------------------
    |Sun Nov 02 13:45:35 2003
    |CREATE CONTROLFILE REUSE DATABASE ORAKMU
    | RESETLOGS NOARCHIVELOG
    | MAXLOGFILES 8
    | MAXLOGMEMBERS 2
    | MAXDATAFILES 32
    | MAXINSTANCES 1
    | MAXLOGHISTORY 453
    |LOGFILE
    | GROUP 1 'D:\ORADATA\REDO03A.LOG' SIZE 24M,
    | GROUP 2 'D:\ORADATA\REDO02A.LOG' SIZE 24M,
    | GROUP 3 'D:\ORADATA\REDO01A.LOG' SIZE 24M
    |DATAFILE
    | 'D:\ORADATA\SYSTEM01.DBF',
    | 'D:\ORADATA\RBS01.DBF',
    | 'C:\ORACLE\ORADATA\ORAKMU\USERS01.DBF',
    | 'D:\ORADATA\STARTEAM.DBF',
    | 'D:\ORADATA\TOOLS01.DBF',
    | 'D:\ORADATA\INDX01.DBF',
    | 'D:\ORADATA\REQPRO_DATA.DBF',
    | 'D:\ORADATA\LOGDATA.DBF',
    | 'D:\ORADATA\WORKTBS.DBF'
    |CHARACTER SET CL8MSWIN1251
    |
    |ORA-1503 signalled during: CREATE CONTROLFILE REUSE
    | DATABASE ORAKMU RESETLOGS...
    |Sun Nov 02 13:45:35 2003
    |ALTER DATABASE DATAFILE 'D:\ORADATA\TOOLS01.DBF'
    | OFFLINE DROP
    |
    |Completed: ALTER DATABASE DATAFILE
    'D:\ORADATA\TOOLS01.DBF' O
    |Sun Nov 02 13:45:35 2003
    |ALTER DATABASE DATAFILE 'D:\ORADATA\INDX01.DBF'
    | OFFLINE DROP
    |
    |Completed: ALTER DATABASE DATAFILE
    | 'D:\ORADATA\INDX01.DBF' OF
    |Sun Nov 02 13:45:35 2003
    |ALTER DATABASE DATAFILE
    | 'D:\ORADATA\REQPRO_DATA.DBF' OFFLINE DROP
    |
    |Completed: ALTER DATABASE DATAFILE
    |'D:\ORADATA\REQPRO_DATA.DB
    |Sun Nov 02 13:45:35 2003
    |ALTER DATABASE DATAFILE 'D:\ORADATA\LOGDATA.DBF'
    | OFFLINE DROP
    |
    |Completed: ALTER DATABASE DATAFILE
    |'D:\ORADATA\LOGDATA.DBF' O
    |Sun Nov 02 13:45:35 2003
    |ALTER DATABASE DATAFILE 'D:\ORADATA\WORKTBS.DBF'
    |OFFLINE DROP
    |
    |Completed: ALTER DATABASE DATAFILE
    | 'D:\ORADATA\WORKTBS.DBF' O
    |Sun Nov 02 13:45:35 2003
    |ALTER DATABASE RECOVER DATABASE until cancel
    |Media Recovery Start
    |Media Recovery Log
    |ORA-279 signalled during: ALTER DATABASE RECOVER
    | DATABASE until cancel ...
    |Sun Nov 02 13:45:35 2003
    |ALTER DATABASE RECOVER CONTINUE DEFAULT
    |Media Recovery Log C:\ORACLE\ORA81\RDBMS\ARC01345.001
    |ORA-308 signalled during: ALTER DATABASE RECOVER
    |CONTINUE DEFAULT ...
    |Sun Nov 02 13:45:35 2003
    |ALTER DATABASE RECOVER CANCEL
    |ORA-1547 signalled during: ALTER DATABASE RECOVER
    | CANCEL ...
    |Sun Nov 02 13:45:35 2003
    |ALTER DATABASE OPEN RESETLOGS
    |
    |RESETLOGS is being done without consistency checks. This may
    |result
    |in a corrupted database. The database should be recreated.
    |RESETLOGS after incomplete recovery UNTIL CHANGE 29797265
    |Sun Nov 02 13:45:38 2003
    |Thread 1 opened at log sequence 1
    | Current log# 1 seq# 1 mem# 0: D:\ORADATA\REDO03A.LOG
    |Successful open of redo thread 1.
    |Sun Nov 02 13:45:38 2003
    |SMON: enabling cache recovery
    |Sun Nov 02 13:45:38 2003
    |Dictionary check beginning
    |File #5 is offline, but is part of an online tablespace.
    |data file 5: 'D:\ORADATA\TOOLS01.DBF'
    |File #6 is offline, but is part of an online tablespace.
    |data file 6: 'D:\ORADATA\INDX01.DBF'
    |File #7 is offline, but is part of an online tablespace.
    |data file 7: 'D:\ORADATA\REQPRO_DATA.DBF'
    |File #8 is offline, but is part of an online tablespace.
    |data file 8: 'D:\ORADATA\LOGDATA.DBF'
    |File #9 is offline, but is part of an online tablespace.
    |data file 9: 'D:\ORADATA\WORKTBS.DBF'
    |Dictionary check complete
    |Sun Nov 02 13:45:38 2003
    |SMON: enabling tx recovery
    |Sun Nov 02 13:45:39 2003
    |Errors in file C:\oracle\admin\orakmu\bdump\orakmuSMON.TRC:
    |ORA-00600: internal error code, arguments: [5120], [0], [16], [369],
    |[2], [], [], []
    |
    |Sun Nov 02 13:45:41 2003
    |Completed: ALTER DATABASE OPEN RESETLOGS
    |Sun Nov 02 13:45:42 2003
    |Errors in file C:\oracle\admin\orakmu\bdump\orakmuSMON.TRC:
    |ORA-00600: internal error code, arguments: [5120], [0], [16], [369],
    |[2], [], [], []
    |
    |Sun Nov 02 13:45:42 2003
    |SMON: terminating instance due to error 600
    |Sun Nov 02 13:45:42 2003
    |Errors in file C:\oracle\admin\orakmu\bdump\orakmuDBW0.TRC:
    |ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
    |
    |Instance terminated by SMON, pid = 688
    |



    +=========================================
    | Log ACTION3
    | Descipton: Opening of SYSTEM tablespace only + RESETLOGS
    +----------------------------------------------------------------------

    | ALTER DATABASE OPEN RESETLOGS
    |
    | RESETLOGS is being done without consistency checks. This may
    |result
    | in a corrupted database. The database should be recreated.
    | RESETLOGS after incomplete recovery UNTIL CHANGE 29797269
    | Sun Nov 02 14:09:00 2003
    | Thread 1 opened at log sequence 1
    | Current log# 3 seq# 1 mem# 0: D:\ORADATA\REDO01A.LOG
    | Successful open of redo thread 1.
    | Sun Nov 02 14:09:00 2003
    | SMON: enabling cache recovery
    | Sun Nov 02 14:09:00 2003
    | Errors in file C:\oracle\admin\orakmu\udump\ORA00528.TRC:
    | ORA-00600: internal error code, arguments: [25012], [1], [2], [], [], [],
    |[], []
    |
    | Sun Nov 02 14:09:01 2003
    | Errors in file C:\oracle\admin\orakmu\udump\ORA00528.TRC:
    | ORA-00600: internal error code, arguments: [25012], [1], [2], [], [], [],
    |[], []
    |
    | Sun Nov 02 14:09:01 2003
    | Error 600 happened during db open, shutting down database
    | USER: terminating instance due to error 600
    | Instance terminated by USER, pid = 528
    | ORA-1092 signalled during: ALTER DATABASE OPEN
    |RESETLOGS



    Sergey Guest

  2. #2

    Default Re: Unable to open database after instance failure with ORA-00600 internal error and management operations on LMT before the failure


    "Sergey Adamenko" <asv_no__s_p_a_mi.com.ua> wrote in message
    news:bo412d$1h4v$dg.net.ua... 
    [], 
    [], 

    ORA-00600 [5120]

    This ora-600 has to do with
    tablespace quota and possible corruption when it comes
    to tablespace information.

    Suggest you open a TAR

    ORA-00600: internal error code, arguments: [25012],

    think that means the DB cant find the online redo logs


    get help from Support


    DJ Guest

  3. #3

    Default Re: Unable to open database after instance failure with ORA-00600internal error and management operations on LMT before the failure

    Sergey Adamenko wrote:
     
    You can stop right there. An ORA-00600 is an unhandled error in the
    Oracle software.
    Open a iTAR at http://metalink.oracle.com.

    If you don't have support ... consider prayer ... then apply any newer
    patches or consider
    a complete reinstallation (which may not solve the problem).

    --
    Daniel Morgan
    http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
    http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
    damorganx.washington.edu
    (replace 'x' with a 'u' to reply)

    Daniel Guest

  4. #4

    Default Re: Unable to open database after instance failure with ORA-00600 internal error and management operations on LMT before the failure



    Thanks for the answer.
    Oracle users are really assigned tablespace quotas (unlimited for all
    except RBS, TOOLS, SYSTEM).
    I'll try to remove all ts. quotas in the new database and grant then
    UNLIMITED TABLESPACE.

    Buy the way, here is a log of ALTER TABLESPACE OFFLINE.
    This log is retrieved from the server, I had just installed.

    | Mon Nov 03 10:26:30 2003
    | Thread 1 advanced to log sequence 57
    | Current log# 3 seq# 57 mem# 0: D:\ORADATA\REDO03.LOG
    | Mon Nov 03 10:43:11 2003
    | ALTER TABLESPACE LOGDATA OFFLINE
    |
    | Mon Nov 03 10:43:11 2003
    | Completed: ALTER TABLESPACE LOGDATA OFFLINE
    | Mon Nov 03 10:43:12 2003
    | ALTER TABLESPACE WORKtbs OFFLINE
    |
    | Mon Nov 03 10:43:12 2003
    | Completed: ALTER TABLESPACE WORKtbs OFFLINE
    | Mon Nov 03 10:43:52 2003
    | Errors in file C:\oracle\admin\orakmu\udump\ORA01716.TRC:
    | ORA-00600: internal error code, arguments: [729], [495564], [space
    leak], [], | [], [], [], []
    |
    | Mon Nov 03 10:43:55 2003
    | Errors in file C:\oracle\admin\orakmu\udump\ORA01716.TRC:
    | ORA-00600: internal error code, arguments: [723], [25728], [25728],
    | [memory | leak], [], [], [], []
    |
    | Mon Nov 03 10:43:56 2003
    | ALTER TABLESPACE LOGDATA ONLINE
    |
    | Mon Nov 03 10:43:56 2003
    | Completed: ALTER TABLESPACE LOGDATA ONLINE
    Sergey Guest

Similar Threads

  1. CFHTTP - Connection Failure Error
    By jrwill74 in forum Macromedia ColdFusion
    Replies: 3
    Last Post: September 7th, 04:13 PM
  2. postgres server failure during some database opearion
    By Surabhi in forum PostgreSQL / PGSQL
    Replies: 2
    Last Post: February 10th, 01:21 PM
  3. Error message "File open initializaton failure"
    By Bob_Daber@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 0
    Last Post: April 15th, 11:53 AM
  4. Replies: 0
    Last Post: October 2nd, 07:31 PM
  5. Boot Failure, Repair Failure!
    By Drouin in forum Windows XP/2000/ME
    Replies: 3
    Last Post: August 2nd, 10:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139