Oracle Database Discussions

I have restored the database backup through tape backup and when I try to start database, subjet error occurs.

Here is my alert log, please help me diagnosing the problem.

Thanks and Regards,

Luqman


Fri Jul 31 12:52:27 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 88080384
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 4194304
spfile = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 293601280
control_files = E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 184549376
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = e:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
audit_trail = TRUE
db_name = orcl
open_cursors = 300
pga_aggregate_target = 96468992
PMON started with pid=2, OS id=2860
PSP0 started with pid=3, OS id=2864
MMAN started with pid=4, OS id=2868
DBW0 started with pid=5, OS id=2872
LGWR started with pid=6, OS id=2876
CKPT started with pid=7, OS id=2880
SMON started with pid=8, OS id=2884
RECO started with pid=9, OS id=2888
CJQ0 started with pid=10, OS id=2892
MMON started with pid=11, OS id=2896
MMNL started with pid=12, OS id=2900
Fri Jul 31 12:52:27 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri Jul 31 12:52:27 2009
ALTER DATABASE MOUNT
Fri Jul 31 12:52:33 2009
Setting recovery target incarnation to 2
Fri Jul 31 12:52:33 2009
Successful mount of redo thread 1, with mount id 1221435532
Fri Jul 31 12:52:33 2009
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Jul 31 12:52:33 2009
ALTER DATABASE OPEN
Fri Jul 31 12:52:33 2009
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Fri Jul 31 12:52:33 2009
Started redo scan
Fri Jul 31 12:52:34 2009
Completed redo scan
74 redo blocks read, 14 data blocks need recovery
Fri Jul 31 12:52:34 2009
Started redo application at
Thread 1: logseq 5047, block 3
Fri Jul 31 12:52:34 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 5047 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Fri Jul 31 12:52:34 2009
Completed redo application
Fri Jul 31 12:52:34 2009
Completed crash recovery at
Thread 1: logseq 5047, block 77, scn 443059691
14 data blocks read, 14 data blocks written, 74 redo blocks read
Fri Jul 31 12:52:34 2009
Thread 1 advanced to log sequence 5048
Thread 1 opened at log sequence 5048
Current log# 1 seq# 5048 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Fri Jul 31 12:52:35 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jul 31 12:52:35 2009
SMON: enabling cache recovery
Fri Jul 31 12:52:35 2009
Successfully onlined Undo Tablespace 1.
Fri Jul 31 12:52:35 2009
SMON: enabling tx recovery
Fri Jul 31 12:52:35 2009
Database Characterset is WE8MSWIN1252
Fri Jul 31 12:52:37 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2924.trc:
ORA-00600: internal error code, arguments: [4193], [14999], [15003], [], [], [], [], []

Doing block recovery for file 2 block 4913
Block recovery from logseq 5048, block 63 to scn 443059843
Fri Jul 31 12:52:39 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5048 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Block recovery stopped at EOT rba 5048.69.16
Block recovery completed at rba 5048.69.16, scn 0.443059843
Doing block recovery for file 2 block 137
Fri Jul 31 12:52:39 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2884.trc:
ORA-00600: internal error code, arguments: [4193], [12014], [12018], [], [], [], [], []

Block recovery from logseq 5048, block 63 to scn 443059839
Fri Jul 31 12:52:39 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5048 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Block recovery completed at rba 5048.65.16, scn 0.443059840
Fri Jul 31 12:52:40 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2924.trc:
ORA-00600: internal error code, arguments: [4193], [13800], [13804], [], [], [], [], []

DEBUG: Replaying xcb 0x1fe1e548, pmd 0x1ff9f194 for failed op 8
Doing block recovery for file 2 block 2267
No block recovery was needed
Fri Jul 31 12:52:42 2009
Doing block recovery for file 2 block 1741
Block recovery from logseq 5048, block 68 to scn 443059847
Fri Jul 31 12:52:42 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5048 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Block recovery stopped at EOT rba 5048.69.16
Block recovery completed at rba 5048.69.16, scn 0.443059843
Doing block recovery for file 2 block 9
Block recovery from logseq 5048, block 68 to scn 443059842
Fri Jul 31 12:52:43 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5048 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Block recovery completed at rba 5048.69.16, scn 0.443059843
Fri Jul 31 12:52:43 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2884.trc:
ORA-01595: error freeing extent (3) of rollback segment (1))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [12014], [12018], [], [], [], [], []

Fri Jul 31 12:53:49 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2924.trc:
ORA-00600: internal error code, arguments: [4193], [13800], [13804], [], [], [], [], []
ORA-00600: internal error code, arguments: [4193], [13800], [13804], [], [], [], [], []

Fri Jul 31 12:53:50 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2924.trc:
ORA-00600: internal error code, arguments: [4193], [13800], [13804], [], [], [], [], []
ORA-00600: internal error code, arguments: [4193], [13800], [13804], [], [], [], [], []

Fri Jul 31 12:53:51 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2924.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4193], [13800], [13804], [], [], [], [], []
ORA-00600: internal error code, arguments: [4193], [13800], [13804], [], [], [], [], []

Fri Jul 31 12:54:51 2009
DEBUG: Replaying xcb 0x1fe1e548, pmd 0x1ff9f194 for failed op 8
Doing block recovery for file 2 block 2267
No block recovery was needed