ERROR:
During startup we got the following error. The version of the database is; 10.2.0.5.
SQL> startup
ORACLE instance started.
Total System Global Area 3372220416 bytes
Fixed Size 2071640 bytes
Variable Size 1291846568 bytes
Database Buffers 2046820352 bytes
Redo Buffers 31481856 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcbtema_10], [1], [], [], [], [],[], []
SQL>
Also we noticed the following entires in alertlog;
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sat Jul 12 01:57:57 EETDST 2014
ALTER DATABASE OPEN
Sat Jul 12 01:58:00 EETDST 2014
SUCCESS: diskgroup ARCHIVE_DATA was mounted
Sat Jul 12 01:58:10 EETDST 2014
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Sat Jul 12 01:58:11 EETDST 2014
Started redo scan
Sat Jul 12 01:58:29 EETDST 2014
Completed redo scan
1775077 redo blocks read, 121256 data blocks need recovery
Sat Jul 12 01:58:29 EETDST 2014
Warning: recovery process cannot use async I/O
Sat Jul 12 01:58:29 EETDST 2014
Warning: recovery process cannot use async I/O
Sat Jul 12 01:58:29 EETDST 2014
Warning: recovery process cannot use async I/O
Sat Jul 12 01:58:29 EETDST 2014
Warning: recovery process cannot use async I/O
Sat Jul 12 01:58:29 EETDST 2014
Warning: recovery process cannot use async I/O
Sat Jul 12 01:58:29 EETDST 2014
Warning: recovery process cannot use async I/O
Sat Jul 12 01:58:29 EETDST 2014
Warning: recovery process cannot use async I/O
Sat Jul 12 01:59:42 EETDST 2014
Started redo application at
Thread 1: logseq 376891, block 102917
Sat Jul 12 01:59:42 EETDST 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 376891 Reading mem 0
Mem# 0: +DATA3/pxxpro0/onlinelog/group_2.258.717497723
Sat Jul 12 01:59:47 EETDST 2014
Errors in file /oracle/admin/pxxpro0/bdump/pxxpro0_p002_21594.trc:
ORA-00600: internal error code, arguments: [kcbtema_10], [1], [], [], [], [], [], []
Sat Jul 12 01:59:49 EETDST 2014
Errors in file /oracle/admin/pxxpro0/bdump/pxxpro0_p002_21594.trc:
ORA-00600: internal error code, arguments: [kcbtema_10], [1], [], [], [], [], [], []
Sat Jul 12 01:59:49 EETDST 2014
Aborting crash recovery due to slave death, attempting serial crash recovery
Sat Jul 12 01:59:49 EETDST 2014
Beginning crash recovery of 1 threads
Sat Jul 12 01:59:49 EETDST 2014
Started redo scan
Sat Jul 12 02:00:00 EETDST 2014
Completed redo scan
1775077 redo blocks read, 121256 data blocks need recovery
Sat Jul 12 02:00:04 EETDST 2014
Started redo application at
Thread 1: logseq 376891, block 102917
Sat Jul 12 02:00:04 EETDST 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 376891 Reading mem 0
Mem# 0: +DATA3/pxxpro0/onlinelog/group_2.258.717497723
Sat Jul 12 02:00:09 EETDST 2014
Errors in file /oracle/admin/pxxpro0/udump/pxxpro0_ora_21516.trc:
ORA-00600: internal error code, arguments: [kcbtema_10], [1], [], [], [], [], [], []
Sat Jul 12 02:00:10 EETDST 2014
Aborting crash recovery due to error 600
Sat Jul 12 02:00:10 EETDST 2014
Errors in file /oracle/admin/pxxpro0/udump/pxxpro0_ora_21516.trc:
ORA-00600: internal error code, arguments: [kcbtema_10], [1], [], [], [], [], [], []
Sat Jul 12 02:00:11 EETDST 2014
SUCCESS: diskgroup ARCHIVE_DATA was dismounted
Sat Jul 12 02:00:11 EETDST 2014
ORA-600 signalled during: ALTER DATABASE OPEN...
SOLUTION:
For solution we used the note with id 472282.1 in My Oracle support. This error is due to a bug on 10.2.0.2 and later and fixed with 11g. And could happen on any platform. As a workaround we applied the following steps and fixed the problem;
SQL> shu immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3372220416 bytes
Fixed Size 2071640 bytes
Variable Size 1291846568 bytes
Database Buffers 2046820352 bytes
Redo Buffers 31481856 bytes
Database mounted.
SQL> recover database;
Media recovery complete.
SQL> alter database open;
Database altered.
Hiç yorum yok:
Yorum Gönder