万里数据库GreatDB数据恢复-4

任意时间点恢复

使用以上步骤，可以恢复到最后一次备份任务结束时刻（假设该时刻为T1）数据库的数据。如果再结合binlog，可以恢复数据库历史中的特定时刻的数据，但是这个时刻一定要大于T1。恢复步骤如下:

(1)连接恢复后的数据库实例查询当前数据库已经执行的事务

greatdb> select *from clone_status;
+------+------+-----------+-------------------------+-------------------------+----------------+----------------+----------+---------------+---------------+-----------------+---------------------------------------------+-----------+----------------+----------+
| ID   | PID  | STATE     | BEGIN_TIME              | END_TIME                | SOURCE         | DESTINATION    | ERROR_NO | ERROR_MESSAGE | BINLOG_FILE   | BINLOG_POSITION | GTID_EXECUTED                               | START_LSN | PAGE_TRACK_LSN | END_LSN  |
+------+------+-----------+-------------------------+-------------------------+----------------+----------------+----------+---------------+---------------+-----------------+---------------------------------------------+-----------+----------------+----------+
|    1 |    0 | Completed | 2023-08-02 17:00:03.516 | 2023-08-02 17:26:47.914 | LOCAL INSTANCE | LOCAL INSTANCE |        0 |               | binlog.000001 |       795495446 | 69da86c5-3112-11ee-8b91-2cf05daaf60d:1-1590 |         0 |              0 |        0 |
+------+------+-----------+-------------------------+-------------------------+----------------+----------------+----------+---------------+---------------+-----------------+---------------------------------------------+-----------+----------------+----------+

则恢复到指定时间点的起始文件是binlog.000001,位置为795495446

(3)通过查询文件，确定哪个位置或日期对应于所需的时间点。假设时间是：23-08-02 01:00:00，对应分文件是binlog.000002

(4)通过如下命令恢复到该时刻：

$ greatdbbinlog ./binlog.000001 ./binlog.000002 --start-position=795495446 --stop-datetime="23-08-02 01:00:00" | mysql -u root -p