OceanBase 支持回收站功能，通过回收站可以闪回已删除的表。默认回收站是开启的，回收站是否开启由租户变量 recyclebin 控制。

    开启/关闭回收站的语法是：

    1. set global recyclebin = ON | OFF ;

    修改回收站的开启状态后，只对后续新连接会话生效。

    • 示例：闪回被删除的表。
    1. obclient> drop table if exists t1;
    2. Query OK, 0 rows affected (0.02 sec)
    4. obclient> create table t1(id bigint not null primary key, gmt_create datetime not null default current_timestamp);
    5. Query OK, 0 rows affected (0.09 sec)
    7. obclient> insert into t1(id) values(1),(2),(3);
    8. Query OK, 3 rows affected (0.02 sec)
    9. Records: 3  Duplicates: 0  Warnings: 0
    11. obclient> select * from t1;
    12. +----+---------------------+
    13. | ID | GMT_CREATE          |
    14. +----+---------------------+
    15. |  1 | 2020-02-28 09:47:07 |
    16. |  2 | 2020-02-28 09:47:07 |
    17. |  3 | 2020-02-28 09:47:07 |
    18. +----+---------------------+
    19. 3 rows in set (0.00 sec)
    21. obclient> drop table t1;
    22. Query OK, 0 rows affected (0.03 sec)
    24. obclient> show recyclebin\G
    25. *************************** 1. row ***************************
    26.   OBJECT_NAME: __recycle_$_20200102_1585650066255592
    27. ORIGINAL_NAME: t1
    28.          TYPE: TABLE
    29.    CREATETIME: 2020-03-31 18:21:06.255716
    30. 1 row in set (0.03 sec)
    32. obclient> flashback table __recycle_$_20200102_1585650066255592 to before drop rename to t1;
    33. Query OK, 0 rows affected (0.02 sec)
    35. obclient> select * from t1;
    36. +----+---------------------+
    37. | ID | GMT_CREATE          |
    38. +----+---------------------+
    39. |  1 | 2020-02-28 09:47:07 |
    40. |  2 | 2020-02-28 09:47:07 |
    41. |  3 | 2020-02-28 09:47:07 |
    42. +----+---------------------+