發現這個問題的解決,只能遷移表空間恢復資料後,

重建表空間

[@more@]

Dump file g:oracleadminhbxnbdumphbxn_pmon_2836.trc
Mon Nov 09 11:24:27 2009
ORACLE V9.2.0.8.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Instance name: hbxn

Redo thread mounted by this instance: 1

Oracle process number: 2

Windows thread id: 2836, image: ORACLE.EXE

*** 2009-11-09 11:24:27.812
*** SESSION ID:(1.3) 2009-11-09 11:24:27.781
error 600 detected in background process
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

--------------------------------------------------------------------------------------------------------------------------------------------
Dump file g:oracleadminhbxnbdumphbxn_dbw4_3676.trc
Mon Nov 09 11:24:28 2009
ORACLE V9.2.0.8.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Instance name: hbxn

Redo thread mounted by this instance: 1

Oracle process number: 7

Windows thread id: 3676, image: ORACLE.EXE

*** 2009-11-09 11:24:28.031
*** SESSION ID:(6.25) 2009-11-09 11:24:27.828
error 600 detected in background process
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
--------------------------------------------------------------------------------------------------------------------------------------------

Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON encountered 96 out of maximum 100 non-fatal internal errors.
Wed Sep 30 08:07:21 2009
Errors in file g:oracleadminhbxnbdumphbxn_smon_1504.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_12], [4], [], [], [], [], [], []

Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON encountered 97 out of maximum 100 non-fatal internal errors.
Wed Sep 30 08:07:32 2009
Errors in file g:oracleadminhbxnbdumphbxn_smon_1504.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_12], [4], [], [], [], [], [], []

Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON encountered 98 out of maximum 100 non-fatal internal errors.
Wed Sep 30 08:07:44 2009
Errors in file g:oracleadminhbxnbdumphbxn_smon_1504.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_12], [4], [], [], [], [], [], []

Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON encountered 99 out of maximum 100 non-fatal internal errors.
Wed Sep 30 08:07:52 2009
Errors in file g:oracleadminhbxnbdumphbxn_smon_1504.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_12], [4], [], [], [], [], [], []

Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON encountered 100 out of maximum 100 non-fatal internal errors.
Wed Sep 30 08:08:07 2009
Errors in file g:oracleadminhbxnbdumphbxn_smon_1504.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_12], [4], [], [], [], [], [], []

Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON exceeded the maximum limit of 100 internal error(s).
Wed Sep 30 08:08:21 2009
Errors in file g:oracleadminhbxnbdumphbxn_smon_1504.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_12], [4], [], [], [], [], [], []

SMON: terminating instance due to error 600
Wed Sep 30 08:08:21 2009
Errors in file g:oracleadminhbxnbdumphbxn_dbw3_1556.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:21 2009
Errors in file g:oracleadminhbxnbdumphbxn_dbw1_328.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:21 2009
Errors in file g:oracleadminhbxnbdumphbxn_dbw4_1968.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:21 2009
Errors in file g:oracleadminhbxnudumphbxn_p003_1812.trc:
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [15784], [600], [], [], [], [], [], []
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:22 2009
Errors in file g:oracleadminhbxnudumphbxn_p002_2428.trc:
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [15784], [600], [], [], [], [], [], []
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:22 2009
Errors in file g:oracleadminhbxnbdumphbxn_dbw5_3892.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:23 2009
Errors in file g:oracleadminhbxnudumphbxn_p000_4048.trc:
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [15784], [600], [], [], [], [], [], []
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:24 2009
Errors in file g:oracleadminhbxnudumphbxn_s001_1816.trc:
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:24 2009
Errors in file g:oracleadminhbxnudumphbxn_p007_2000.trc:
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [15784], [600], [], [], [], [], [], []
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:24 2009
Errors in file g:oracleadminhbxnudumphbxn_p006_2468.trc:
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [15784], [600], [], [], [], [], [], []
ORA-00600: ÄÚ²¿´íÎó´úÂë£¬²ÎÊý: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:24 2009
Errors in file g:oracleadminhbxnbdumphbxn_pmon_2448.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:25 2009
Errors in file g:oracleadminhbxnbdumphbxn_dbw0_1804.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:25 2009
Errors in file g:oracleadminhbxnbdumphbxn_dbw2_2524.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

Wed Sep 30 08:08:26 2009
Errors in file g:oracleadminhbxnbdumphbxn_reco_2792.trc:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

--------------------------------------------------------------------------------------------------------------------------------------------
Dump file g:oracleadminhbxnbdumphbxn_smon_696.trc
Mon Nov 09 11:09:35 2009
ORACLE V9.2.0.8.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Instance name: hbxn

Redo thread mounted by this instance: 1

Oracle process number: 11

Windows thread id: 696, image: ORACLE.EXE

*** 2009-11-09 11:09:35.078
*** SESSION ID:(10.25) 2009-11-09 11:09:35.078
BH (0x8FE85B70) file#: 85 rdba: 0x15456223 (85/352803) class 1 ba: 0x00000000
set: 47 dbwrid: 2 obj: 1194963 objn: 1194963
hash: [87cd3cdc,87cd3cdc] lru: [8e359548,8e3b7dc8]
ckptq: [NULL] fileq: [NULL]
st: XCURRENT md: NULL rsop: 0x00000000 tch: 0
flags: only_sequential_access
LRBA: [0x0.0.0] HSCN: [0xffff.ffffffff] HSUB: [255] RRBA: [0x0.0.0]
*** 2009-11-09 11:09:35.078
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcbgtcr_12], [4], [], [], [], [], [], []
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+327 CALLrel _ksedst+0
_ksfdmp.108+14 CALLrel _ksedmp+0 3
_kgerinv+131 CALLreg 00000000 4FD5808 3
_kgeasnmierr+19 CALLrel _kgerinv+0 4FD5808 64EC4CC 27DA4A4 1
64BCFF8
_kcbassertb1+73 CALLrel _kgeasnmierr+0 4FD5808 64EC4CC 27DA4A4 1 4 4
__VInfreq__kcbgtcr+ CALLrel _kcbassertb1+0 27DA4A4 8FE85B70 4
2940
_ktecgsc.68+225 CALLrel _kcbgtcr+0
_ktecgetsh+153 CALLrel _ktecgsc.68+0 64BD6A4 3 6 64BD628 186
..1.4_1.filter.68+1 CALLrel _ktecgetsh+0 64BD6A4 3 6 64BD628 186 0
27
_kteinicnt+579 CALLrel _ktecgshx+0
_ktssdrbm_segment+2 CALLrel _kteinicnt+0 64BD8F8 4 64BDA20 64BD8D8 1 2
99 0
_ktssdro_segment+12 CALLrel _ktssdrbm_segment+0 64BDBDC 64BDA60 1
16
_ktssdt_segs+306 CALLrel _ktssdro_segment+0 4FD5680 8B7BBA2C
_ktmmon+7689 CALLrel _ktssdt_segs+0 0 7FFFFFFF 7FFFFFFF 0
_ksbrdp+603 CALLreg 00000000 221D450 27FDBC0 221D460 B 2B8
_opirip+587 CALLrel _ksbrdp+0
_opidrv+654 CALLrel _opirip+0 32 0 0
_sou2o+25 CALLrel _opidrv+0
_opimai+336 CALLrel _sou2o+0 64BFE20 32 0 0
_BackgroundThreadSt CALLrel _opimai+0

--------------------------------------------------------------------------------------------------------------------------------------------
SQL> exec dbms_space_admin.segment_drop_corrupt('IMAS_TBS2',85,352803);

PL/SQL procedure successfully completed

SQL> EXEC Dbms_space_admin.tablespace_verify ('IMAS_TBS2');

begin Dbms_space_admin.tablespace_verify ('IMAS_TBS2'); end;

ORA-08103: ¶ÔÏó²»ÔÙ´æÔÚ
ORA-06512: ÔÚ"SYS.DBMS_SPACE_ADMIN", line 149
ORA-06512: ÔÚline 2

SQL>
SQL> DBMS_SPACE_ADMIN.
2
SQL> EXEC Dbms_space_admin.tablespace_verify ('IMAS_TBS3');

PL/SQL procedure successfully completed

SQL> EXEC Dbms_space_admin.tablespace_verify ('IMAS_TBS4');

PL/SQL procedure successfully completed

SQL> EXEC Dbms_space_admin.tablespace_verify ('IMAS_TBS5');

PL/SQL procedure successfully completed

SQL>
SQL> EXEC Dbms_space_admin.tablespace_verify ('IMAS_TBS6');

PL/SQL procedure successfully completed

SQL> EXEC Dbms_space_admin.tablespace_verify ('IMAS_TBS7');

PL/SQL procedure successfully completed

SQL> EXEC Dbms_space_admin.tablespace_verify ('IMAS_TBS8');

PL/SQL procedure successfully completed

SQL> EXEC Dbms_space_admin.tablespace_verify ('IMAS_TBS9');

PL/SQL procedure successfully completed

SQL> EXEC Dbms_space_admin.tablespace_verify ('IMAS_TBS10');

begin Dbms_space_admin.tablespace_verify ('IMAS_TBS10'); end;
--------------------------------------------------------------------------------------------------------------------------------------------
alter table zxcdr move partition P09100704 tablespace imas_tbs ;

ORA-00600: internal error code, arguments: [kcbgtcr_12], [4]

相關文章