达梦备份恢复利用归档恢复到指定时间点

一、起因
数据被删除，
二、备份策略，每周全备，每天增倍+归档日志

三、恢复
3.1 完全恢复至昨日备份时刻
RMAN> restore database '/data/dmdata/CQGYJJXT/dm.ini' from backupset '/data/dmdata/dmbak/DB_CQGYJJXT_INCREMENT_2021_12_07_23_30_56'
restore database '/data/dmdata/CQGYJJXT/dm.ini' from backupset '/data/dmdata/dmbak/DB_CQGYJJXT_INCREMENT_2021_12_07_23_30_56'
[Percent:0.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]                                   
[Percent:0.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]Normal of FAST                     
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:99.98%][Speed:0.00M/s][Cost:00:00:49][Remaining:00:00:00]                                  
restore successfully.
time used: 00:00:49.888
3.2 应用备份过程中产生的日志
RMAN> RMAN> recover database '/data/dmdata/CQGYJJXT/dm.ini' from backupset '/data/dmdata/dmbak/DB_CQGYJJXT_INCREMENT_2021_12_07_23_30_56'
recover database '/data/dmdata/CQGYJJXT/dm.ini' from backupset '/data/dmdata/dmbak/DB_CQGYJJXT_INCREMENT_2021_12_07_23_30_56'

Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[6191786], file_lsn[6191786]
EP:0 total 8 pkgs applied, percent: 10%
EP:0 total 16 pkgs applied, percent: 20%
EP:0 total 24 pkgs applied, per