Truncate异常恢复三之GDUL恢复

Truncate异常恢复一之Truncate前后对比
Truncate异常恢复二之DBMS恢复
Truncate异常恢复三之GDUL恢复
Truncate异常恢复四之BBED恢复
Truncate异常恢复四之BBED恢复

构建测试表

SQL> create table devin.test_trun as select * from dba_objects;

Table created.

SQL> select count(*) from devin.test_trun;

  COUNT(*)
----------
     72837

# truncate数据

SQL> truncate table devin.test_trun;

Table truncated.

SQL> alter system checkpoint;

System altered.

复制

执行恢复

./GDUL
GDUL> desc devin.test_trun;

object_id: 78540, dataobj#: 78546, cluster tab#: 0
segment header: (ts#: 9, rfile#: 9, block#: 154)

Name                 Null?           Type
-------------------- --------------- -------------------
OWNER                                VARCHAR2(128)
OBJECT_NAME                          VARCHAR2(128)
SUBOBJECT_NAME                       VARCHAR2(128)
OBJECT_ID                            NUMBER
DATA_OBJECT_ID                       NUMBER
OBJECT_TYPE                          VARCHAR2(23)
CREATED                              DATE
LAST_DDL_TIME                        DATE
TIMESTAMP                            VARCHAR2(19)
STATUS                               VARCHAR2(7)
TEMPORARY                            VARCHAR2(1)
GENERATED                            VARCHAR2(1)
SECONDARY                            VARCHAR2(1)
NAMESPACE                            NUMBER
EDITION_NAME                         VARCHAR2(128)
SHARING                              VARCHAR2(18)
EDITIONABLE                          VARCHAR2(1)
ORACLE_MAINTAINED                    VARCHAR2(1)
APPLICATION                          VARCHAR2(1)
DEFAULT_COLLATION                    VARCHAR2(100)
DUPLICATED                           VARCHAR2(1)
SHARDED                              VARCHAR2(1)
CREATED_APPID                        NUMBER
CREATED_VSNID                        NUMBER
MODIFIED_APPID                       NUMBER
MODIFIED_VSNID                       NUMBER


GDUL> scan tablespace 9
start scan tablespace 9 in parallel 1...
scan tablespace completed.
GDUL> untrunc table devin.test_trun;
 2021-10-22 08:22:33 untruncating table "DEVIN"."TEST_TRUN" in parallel 1...
 2021-10-22 08:22:33 untruncated 72837 rows.

复制

导入数据

[oracle@devin-enmo dump]$ mv DEVIN_TEST_TRUN.dmp /u01/app/oracle/admin/hkora/dpdump/

[oracle@devin-enmo dump]$ impdp devin/******** directory=DATA_PUMP_DIR dumpfile=DEVIN_TEST_TRUN.dmp

Import: Release 12.2.0.1.0 - Production on Fri Oct 22 08:24:24 2021

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "DEVIN"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "DEVIN"."SYS_IMPORT_FULL_01":  devin/******** directory=DATA_PUMP_DIR dumpfile=DEVIN_TEST_TRUN.dmp
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "DEVIN"."TEST_TRUN"                         124.8 KB    1000 out of 72837 rows
Job "DEVIN"."SYS_IMPORT_FULL_01" successfully completed at Fri Oct 22 08:24:34 2021 elapsed 0 00:00:05



复制

GDUL之前的版本是免费的，但是新版本已经开始收费，免费版只能恢复1000条数据，类似的工具还有ODUL等等。