跳转到主内容

Oracle 数据库文件的时间点还原失败,并显示错误: Recover succeeded but open RESETLOGS would get error below ORA-01152 : file 1 was not restored from a feeded old backup

Views:
10
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

适用场景

适用于 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'   

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device