DB is not coming up

[Former Member]

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.

[Former Member]

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:

[Former Member]

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

[Former Member]

System got rebooted due to power issue and now when I am starting the DB it is throwing the error.

I have tried to recover the data but it says Database is mounted successfully and no need to restore.

c

BR0280I BRRECOVER time stamp: 2011-12-12 22.43.01

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2011-12-12 22.43.01

BR0307I Shutting down database instance REX ...

BR0280I BRRECOVER time stamp: 2011-12-12 22.43.02

BR0308I Shutdown of database instance REX successful

BR0280I BRRECOVER time stamp: 2011-12-12 22.43.02

BR0330I Starting and mounting database instance REX ...

BR0280I BRRECOVER time stamp: 2011-12-12 22.43.08

BR0331I Start and mount of database instance REX successful

BR0755I Checking the status of database files for instance REX...

BR0280I BRRECOVER time stamp: 2011-12-12 22.43.16

BR0762I No restore and recovery required - database can be opened

BR0280I BRRECOVER time stamp: 2011-12-12 22.43.16

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

[Former Member]

Thats cool. Just provide

startup mount;

alter database open;

or shutodwn database and startup

Thanks,

Sravanthi

[Former Member]

I am getting given below error

ALTER DATABASE OPEN

Mon Dec 12 22:46:01 2011

Beginning crash recovery of 1 threads

parallel recovery started with 2 processes

Mon Dec 12 22:46:03 2011

Started redo scan

Mon Dec 12 22:46:03 2011

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

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

Mon Dec 12 22:46:05 2011

Aborting crash recovery due to error 600

Mon Dec 12 22:46:05 2011

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

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

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

[Former Member]

Did you try

startup mount;

recover database;

or

startup mount

recover database until cancel;

cancel {after providing archive log, if you have}

Can you try above commands and paste the log, if you still have errors.

[Former Member]

Thanks for your help.

We have recovered the database with redo logs.

Sukrut

[Former Member]

If your issue has been fixed, then You can close the thread as "Answered" .