一、验证 GaussDB T 支持闪回事务查询功能
环境:redhat7.5+gaussdb100
1. 创建表:
SQL> conn wsx/password@127.0.0.1:1888
connected.
SQL> create table wsx.t1 as select * from dual;
Succeed.
2. 模拟delete操作:
SQL> delete from wsx.t1;
1 rows affected.
SQL>
SQL>
SQL> commit;
Succeed.
SQL> select * from t1;
DUMMY
-----
0 rows fetched.
SQL> select sysdate from dual;
SYSDATE
----------------------
2020-02-18 17:05:56
1 rows fetched.
3. 查看回收站是否有记录。
SQL> col org_name format a10;
SQL>
SQL> col partition_name format a10;
SQL>
SQL>
SQL> conn / as sysdba
connected.
SQL>
SQL> select name,user#,org_name,partition_name,operation#,flags from sys_recyclebin;
NAME USER# ORG_NAME PARTITION_ OPERATION# FLAGS
------------------------------ ------------ ---------- ---------- ------------ ------------
0 rows fetched.
4.闪回查询
SQL> SELECT * FROM wsx.t1
AS OF TIMESTAMP TO_DATE ('2020/02/18 17:04:00', 'yyyy/mm/dd hh24:mi:ss');
DUMMY
-----
X
1 rows fetched.
5.恢复表wsx.t1在2020.02.18 17:04:00误删除的记录:
SQL> conn wsx/password@127.0.0.1:1888
connected.
SQL>
SQL>
SQL> insert into wsx.t1
(SELECT * FROM wsx.t1
AS OF TIMESTAMP TO_DATE ('2020/02/18 17:04:00', 'yyyy/mm/dd hh24:mi:ss'));
1 rows affected.
SQL>
SQL> commit;
Succeed.
SQL>
SQL>
SQL> select * from wsx.t1;
DUMMY
-----
X
1 rows fetched.
----可以看到,表wsx.t1已经有记录了
总的来说,gaussdb100 T 是可以支持闪回事务查询。
二、GaussDB T 的 Flashback Table 功能非常强劲可以闪回TRUNCATE
Gaussdb提供了类似Oracle的闪回表功能;可以很好的应对drop table或者truncate table的误操作场景;这个功能非