on 12-12-2011 10:09 PM
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.
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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...
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.