メインコンテンツまでスキップ
We are redesigning the NetApp Knowledge Base site to make it easier to use and navigate. The new and improved site will be available the first week of October. Check out our video or read this KB article to know more about changes you’ll see on the site.

Oracle データベースファイルのポイントインタイムリストアがエラーで失敗します。 recover は成功しましたが、 ORA-01152 : file 1 was not restored backup

Views:
31
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
dp
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'   

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support