ORA-600 [4194] – Fix undo tablespace error

Problem:

——————————————————————————–
ALERT

Fri Feb 24 07:07:52 2012
Recovery of Online Redo Log: Thread 1 Group 3 Seq 106 Reading mem 0
Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\VAT\REDO03.LOG
Block recovery completed at rba 106.90.16, scn 2121.722804375
Doing block recovery for file 2 block 57
Block recovery from logseq 106, block 84 to scn 9110348439454
Fri Feb 24 07:07:53 2012
Recovery of Online Redo Log: Thread 1 Group 3 Seq 106 Reading mem 0
Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\VAT\REDO03.LOG
Block recovery completed at rba 106.1282.16, scn 2121.722804642
ORA-607 encountered when generating server alert SMG-3506
Fri Feb 24 07:07:53 2012
Errors in file d:\oracle\product\10.2.0\admin\vat\udump\vat_ora_5740.trc:
ORA-00600: internal error code, arguments: [4194], [2], [4], [], [], [], [], []
——————————————————————————–
Solution:

1.Backup your database.
2.Create new undo tablespace(for example create undo tablespace <new_undo_ts> ….);
CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE
‘D:\oracle\product\10.2.0\oradata\VAT\UNDOTBS02.DBF’ SIZE 2048M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
ONLINE
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON;
3.If you use spfile then create pfile from spfile as create pfile=’location’ from spfile=’spfilelocation’
create pfile=’D:\Backup\intVAT123.ora’ from spfile;
4.Change in getting pfile undo_management=manual,undo_tablespace=<new_undo_ts>
*.undo_management=’MANUAL’
*.undo_tablespace=’UNDOTBS2′

5.startup database using this pfile as startup pfile=’pfilelocation’
6.drop tablespace <old_undo_tsname>;
DROP TABLESPACE UNDOTBS1;
7.Change undo_management=auto in pfile and create spfile from pfile again.

vodka_VN

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s