Oracle データベースファイルのポイントインタイムリストアが次のエラーで失敗します。 ORA-2737 ： Unable to obtain file status ORA-19600 ： input file is datafile-dcopy-copy

最後の更新
PDFとして保存

Views:: 173

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