Oracle 数据库文件的时间点还原失败,并显示错误: Recover succeeded but open RESETLOGS would get error below ORA-01152 : file 1 was not restored from a feeded old backup
适用场景
适用于 Oracle 数据库的 SnapCenter 插件 4.4
问题描述
Oracle 数据库的时间点还原失败,并显示以下错误:
Activity 'Oracle Point In Time Recovery' failed with error:
PL-SCO-25000: Oracle Point In Time Restore of database files failed with
error: com.netapp.oracle.core.platform.rman.RmanException:
ORACLE-00101: Error executing RMAN command:
[recover tablespace TESTTS0,TESTTS1 until time "to_date('04-Jun-2020 03:48:51','DD-MON-YYYY HH24:MI:SS')" auxiliary destination '/mnt/rmanpitrdest' ;].
The command returned: ORA-01547:
warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/mnt/rmanpitrdest/TSPITRDB/datafile/o1_mf_system_hfknnxn2_.dbf'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/04/2020 06:54:05
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: Oracle error from auxiliary database:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/mnt/rmanpitrdest/TSPITRDB/datafile/o1_mf_system_hfknnxn2_.dbf'