为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: V8 0x7000b
【操作系统】:centos 7.7
【CPU】: Intel
【问题描述】*: 无法恢复到指定时间点,报恢复操作未完成
根据官方示例操作如下
SQL> CREATE TABLE TAB_FOR_RECOVER_01(C1 INT);
INSERT INTO TAB_FOR_RECOVER_01 VALUES(1);
COMMIT;操作已执行
已用时间: 30.043(毫秒). 执行号:600.
SQL> 影响行数 1
已用时间: 1.145(毫秒). 执行号:601.
SQL>
操作已执行
已用时间: 15.056(毫秒). 执行号:602.
SQL>
SQL> BACKUP DATABASE BACKUPSET '/data/dameng/BAK/db_full_bak_for_time_lsn';
操作已执行
已用时间: 00:00:40.853. 执行号:604.
SQL> CREATE TABLE TAB_FOR_RECOVER_02(C1 INT);
INSERT INTO TAB_FOR_RECOVER_02 VALUES(1);
COMMIT;操作已执行
已用时间: 34.499(毫秒). 执行号:605.
SQL> 影响行数 1
已用时间: 0.797(毫秒). 执行号:606.
SQL>
操作已执行
已用时间: 13.488(毫秒). 执行号:607.
SQL> SELECT SYSDATE;
行号 SYSDATE
---------- -------------------
1 2022-04-10 04:48:09
已用时间: 1.423(毫秒). 执行号:608.
SQL> SELECT FILE_LSN FROM V$RLOG;
行号 FILE_LSN
---------- --------------------
1 21725047
已用时间: 1.648(毫秒). 执行号:609.
SQL> DELETE FROM TAB_FOR_RECOVER_01;
COMMIT;影响行数 1
已用时间: 0.897(毫秒). 执行号:610.
SQL> exit;
根据官方示例恢复如下:
# ./dmrman
dmrman V8
RMAN> RESTORE DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/data/dameng/BAK/db_full_bak_for_time_lsn';
RESTORE DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' FROM BACKUPSET '/data/dameng/BAK/db_full_bak_for_time_lsn';
[Percent:100.00%][Speed:0.00M/s][Cost:00:02:38][Remaining:00:00:00]
restore successfully.
time used: 00:02:38.767
RMAN> RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' WITH ARCHIVEDIR '/data/dameng/BAK/db_full_bak_for_time_lsn' UNTIL TIME '2022-04-10 04:48:09';
RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' WITH ARCHIVEDIR '/data/dameng/BAK/db_full_bak_for_time_lsn' UNTIL TIME '2022-04-10 04:48:09';
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[21724958]
[611]:恢复操作未完成
RMAN> RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' WITH ARCHIVEDIR '/data/dameng/BAK/db_full_bak_for_time_lsn' UNTIL LSN 21725047;
RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' WITH ARCHIVEDIR '/data/dameng/BAK/db_full_bak_for_time_lsn' UNTIL LSN 21725047;
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[21724958]
[611]:恢复操作未完成
RMAN> RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' UPDATE DB_MAGIC;
RECOVER DATABASE '/opt/dmdbms/data/DAMENG/dm.ini' UPDATE DB_MAGIC;
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[21724958]
[-8308]:需要先执行RECOVER DATABASE操作,再执行RECOVER DATABASE UPDATE DB_MAGIC操作
RMAN> exit
time used: 0.031(ms)
1、这个是需要指定归档目录:
2、可以在仔细看看这个:https://eco.dameng.com/docs/zh-cn/ops/restore-specified-time.html
1、确保你的归档是开启的;
2、WITH ARCHIVEDIR,指定具体的归档目录,而不是你的备份集目录。