OceanBase FLASHBACK DATABASE

描述

用于從回收站中恢復(fù)被刪除的 DATABASE。

前置條件

回收站需要處于開啟狀態(tài)，可以通過

?show variables like 'recyclebin';?

來查看回收站是否開啟。

OceanBase(admin@test)> show variables like 'recyclebin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| recyclebin    | ON    |
+---------------+-------+
1 row in set (0.00 sec)

果回收站處于關(guān)閉狀態(tài)，可以通過

?set recyclebin = on;?

來開啟?；厥照局械谋頉]有被實(shí)際刪除，仍然會(huì)占用資源，如果需要徹底刪除，可以執(zhí)行

?purge recyclebin;?

格式

 FLASHBACK DATABASE object_name TO BEFORE DROP [RENAME TO db_name];

參數(shù)解釋

示例

• 從回收站中恢復(fù)刪除的 DATABASE。

OceanBase(admin@test)> create database da;
Query OK, 1 row affected (0.03 sec)

OceanBase(admin@test)> drop database da;
Query OK, 0 rows affected (0.04 sec)

OceanBase(admin@test)> show recyclebin;
+--------------------------------------------------+---------------+----------+----------------------------+
| OBJECT_NAME                                      | ORIGINAL_NAME | TYPE     | CREATETIME                 |
+--------------------------------------------------+---------------+----------+----------------------------+
| __recycle_$_1_1099511628829_18446744073709551615 | da            | DATABASE | 2017-10-20 17:36:15.838771 |
+--------------------------------------------------+---------------+----------+----------------------------+
1 row in set (0.02 sec)

OceanBase(admin@test)> flashback database __recycle_$_1_1099511628829_18446744073709551615 to before drop;
Query OK, 0 rows affected (0.03 sec)