断电引起ORA-600和ORA-1280错误

2009-9-16 6:47的时间停电了,导致数据库出现错误
EM home页面出现以两个错误
1:
STREAMS 捕获进程 "CAP_TEACHPLAN_N" 已中止, 出现 ORA-1280

2:
Internal error (ORA-600[4194]) detected in D:oraclediagrdbmsgoldbridgoldbridalertlog.xml at time/line number: Wed Sep 16 17:15:05 2009/197189.
POSSIBLE ROLLBACK SEGMENT CORRUPTION

查看详细日志,发现是datafile 3出了问题,查看dba_data_files发现是undotbs1出了问题,由于没有做备份,只好重新建立一个新的undo表空间undotbs2来代替

16-Sep-2009 16:23:58 CST INCIDENT_ERROR 1 152651 Generic Internal Error 537531436 Errors in file d:oraclediagrdbmsgoldbridgoldbridtracegoldbrid_j002_6720.trc (incident=152651): ORA-00600: 内部错误代码, 参数: [4194], [131], [135], [], [], [], [], []
16-Sep-2009 16:23:49 CST UNKNOWN 16


Block recovery completed at rba 2378.34205.16, scn 0.64436974
16-Sep-2009 16:23:49 CST UNKNOWN 16


Recovery of Online Redo Log: Thread 1 Group 5 Seq 2378 Reading mem 0
16-Sep-2009 16:23:49 CST UNKNOWN 16


Mem# 0: D:ORACLEORADATAGOLDBRIDREDO05.LOG
16-Sep-2009 16:23:49 CST UNKNOWN 16


Doing block recovery for file 3 block 53
16-Sep-2009 16:23:49 CST UNKNOWN 16


Block recovery from logseq 2378, block 15882 to scn 64436972
16-Sep-2009 16:23:49 CST UNKNOWN 16


Block recovery stopped at EOT rba 2378.34210.16
16-Sep-2009 16:23:49 CST UNKNOWN 16


Block recovery completed at rba 2378.34210.16, scn 0.64436980
16-Sep-2009 16:23:48 CST UNKNOWN 16


Block recovery from logseq 2378, block 34170 to scn 64436980
16-Sep-2009 16:23:48 CST UNKNOWN 16


Recovery of Online Redo Log: Thread 1 Group 5 Seq 2378 Reading mem 0
16-Sep-2009 16:23:48 CST UNKNOWN 16


Mem# 0: D:ORACLEORADATAGOLDBRIDREDO05.LOG
16-Sep-2009 16:23:48 CST UNKNOWN 16


Doing block recovery for file 3 block 249

处理方法

1:建立新的undo表空间
SQL> create undo tablespace undotbs2 datafile 'F:ORACLEORADATAGOLDBRIDUNDOTBS2_01.DBF' size 500m;

Tablespace created

SQL> alter system set undo_tablespace=undotbs2 scope=both;

System altered
2:capture重新启动后,查看streams是否恢复,发现可以从2009-9-16 6:47:55的时间点进行

SQL> select * from v$streams_transaction;

STREAMS_NAME STREAMS_TYPE XIDUSN XIDSLT XIDSQN CUMULATIVE_MESSAGE_COUNT TOTAL_MESSAGE_COUNT FIRST_MESSAGE_TIME FIRST_MESSAGE_NUMBER LAST_MESSAGE_TIME LAST_MESSAGE_NUMBER
------------------------------ ------------ ---------- ---------- ---------- ------------------------ ------------------- ------------------ -------------------- ----------------- -------------------
CAP_TEACHPLAN_N CAPTURE 8 62 18884 125 0 2009-9-16 6:47:55 64357115 2009-9-16 6:47:55 64357117

SQL> drop tablespace UNDOTBS1 including contents;

drop tablespace UNDOTBS1 including contents

ORA-30013: 还原表空间 'UNDOTBS1' 当前正在使用中
发现还有没有提交的事务,过一段时间后再执行一次,可以完成

SQL> drop tablespace UNDOTBS1 including contents;

Tablespace dropped
3:执行一次全备份

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/67798/viewspace-1027041/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/67798/viewspace-1027041/