Skip to Content
author's profile photo Former Member
Former Member

DB is not coming up

All,

We have some issue with my DB(Oracle 10g,Windows 2003,Intel)

PSP0 started with pid=3, OS id=3616

MMAN started with pid=4, OS id=3620

PMON started with pid=2, OS id=3612

DBW0 started with pid=5, OS id=3624

LGWR started with pid=6, OS id=3628

CKPT started with pid=7, OS id=3632

SMON started with pid=8, OS id=3636

RECO started with pid=9, OS id=3640

CJQ0 started with pid=10, OS id=3644

MMON started with pid=11, OS id=3648

MMNL started with pid=12, OS id=3652

Mon Dec 12 18:54:51 2011

ALTER DATABASE MOUNT

Mon Dec 12 18:54:56 2011

Setting recovery target incarnation to 1

Mon Dec 12 18:54:57 2011

Successful mount of redo thread 1, with mount id 981565563

Mon Dec 12 18:54:57 2011

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Mon Dec 12 18:54:58 2011

ALTER DATABASE OPEN

Mon Dec 12 18:55:15 2011

Beginning crash recovery of 1 threads

parallel recovery started with 2 processes

Mon Dec 12 18:55:20 2011

Started redo scan

Mon Dec 12 18:55:20 2011

Errors in file e:\oracle\rex\saptrace\usertrace\rex_ora_3692.trc:

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

Mon Dec 12 18:55:23 2011

Aborting crash recovery due to error 600

Mon Dec 12 18:55:23 2011

Errors in file e:\oracle\rex\saptrace\usertrace\rex_ora_3692.trc:

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

ORA-600 signalled during: ALTER DATABASE OPEN...

Any idea how to recover it.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 10:40 PM

    Hi,

    Can you tell us the situation, Did you tried to restore your database ?

    Can you try "recover database" from the command prompt

    SQL> startup mount

    ORACLE instance started.

    Total System Global Area 1073741824 bytes

    Fixed Size 1264916 bytes

    Variable Size 264241900 bytes

    Database Buffers 801112064 bytes

    Redo Buffers 7122944 bytes

    Database mounted.

    SQL> recover database

    Media recovery complete.

    SQL> alter database open;

    Database altered

    OR

    recover database until cancel (if you have archive log)

    Also check this link

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 11:00 PM

    Errors while opening the database

    SQL> Connected to an idle instance.

    SQL>

    SQL> ORACLE instance started.

    Total System Global Area 515899392 bytes

    Fixed Size 2005480 bytes

    Variable Size 268437016 bytes

    Database Buffers 243269632 bytes

    Redo Buffers 2187264 bytes

    Database mounted.

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

    [], [], []

    SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

    - 64bit Production

    With the Partitioning, OLAP and Data Mining options

    BR0280I BRRECOVER time stamp: 2011-12-12 22.46.05

    BR0279E Return code from 'C:\oracle\REX\102\BIN\sqlplus /nolog < E:\oracle\REX\s

    apbackup\.vehksqhq.spi': 0

    BR0302E SQLPLUS call for database instance REX failed

    BR0306E Start and open of database instance REX failed

    BR0669I Cannot continue due to previous warnings or errors - you can go back to

    repeat the last action

    BR0280I BRRECOVER time stamp: 2011-12-12 22.46.05

    BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.