Oracle 数据库文件的时间点还原失败，并显示错误： ora-27037 ：无法获取文件状态 ORA-19600 ：输入文件为 datafile-copy

最后更新
另存为PDF

Views:: 114

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:

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 TS44073 until time "to_date('17-Jun-2020 12:43:51','DD-MON-YYYY HH24:MI:SS')" auxiliary destination '/mnt/rmanpitrdest' ;].

The command returned: ORA-19505: failed to identify file "/var/opt/snapcenter/sco/backup_mount/FullBackupCatalogPolicy25058_06-17-2020_10.52.00.0109_0/PITNASDB/1/PITNASDB/system01.dbf"

ORA-27037: unable to obtain file status ORA-19600: input file is datafile-copy 92 (/var/opt/snapcenter/sco/backup_mount/FullBackupCatalogPolicy25058_06-17-2020_10.52.00.0109_0/PITNASDB/1/PITNASDB/system01.dbf

ORA-19505: failed to identify file "/var/opt/snapcenter/sco/backup_mount/FullBackupCatalogPolicy25058_06-17-2020_10.52.00.0109_0/PITNASDB/1/PITNASDB/undotbs01.dbf"

ORA-27037: unable to obtain file status ORA-19600: input file is datafile-copy 91 (/var/opt/snapcenter/sco/backup_mount/FullBackupCatalogPolicy25058_06-17-2020_10.52.00.0109_0/PITNASDB/1/PITNASDB/undotbs01.dbf

ORA-19505: failed to identify file "/var/opt/snapcenter/sco/backup_mount/FullBackupCatalogPolicy25058_06-17-2020_10.52.00.0109_0/PITNASDB/1/PITNASDB/sysaux01.dbf"

ORA-27037: unable to obtain file status ORA-19600: input file is datafile-copy 89 (/var/opt/snapcenter/sco/backup_mount/FullBackupCatalogPolicy25058_06-17-2020_10.52.00.0109_0/PITNASDB/1/PITNASDB/sysaux01.dbf

ORA-19505: failed to identify file "/var/opt/snapcenter/sco/backup_mount/FullBackupCatalogPolicy25058_06-17-2020_10.47.14.2921_0/PITNASDB/1/PITNASDB/system01.dbf"

ORA-27037: unable to obtain file status ORA-19600: input file is datafile-copy 86 (/var/opt/snapcenter/sco/backup_mount/FullBackupCatalogPolicy25058_06-17-2020_10.47.14.2921_0/PITNASDB/1/PITNASDB/system01.dbf

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 06/17/2020 12:48:28

RMAN-03015: error occurred in stored script Memory Script

RMAN-06026: some targets not found - aborting restore

RMAN-06023: no backup or copy of datafile 2 found to restore

RMAN-06023: no backup or copy of datafile 3 found to restore

RMAN-06023: no backup or copy of datafile 1 found to restore