DBAsupport.com Forums - Powered by vBulletin

View Poll Results: crash recovery instance.. anything wrong with the alert file..

Voters
0. You may not vote on this poll
  • bad

    0 0%
  • ok

    0 0%
  • good

    0 0%
Results 1 to 8 of 8

Thread: Crash Recovery -- any thing wrong..

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    Crash Recovery -- any thing wrong..

    Hi

    My instance gives the alert file as below.
    Tail end of my ALert log file

    Mon Apr 21 21:32:46 2003
    alter database "orcl" mount exclusive
    Mon Apr 21 21:32:51 2003
    Successful mount of redo thread 1, with mount id 1019696642.
    Mon Apr 21 21:32:51 2003
    Database mounted in Exclusive Mode.
    Completed: alter database "orcl" mount exclusive
    Mon Apr 21 21:32:51 2003
    alter database "orcl" open
    Beginning crash recovery of 1 threads
    Mon Apr 21 21:32:57 2003
    Thread recovery: start rolling forward thread 1
    Recovery of Online Redo Log: Thread 1 Group 1 Seq 8589 Reading mem 0
    Mem# 0 errs 0: D:\ORANT\DATABASE\LOGORCL1.ORA
    Mon Apr 21 21:32:58 2003
    Thread recovery: finish rolling forward thread 1
    Thread recovery: 16 data blocks read, 16 data blocks written, 15 redo blocks read
    Crash recovery completed successfully
    Picked broadcast on commit scheme to generate SCNs
    Mon Apr 21 21:33:00 2003
    Thread 1 advanced to log sequence 8590
    Thread 1 opened at log sequence 8590
    Current log# 2 seq# 8590 mem# 0: D:\ORANT\DATABASE\LOGORCL2.ORA
    Successful open of redo thread 1.
    Mon Apr 21 21:33:00 2003
    SMON: enabling cache recovery
    SMON: enabling tx recovery
    Mon Apr 21 21:33:01 2003
    Completed: alter database "orcl" open
    Mon Apr 21 21:48:41 2003
    Errors in file D:\orant\rdbms80\trace\ORA00299.TRC:

    Please suggest if anything is wrong,,

    Thanks
    Vegiri

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    poll for this what the heck @!#!

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    sorry I am a new member to this forum
    so tried out the polling option..

  4. #4
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    It would appear that either somebody did a shutdown abort or a crash occurred. The database was restarted and as is expected Oracle performed media recovery and this completed successfully. The database was opened. Approx. ten minutes later a trace file was generated. Therefore, it is very unlikely that this error relates to the media recovery. You need to take a look at the trace file and see what the error was that caused it's generation.

  5. #5
    Join Date
    Apr 2003
    Posts
    353
    Really your advice is very helpful.
    Please find the attached Trace file generated at this point.
    Attached Files Attached Files

  6. #6
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Just downloaded this and the only text in the file seems to be:

    ÿþD

    I think you've uploaded the wrong file.

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by hacketta1
    Just downloaded this and the only text in the file seems to be:

    ÿþD

    I think you've uploaded the wrong file.
    I think u havent got it downlaoded properly

    herezz the text...


    Dump file D:\orant\rdbms80\trace\ORA00070.TRC
    Mon Apr 21 17:35:18 2003
    ORACLE V8.0.6.0.0 - Production vsnsta=0
    vsnsql=c vsnxtr=3
    Windows NT V4.0, OS V5.101, CPU type 586
    Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
    PL/SQL Release 8.0.6.0.0 - Production
    Windows NT V4.0, OS V5.101, CPU type 586
    Instance name: orcl

    Redo thread mounted by this instance: 1

    Oracle process number: 12

    pid: 46


    *** 2003-04-21 17:35:18.671
    *** SESSION ID:(11.45) 2003-04-21 17:35:18.656
    FATAL ERROR IN TWO-TASK SERVER: error = 12571
    *** 2003-04-21 17:35:18.671
    ksedmp: internal or fatal error
    Current SQL statement for this session:
    UPDATE ITEMMAST SET ITEM_CODE=:1,ITEM_CONC_CODE=:2,ITEM_SRLNO=:3,ITEM_OLDCODE=:4,ITEM_STYLE_NO=:5,ITEM_DESC=:6,ITEM_BAR_ DESC=:7,ITEM_BIN_RACK=:8,SP_BUDG_CODE=:9,ITEM_TYPE=:10,ITEM_FIRST_SALE=:11,ITEM_TAX_CODE=:12,ITEM_CO LR_CODE=:13,ITEM_SIZE_CODE=:14,ITEM_BUYR_CODE=:15,ITEM_DEPT_CODE=:16,ITEM_GRUP_CODE=:17,ITEM_SUBG_CO DE=:18,ITEM_HS_CODE=:19,ITEM_SUPL_CODE=:20,ITEM_BRND_CODE=:21,ITEM_EXCS_DTY=:22,ITEM_MAX_DISC=:23,IT EM_MADEOF=:24,ITEM_ORIGIN=:25,ITEM_SEAS_CODE=:26,ITEM_ST_CODE=:27,ITEM_UOMM_CODE=:28,ITEM_REPEAT=:29 ,ITEM_UNIT_QTY=:30,ITEM_PROM_FLAG=:31,ITEM_REORD_QTY=:32,ITEM_KIT_CRTN=:33,ITEM_SUBTYPE=:34,ITEM_WEI GHT=:35,ITEM_VOLUME=:36,ITEM_EXP_DATE=:37,ITEM_SET=:38,ITEM_BUYG_FLAG=:39,ITEM_BASE_ICODE=:40,ITEM_B ASE_UOMM=:41,ITEM_ANALYS1=:42,ITEM_ANALYS2=:43,ITEM_ANALYS3=:44,ITEM_STATUS=:45,ITEM_CRE_REF=:46,ITE M_CONV_FACT=:47,ITEM_FRCVD_DATE=:48,ITEM_LRCVD_DATE=:49,ITEM_QTY=:50,ITEM_WAC=:51 WHERE ROWID=:52
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  8. #8
    Join Date
    Apr 2003
    Posts
    353
    Thatz it. Can u analyse anything with that..

Posting Permissions

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


Click Here to Expand Forum to Full Width