Hi,
I am currently doing a DR activity.
My database is in version 10.2.0.3.0 and the platform is Windows 2003 server.
When I try to startup my database, the database gets started, but gets crashed immediately after few seconds.
The PMON and DBWR background processes are getting crashed.
ORA-00472: PMON process terminated with error
The alert log gives the below information.
Errors in file d:\oracle\admin\aspplmp1\bdump\aspplmp1_smon_5280.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [60], [59], [], [], [], [], []
Thu Jun 24 22:22:43 2010
Errors in file d:\oracle\admin\aspplmp1\bdump\aspplmp1_smon_5280.trc:
ORA-00600: internal error code, arguments: [4194], [26], [30], [], [], [], [], []
Doing block recovery for file 2 block 2026
Block recovery from logseq 8749, block 141 to scn 10598515167830
Thu Jun 24 22:22:45 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 8749 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\ASPPLMP1\REDO03A.RDO
Mem# 1: D:\ORACLE\ORADATA\ASPPLMP1\REDO03B.RDO
Block recovery stopped at EOT rba 8749.142.16
Block recovery completed at rba 8749.142.16, scn 2467.2830848597
Doing block recovery for file 2 block 41
Block recovery from logseq 8749, block 141 to scn 10598515167828
Thu Jun 24 22:22:45 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 8749 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\ASPPLMP1\REDO03A.RDO
Mem# 1: D:\ORACLE\ORADATA\ASPPLMP1\REDO03B.RDO
Block recovery completed at rba 8749.142.16, scn 2467.2830848597
Thu Jun 24 22:22:45 2010
Errors in file d:\oracle\admin\aspplmp1\bdump\aspplmp1_smon_5280.trc:
ORA-01595: error freeing extent (2) of rollback segment (3))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [26], [30], [], [], [], [], []
Thu Jun 24 22:14:09 2010
Errors in file d:\oracle\admin\aspplmp1\bdump\aspplmp1_q000_1868.trc:
ORA-00600: internal error code, arguments: [4193], [10635], [10638], [], [], [], [], []
ORA-00472: PMON process terminated with error
When I checked metalink, I found a note: 8240762.8, which says that its a bug.
But the workaround they have given is to DROP UNDO SEGMENTS. How do I do that? Could someone please help me out?
OR is there a different way to solve this issue?
Thanks!