Point-in-time restore of Oracle database files fail with error: ORA-27037: unable to obtain file status ORA-19600: input file is datafile-copy
Applies to
SnapCenter Plug-in 4.4 for Oracle database
Issue
- Point-in-time restore of Oracle database fails with the following error:
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