注册

无法恢复到指定时间点

Zhi&Jian 2022/04/10 1138 10

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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)
回答 0
暂无回答
扫一扫
联系客服