数据库做不完全恢复后,虽然可以打开数据库,但做一些DDL/DML操作,会出现ora-600[4000]错误及[4097]错误。通常情况下建议导出数据后重建,但这样太费时间。通过如下处理,已知可以避开这些错误,如果有环境,可以再测试一下。
[@more@]BANNER
-----------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
SQL> @E:BakORACLEchensq
Creating package CHENSQ
=======================
create or replace package chensq is
*
第 1 行出现错误:
ORA-00603: ORACLE 服务器会话因致命错误而终止
进程 ID: 2556
会话 ID: 170 序列号: 5
SQL> shutdown immediate;
ORA-00600: 内部错误代码, 参数: [4000], [6], [], [], [], [], [], []
SQL> shutdown immediate;
ORA-00600: 内部错误代码, 参数: [4000], [6], [], [], [], [], [], []
SQL> shutdown immediate;
ORA-00600: 内部错误代码, 参数: [4000], [6], [], [], [], [], [], []
US# NAME TS# FILE#
--------- ------------------------ ---------- ----------
0 SYSTEM 0 1
2 _SYSSMU2_1245841283$ 2 3
13 _SYSSMU13_1245841283$ 2 3
14 _SYSSMU14_1245841283$ 2 3
15 _SYSSMU15_1245841283$ 2 3
16 _SYSSMU16_1245841283$ 2 3
17 _SYSSMU17_1245841283$ 2 3
18 _SYSSMU18_1245841283$ 2 3
19 _SYSSMU19_1245841283$ 2 3
20 _SYSSMU20_1245841283$ 2 3
1 _SYSSMU1_1245841283$ 2 3
已选择11行。
SQL> l
1* select us#,name,ts#,file# from undo$
SQL> /
US# NAME TS# FILE#
---------- ------------------------ ---------- ----------
0 SYSTEM 0 1
2 _SYSSMU2_1245841283$ 2 3
13 _SYSSMU13_1245841283$ 2 3
14 _SYSSMU14_1245841283$ 2 3
15 _SYSSMU15_1245841283$ 2 3
16 _SYSSMU16_1245841283$ 2 3
17 _SYSSMU17_1245841283$ 2 3
18 _SYSSMU18_1245841283$ 2 3
19 _SYSSMU19_1245841283$ 2 3
20 _SYSSMU20_1245841283$ 2 3
1 _SYSSMU1_1245841283$ 2 3
已选择11行。
SQL> select name,ts# from v$tablespace;
NAME TS#
------------------------ ----------
SYSTEM 0
SYSAUX 1
UNDOTBS1 2
USERS 4
TEMP 3
SQL> create undo tablespace undotbs2;
表空间已创建。
SQL> /
US# NAME TS# FILE#
---------- ------------------------ ---------- ----------
0 SYSTEM 0 1
2 _SYSSMU2_1245841283$ 2 3
3 _SYSSMU3_1245921918$ 5 5
4 _SYSSMU4_1245921918$ 5 5
5 _SYSSMU5_1245921918$ 5 5
6 _SYSSMU6_1245921918$ 5 5
7 _SYSSMU7_1245921918$ 5 5
8 _SYSSMU8_1245921918$ 5 5
9 _SYSSMU9_1245921918$ 5 5
10 _SYSSMU10_1245921918$ 5 5
11 _SYSSMU11_1245921918$ 5 5
12 _SYSSMU12_1245921918$ 5 5
13 _SYSSMU13_1245841283$ 2 3
14 _SYSSMU14_1245841283$ 2 3
15 _SYSSMU15_1245841283$ 2 3
16 _SYSSMU16_1245841283$ 2 3
17 _SYSSMU17_1245841283$ 2 3
18 _SYSSMU18_1245841283$ 2 3
19 _SYSSMU19_1245841283$ 2 3
20 _SYSSMU20_1245841283$ 2 3
21 _SYSSMU21_1245921928$ 6 6
1 _SYSSMU1_1245841283$ 2 3
22 _SYSSMU22_1245921928$ 6 6
23 _SYSSMU23_1245921928$ 6 6
24 _SYSSMU24_1245921928$ 6 6
25 _SYSSMU25_1245921928$ 6 6
26 _SYSSMU26_1245921928$ 6 6
27 _SYSSMU27_1245921928$ 6 6
28 _SYSSMU28_1245921929$ 6 6
29 _SYSSMU29_1245921929$ 6 6
30 _SYSSMU30_1245921929$ 6 6
SQL> create undo tablespace undotbs3;
表空间已创建。
SQL> alter system set undo_tablespace=undotbs3;
系统已更改。
SQL> drop tablespace undotbs1;
表空间已删除。
Thu Jun 25 17:25:15 2009
create undo tablespace undotbs2
Completed: create undo tablespace undotbs2
Thu Jun 25 17:25:26 2009
create undo tablespace undotbs3
Completed: create undo tablespace undotbs3
Thu Jun 25 17:25:44 2009
Successfully onlined Undo Tablespace 6.
Undo Segment 1 Offlined
Undo Segment 2 Offlined
Undo Tablespace 2 successfully switched out.
ALTER SYSTEM SET undo_tablespace='UNDOTBS3' SCOPE=BOTH;
drop tablespace undotbs1
Completed: drop tablespace undotbs1
Thu Jun 25 17:27:02 2009
Errors in file d:oraclediagrdbmsr11gr11gtracer11g_ora_4840.trc (incident=106018):
ORA-00600: 内部错误代码, 参数: [4097], [], [], [], [], [], [], []
Incident details in: d:oraclediagrdbmsr11gr11gincidentincdir_106018r11g_ora_4840_i106018.trc
Errors in file d:oraclediagrdbmsr11gr11gtracer11g_ora_4840.trc (incident=106019):
ORA-00603: ORACLE 服务器会话因致命错误而终止
ORA-00600: 内部错误代码, 参数: [4097], [], [], [], [], [], [], []
Incident details in: d:oraclediagrdbmsr11gr11gincidentincdir_106019r11g_ora_4840_i106019.trc
Thu Jun 25 17:27:04 2009
Trace dumping is performing id=[cdmp_20090625172704]
ORA-603 : opiodr aborting process unknown ospid (3912_4840)
SQL> drop tablespace undotbs2;
表空间已删除。
SQL> select 'drop rollback segment "'||name||'";' from undo$ where file# in (2,
);
'DROPROLLBACKSEGMENT"'||NAME||'";'
-------------------------------------------------------
drop rollback segment "_SYSSMU3_1245921918$";
drop rollback segment "_SYSSMU4_1245921918$";
drop rollback segment "_SYSSMU5_1245921918$";
drop rollback segment "_SYSSMU6_1245921918$";
drop rollback segment "_SYSSMU7_1245921918$";
drop rollback segment "_SYSSMU8_1245921918$";
drop rollback segment "_SYSSMU9_1245921918$";
drop rollback segment "_SYSSMU10_1245921918$";
drop rollback segment "_SYSSMU11_1245921918$";
drop rollback segment "_SYSSMU12_1245921918$";
已选择10行。
SQL> drop rollback segment "_SYSSMU3_1245921918$";
回退段已删除。
SQL> drop rollback segment "_SYSSMU4_1245921918$";
回退段已删除。
SQL> drop rollback segment "_SYSSMU5_1245921918$";
回退段已删除。
SQL> drop rollback segment "_SYSSMU6_1245921918$";
回退段已删除。
SQL> drop rollback segment "_SYSSMU7_1245921918$";
回退段已删除。
SQL> drop rollback segment "_SYSSMU8_1245921918$";
回退段已删除。
SQL> drop rollback segment "_SYSSMU9_1245921918$";
回退段已删除。
SQL> drop rollback segment "_SYSSMU10_1245921918$";
回退段已删除。
SQL> drop rollback segment "_SYSSMU11_1245921918$";
回退段已删除。
SQL> drop rollback segment "_SYSSMU12_1245921918$";
回退段已删除。
SQL> @E:BakORACLEchensq
Creating package CHENSQ
=======================
程序包已创建。
Creating function BLK_NROW
==========================
函数已创建。
Creating function BLK_VALUE
===========================
警告: 创建的函数带有编译错误。
Creating function CPY
=====================
警告: 创建的函数带有编译错误。
Creating function CSOUND
========================
函数已创建。
Creating function DATABASE_NAME
===============================
函数已创建。
Creating function DATA_BLK_HDLEN
================================
函数已创建。
Creating function DATA_BLK_NROW
===============================
函数已创建。
Creating function DATA_BLK_OFFS
===============================
警告: 创建的函数带有编译错误。
Creating function DATA_BLK_VALUE
================================
函数已创建。
Creating function DUMP_HEX_TO_ACT
=================================
函数已创建。
Creating function RMB
=====================
函数已创建。
Creating function TAB_BLOCK_USED_RATIO
======================================
函数已创建。
Creating function TO_ROWID
==========================
函数已创建。
Creating procedure DMP_BLK
==========================
过程已创建。
Creating procedure DUMP_BLK
===========================
过程已创建。
Creating procedure PRO_BLK_REC
==============================
警告: 创建的过程带有编译错误。
Creating procedure PRO_BLK_VALUE
================================
过程已创建。
Creating package body CHENSQ
============================
程序包体已创建。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21072/viewspace-1023501/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21072/viewspace-1023501/