标签云
asm 恢复 asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 ORACLE恢复 Oracle 恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (100)
- 数据库 (1,597)
- DB2 (22)
- MySQL (70)
- Oracle (1,463)
- Data Guard (49)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (47)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (530)
- Oracle安装升级 (84)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (17)
- PostgreSQL恢复 (5)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- Oracle 19c/21c最新patch信息-202404
- PostgreSQL恢复系列:pg_filedump批量处理
- PostgreSQL部分主要字典信息
- PostgreSQL恢复系列:pg_filedump恢复字典构造
- PostgreSQL 16 源码安装
- ORA-00742 ORA-00312 恢复
- 数据库open成功后报ORA-00353 ORA-00354错误引起的一系列问题(本质ntfs文件系统异常)
- ORA-600 ktsiseginfo1故障
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
- Oracle 19C 备库DML重定向—DML Redirection
月归档:三月 2019
12C数据库遭遇ORA-600 16703
关于tab$异常的问题,我们在10G(10g数据库遭遇ORA-600 16703),11G(警告:互联网中有oracle介质被注入恶意程序导致—ORA-600 16703)中有发现,近期在12C版本中也发现该问题.再次提醒请注意检查安装介质的md5值和现在运行的库中是否有相关恶意程序
数据库版本
alert日志报错
************************************************************ Warning: The SCN headroom for this database is only 45 days! ************************************************************ ************************************************************ Warning: The SCN headroom for this database is only 45 days! ************************************************************ Picked broadcast on commit scheme to generate SCNs Fri Jan 25 11:34:55 2019 Starting background process TMON Fri Jan 25 11:34:55 2019 TMON started with pid=104, OS id=47282 Fri Jan 25 11:34:55 2019 Thread 1 advanced to log sequence 11942 (thread open) Thread 1 opened at log sequence 11942 Current log# 5 seq# 11942 mem# 0: +DATA/xifenfei/ONLINELOG/redo01_01.log Successful open of redo thread 1 Fri Jan 25 11:34:55 2019 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri Jan 25 11:34:55 2019 Network Resource Management enabled for Process LG00 (pid 451491) for Exadata I/O Fri Jan 25 11:34:55 2019 SMON: enabling cache recovery Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_46443.trc (incident=394486): ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Fri Jan 25 11:34:56 2019 Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_46443.trc: ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], [] Fri Jan 25 11:34:56 2019 Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_46443.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], [] Fri Jan 25 11:34:56 2019 Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_46443.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], [] Fri Jan 25 11:34:56 2019 Error 704 happened during db open, shutting down database USER (ospid: 46443): terminating the instance due to error 704 Fri Jan 25 11:34:57 2019 Instance terminated by USER, pid = 46443
处理思路基本上和其他两个版本一样,都是对tab$进行修复,然后直接open数据库,但是在这次的恢复中遇到ORA-00600 kdfReserveSingle_1错误
ORA-600 kdfReserveSingle_1
SQL> alter database open ; alter database open * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kdfReserveSingle_1], [0], [65280], [], [], [], [], [], [], [], [], [] Process ID: 319852 Session ID: 2401 Serial number: 24555 ---alert日志 Starting background process TMON Fri Jan 25 20:51:41 2019 TMON started with pid=94, OS id=322554 Fri Jan 25 20:51:41 2019 Thread 1 advanced to log sequence 11943 (thread open) Thread 1 opened at log sequence 11943 Current log# 6 seq# 11943 mem# 0: +DATA/xifenfei/ONLINELOG/redo02_01.log Successful open of redo thread 1 Fri Jan 25 20:51:41 2019 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri Jan 25 20:51:41 2019 Network Resource Management enabled for Process LG00 (pid 319754) for Exadata I/O Fri Jan 25 20:51:41 2019 SMON: enabling cache recovery Fri Jan 25 20:51:41 2019 [319852] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:88159754 end:88160264 diff:510 ms (0.5 seconds) Verifying minimum file header compatibility (11g) for tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Fri Jan 25 20:51:41 2019 SMON: enabling tx recovery Fri Jan 25 20:51:41 2019 Database Characterset is ZHS16GBK Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_319852.trc (incident=466446): ORA-00600: internal error code, arguments: [kdfReserveSingle_1], [0], [65280], [], [], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Fri Jan 25 20:51:42 2019 Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_319852.trc: ORA-00600: internal error code, arguments: [kdfReserveSingle_1], [0], [65280], [], [], [], [], [], [], [], [], [] Fri Jan 25 20:51:42 2019 Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_319852.trc: ORA-00600: internal error code, arguments: [kdfReserveSingle_1], [0], [65280], [], [], [], [], [], [], [], [], [] Error 600 happened during db open, shutting down database USER (ospid: 319852): terminating the instance due to error 600 Fri Jan 25 20:51:43 2019 Instance terminated by USER, pid = 319852 ORA-1092 signalled during: alter database open… opiodr aborting process unknown ospid (319852) as a result of ORA-1092 Fri Jan 25 20:51:49 2019 ORA-1092 : opitsk aborting process
这个错误主要是由于12c的tab$和以前版本比有一些特殊,导致开始恢复不全,通过继续修复tab$之后数据库正常open.
相关文章汇总
tab$恢复错误汇总
12C数据库遭遇ORA-600 16703
10G数据库遭遇ORA-600 16703
ORA-600 16703故障解析—tab$表被清空
警告:互联网中有oracle介质被注入恶意程序导致—ORA-600 16703
发表在 Oracle
标签为 12c tab$, delete tab$, kdfReserveSingle_1, ORA-600 16703, ORA-600 kdfReserveSingle_1, tab$清空
评论关闭
SCN Compatibility问题汇总-2019年6月23日
最近有不少朋友咨询关于2019年6月23日之前数据库scn,数据库是否要升级或者打补丁等问题,这里对相关问题做一个汇总。
1. 是否一定要升级或者打补丁
不一定,以下几种情况可以不用处理
1) 数据库版本11.1.0.7.20+ /11.2.0.3.9+ /11.2.0.4+版本已经包含了该补丁,无需处理
2) 数据库版本全部低于1)中数据库版本
3) 你的数据库环境中不存在1和2中数据库dblink访问
4) 你的数据库环境中有1和2中的数据库dblink访问,但是通过通过dbms_scn设置,不让1中的数据库版本scn compatibility改变(都保持为1)
2. 到了2019年6月23日之后,数据库的scn发生什么改变
简单的说就是数据库每秒可以使用的scn变大了,距离天花板的scn更加大,出现数据库scn用完的概率大大降低
--compat -- SCN compatibility value --headroom_in_scn -- Difference between current SCN and RSL --headroom_in_sec -- number of seconds it would take to reachRSL SQL> set serveroutput on ; SQL> declare 2 rsl number; 3 headroom_in_scn number; 4 headroom_in_sec number; 5 cur_scn_compat number; 6 max_scn_compat number; 7 begin 8 dbms_scn.GetCurrentSCNParams(rsl,headroom_in_scn,headroom_in_sec,cur_scn_compat,max_scn_compat); 9 dbms_output.put_line('rsl=' || rsl); 10 dbms_output.put_line('headroom_in_scn=' || headroom_in_scn); 11 dbms_output.put_line('headroom_in_sec=' || headroom_in_sec); 12 dbms_output.put_line('cur_scn_compat=' || cur_scn_compat); 13 dbms_output.put_line('max_scn_compat=' || max_scn_compat); 14 end; 15 / rsl=16424869609472 headroom_in_scn=16424867538319 headroom_in_sec=1002494356 cur_scn_compat=1 max_scn_compat=3 PL/SQL procedure successfully completed. SQL> Alter Database Set SCN Compatibility 2; Database altered. SQL> declare 2 rsl number; 3 headroom_in_scn number; 4 headroom_in_sec number; 5 cur_scn_compat number; 6 max_scn_compat number; 7 begin 8 dbms_scn.GetCurrentSCNParams(rsl,headroom_in_scn,headroom_in_sec,cur_scn_compat,max_scn_compat); 9 dbms_output.put_line('rsl=' || rsl); 10 dbms_output.put_line('headroom_in_scn=' || headroom_in_scn); 11 dbms_output.put_line('headroom_in_sec=' || headroom_in_sec); 12 dbms_output.put_line('cur_scn_compat=' || cur_scn_compat); 13 dbms_output.put_line('max_scn_compat=' || max_scn_compat); 14 end; 15 / rsl=21792299122688 headroom_in_scn=21792297051479 headroom_in_sec=665048127 cur_scn_compat=2 max_scn_compat=3 PL/SQL procedure successfully completed. SQL> Alter Database Set SCN Compatibility 3; Database altered. SQL> declare 2 rsl number; 3 headroom_in_scn number; 4 headroom_in_sec number; 5 cur_scn_compat number; 6 max_scn_compat number; 7 begin 8 dbms_scn.GetCurrentSCNParams(rsl,headroom_in_scn,headroom_in_sec,cur_scn_compat,max_scn_compat); 9 dbms_output.put_line('rsl=' || rsl); 10 dbms_output.put_line('headroom_in_scn=' || headroom_in_scn); 11 dbms_output.put_line('headroom_in_sec=' || headroom_in_sec); 12 dbms_output.put_line('cur_scn_compat=' || cur_scn_compat); 13 dbms_output.put_line('max_scn_compat=' || max_scn_compat); 14 end; 15 / rsl=34585263898624 headroom_in_scn=34585261822622 headroom_in_sec=351819476 cur_scn_compat=3 max_scn_compat=3 PL/SQL procedure successfully completed.
这里大概演示了数据库scn compatibility变化带来的相关变化,这里可以看出来每秒
3. 如何禁用/启用scn compatibility自动升级
SQL> begin dbms_scn.DisableAutoRollover; end; 2 / PL/SQL procedure successfully completed. SQL> declare 2 EFFECTIVE_AUTO_ROLLOVER_TS date; 3 TARGET_COMPAT number; 4 IS_ENABLED boolean; 5 begin 6 dbms_scn.GETSCNAUTOROLLOVERPARAMS(EFFECTIVE_AUTO_ROLLOVER_TS,TARGET_COMPAT,IS_ENABLED); 7 dbms_output.put_line('EFFECTIVE_AUTO_ROLLOVER_TS='||to_char(EFFECTIVE_AUTO_ROLLOVER_TS,'yyyy-mm-dd hh24:mi:ss')); 8 dbms_output.put_line('TARGET_COMPAT=' || TARGET_COMPAT); 9 if(IS_ENABLED)then 10 dbms_output.put_line('IS_ENABLED IS TURE'); 11 else 12 dbms_output.put_line('IS_ENABLED IS FALSE'); 13 end if; 14 end; 15 / EFFECTIVE_AUTO_ROLLOVER_TS=2019-06-23 00:00:00 TARGET_COMPAT=3 IS_ENABLED IS FALSE PL/SQL procedure successfully completed. SQL>
4. scn compatibility手工调整
SQL> Alter Database Set SCN Compatibility 2; Database altered. SQL> Alter Database Set SCN Compatibility 3; Database altered. SQL> Alter Database Set SCN Compatibility 1; Alter Database Set SCN Compatibility 1 * ERROR at line 1: ORA-01126: database must be mounted in this instance and not open in any instance SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 4999609080 bytes Fixed Size 9145080 bytes Variable Size 1040187392 bytes Database Buffers 3942645760 bytes Redo Buffers 7630848 bytes Database mounted. SQL> Alter Database Set SCN Compatibility 1; Database altered. SQL> alter database open; Database altered. SQL> set serveroutput on ; SQL> declare 2 rsl number; 3 headroom_in_scn number; 4 headroom_in_sec number; 5 cur_scn_compat number; max_scn_compat number; 6 7 begin 8 dbms_scn.GetCurrentSCNParams(rsl,headroom_in_scn,headroom_in_sec,cur_scn_compat,max_scn_compat); 9 dbms_output.put_line('rsl=' || rsl); dbms_output.put_line('headroom_in_scn=' || headroom_in_scn); 10 11 dbms_output.put_line('headroom_in_sec=' || headroom_in_sec); 12 dbms_output.put_line('cur_scn_compat=' || cur_scn_compat); 13 dbms_output.put_line('max_scn_compat=' || max_scn_compat); end; / 14 15 rsl=16425127591936 headroom_in_scn=16425125502261 headroom_in_sec=1002510101 cur_scn_compat=1 max_scn_compat=3 PL/SQL procedure successfully completed.
参考文档:
Recommended patching and actions for Oracle database versions 12.1.0.1, 11.2.0.3 and earlier-before June 2019(Doc ID 2335265.1)
Recommended patches and actions for Oracle databases versions 12.1.0.1, 11.2.0.3 and earlier–before June 2019(Doc ID 2361478.1)
dul支持Oracle 19C
Oracle 19C
[oracle@localhost ~]$ ss SQL*Plus: Release 19.0.0.0.0 - Production on Sat Mar 2 07:02:18 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.2.0.0.0 SQL> select name from v$datafile where rownum<3; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/ORA19C/system01.dbf /u01/app/oracle/oradata/ORA19C/sysaux01.dbf
dul支持19C
[root@localhost dul]# ./dul Data UnLoader: 11.3.0.0.2 - Internal Only - on Sat Mar 2 08:26:11 2019 with 64-bit io functions and the decompression option Copyright (c) 1994 2018 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only DUL: Warning: Recreating file "dul.log" Found db_id = 1054612630 Found db_name = ORA19C DUL> bootstrap; DUL: Warning: Recreating file "dict.ddl" Generating dict.ddl for version 12 OBJ$: segobjno 18, file 1 block 240 TAB$: segobjno 2, tabno 1, file 1 block 144 COL$: segobjno 2, tabno 5, file 1 block 144 USER$: segobjno 10, tabno 1, file 1 block 208 TABPART$: segobjno 814, file 1 block 5424 INDPART$: segobjno 819, file 1 block 5464 TABCOMPART$: segobjno 836, file 1 block 5600 INDCOMPART$: segobjno 841, file 1 block 5640 TABSUBPART$: segobjno 826, file 1 block 5520 INDSUBPART$: segobjno 831, file 1 block 5560 IND$: segobjno 2, tabno 3, file 1 block 144 ICOL$: segobjno 2, tabno 4, file 1 block 144 LOB$: segobjno 2, tabno 6, file 1 block 144 COLTYPE$: segobjno 2, tabno 7, file 1 block 144 TYPE$: segobjno 740, tabno 1, file 1 block 4888 COLLECTION$: segobjno 740, tabno 2, file 1 block 4888 ATTRIBUTE$: segobjno 740, tabno 3, file 1 block 4888 LOBFRAG$: segobjno 847, file 1 block 5688 LOBCOMPPART$: segobjno 850, file 1 block 5720 UNDO$: segobjno 15, file 1 block 224 TS$: segobjno 6, tabno 2, file 1 block 176 PROPS$: segobjno 127, file 1 block 1320 Running generated file "@dict.ddl" to unload the dictionary tables . unloading table OBJ$ DUL: Warning: Recreating file "OBJ.ctl" 72388 rows unloaded . unloading table TAB$ DUL: Warning: Recreating file "TAB.ctl" 2218 rows unloaded . unloading table COL$ DUL: Warning: Recreating file "COL.ctl" 123175 rows unloaded . unloading table USER$ DUL: Warning: Recreating file "USER.ctl" 127 rows unloaded . unloading table TABPART$ DUL: Warning: Recreating file "TABPART.ctl" 294 rows unloaded . unloading table INDPART$ DUL: Warning: Recreating file "INDPART.ctl" 195 rows unloaded . unloading table TABCOMPART$ DUL: Warning: Recreating file "TABCOMPART.ctl" 1 row unloaded . unloading table INDCOMPART$ DUL: Warning: Recreating file "INDCOMPART.ctl" 0 rows unloaded . unloading table TABSUBPART$ DUL: Warning: Recreating file "TABSUBPART.ctl" 32 rows unloaded . unloading table INDSUBPART$ DUL: Warning: Recreating file "INDSUBPART.ctl" 0 rows unloaded . unloading table IND$ DUL: Warning: Recreating file "IND.ctl" 2878 rows unloaded . unloading table ICOL$ DUL: Warning: Recreating file "ICOL.ctl" 4958 rows unloaded . unloading table LOB$ DUL: Warning: Recreating file "LOB.ctl" 678 rows unloaded . unloading table COLTYPE$ DUL: Warning: Recreating file "COLTYPE.ctl" 2999 rows unloaded . unloading table TYPE$ DUL: Warning: Recreating file "TYPE.ctl" 5895 rows unloaded . unloading table COLLECTION$ DUL: Warning: Recreating file "COLLECTION.ctl" 1384 rows unloaded . unloading table ATTRIBUTE$ DUL: Warning: Recreating file "ATTRIBUTE.ctl" 15365 rows unloaded . unloading table LOBFRAG$ DUL: Warning: Recreating file "LOBFRAG.ctl" 14 rows unloaded . unloading table LOBCOMPPART$ DUL: Warning: Recreating file "LOBCOMPPART.ctl" 0 rows unloaded . unloading table UNDO$ DUL: Warning: Recreating file "UNDO.ctl" 21 rows unloaded . unloading table TS$ DUL: Warning: Recreating file "TS.ctl" 6 rows unloaded . unloading table PROPS$ DUL: Warning: Recreating file "PROPS.ctl" 42 rows unloaded Reading USER.dat 127 entries loaded Reading OBJ.dat 72388 entries loaded and sorted 72388 entries Reading TAB.dat 2201 entries loaded Reading COL.dat DUL: Notice: Increased the size of DC_COLUMNS from 100000 to 132768 entries 123148 entries loaded and sorted 123148 entries Reading TABPART.dat 294 entries loaded and sorted 294 entries Reading TABCOMPART.dat 1 entries loaded and sorted 1 entries Reading TABSUBPART.dat 32 entries loaded and sorted 32 entries Reading INDPART.dat 195 entries loaded and sorted 195 entries Reading INDCOMPART.dat 0 entries loaded and sorted 0 entries Reading INDSUBPART.dat 0 entries loaded and sorted 0 entries Reading IND.dat 2878 entries loaded Reading LOB.dat 678 entries loaded Reading ICOL.dat 4958 entries loaded Reading COLTYPE.dat 2999 entries loaded Reading TYPE.dat 5895 entries loaded Reading ATTRIBUTE.dat 15365 entries loaded Reading COLLECTION.dat 1384 entries loaded Reading BOOTSTRAP.dat 60 entries loaded Reading LOBFRAG.dat 14 entries loaded and sorted 14 entries Reading LOBCOMPPART.dat 0 entries loaded and sorted 0 entries Reading UNDO.dat 21 entries loaded Reading TS.dat 6 entries loaded Reading PROPS.dat 42 entries loaded DUL> desc sys.tab$; Table SYS.TAB$ obj#= 4, dataobj#= 2, ts#= 0, file#= 1, block#=144 tab#= 1, segcols= 45, clucols= 1 Column information: icol# 01 segcol# 01 OBJ# len 22 type 2 NUMBER(0) icol# 02 segcol# 02 DATAOBJ# len 22 type 2 NUMBER(0) icol# 03 segcol# 03 TS# len 22 type 2 NUMBER(0) icol# 04 segcol# 04 FILE# len 22 type 2 NUMBER(0) icol# 05 segcol# 05 BLOCK# len 22 type 2 NUMBER(0) icol# 06 segcol# 06 BOBJ# len 22 type 2 NUMBER(0) icol# 07 segcol# 07 TAB# len 22 type 2 NUMBER(0) icol# 08 segcol# 08 COLS len 22 type 2 NUMBER(0) icol# 09 segcol# 09 CLUCOLS len 22 type 2 NUMBER(0) icol# 10 segcol# 10 PCTFREE$ len 22 type 2 NUMBER(0) icol# 11 segcol# 11 PCTUSED$ len 22 type 2 NUMBER(0) icol# 12 segcol# 12 INITRANS len 22 type 2 NUMBER(0) icol# 13 segcol# 13 MAXTRANS len 22 type 2 NUMBER(0) icol# 14 segcol# 14 FLAGS len 22 type 2 NUMBER(0) icol# 15 segcol# 15 AUDIT$ len 38 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 16 segcol# 16 ROWCNT len 22 type 2 NUMBER(0) icol# 17 segcol# 17 BLKCNT len 22 type 2 NUMBER(0) icol# 18 segcol# 18 EMPCNT len 22 type 2 NUMBER(0) icol# 19 segcol# 19 AVGSPC len 22 type 2 NUMBER(0) icol# 20 segcol# 20 CHNCNT len 22 type 2 NUMBER(0) icol# 21 segcol# 21 AVGRLN len 22 type 2 NUMBER(0) icol# 22 segcol# 22 AVGSPC_FLB len 22 type 2 NUMBER(0) icol# 23 segcol# 23 FLBCNT len 22 type 2 NUMBER(0) icol# 24 segcol# 24 ANALYZETIME len 7 type 12 DATE icol# 25 segcol# 25 SAMPLESIZE len 22 type 2 NUMBER(0) icol# 26 segcol# 26 DEGREE len 22 type 2 NUMBER(0) icol# 27 segcol# 27 INSTANCES len 22 type 2 NUMBER(0) icol# 28 segcol# 28 INTCOLS len 22 type 2 NUMBER(0) icol# 29 segcol# 29 KERNELCOLS len 22 type 2 NUMBER(0) icol# 30 segcol# 30 PROPERTY len 22 type 2 NUMBER(0) icol# 31 segcol# 31 TRIGFLAG len 22 type 2 NUMBER(0) icol# 32 segcol# 32 SPARE1 len 22 type 2 NUMBER(0) icol# 33 segcol# 33 SPARE2 len 22 type 2 NUMBER(0) icol# 34 segcol# 34 SPARE3 len 22 type 2 NUMBER(0) icol# 35 segcol# 35 SPARE4 len 1000 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 36 segcol# 36 SPARE5 len 1000 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 37 segcol# 37 SPARE6 len 7 type 12 DATE icol# 38 segcol# 38 SPARE7 len 22 type 2 NUMBER(0) icol# 39 segcol# 39 SPARE8 len 22 type 2 NUMBER(0) icol# 40 segcol# 40 SPARE9 len 1000 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 41 segcol# 41 SPARE10 len 1000 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 42 segcol# 42 ACDRFLAGS len 22 type 2 NUMBER(0) icol# 43 segcol# 43 ACDRTSOBJ# len 22 type 2 NUMBER(0) icol# 44 segcol# 44 ACDRDEFAULTTIME len 11 type 180 TIMESTAMP(9) icol# 45 segcol# 45 ACDRROWTSINTCOL# len 22 type 2 NUMBER(0)
可能遇到错误
Reading TAB.dat DUL: Error: string2ub8(618970019642690137449563136), Conversion to number (ub8) overflowed DUL: Error: Number conversion error in file TAB.dat, line 22 DUL: Warning: Ignoring file TAB.dat cache Reading COL.dat DUL: Error: string2ub8(73786976294838206464), Conversion to number (ub8) overflowed DUL: Error: Number conversion error in file COL.dat, line 114321 DUL: Warning: Ignoring file COL.dat cache