ORA-15173 When Trying to Copy ASM File Using DBMS_FILE_TRANSFER
(Doc ID 453913.1)
Last updated on MARCH 23, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
-- Problem Statement:
Unable to copy ASM file using DBMS_FILE_TRANSFER.
-- Steps To Reproduce:
SQL> create directory backupto as 'C:\Experteam\Backup\RMAN\Supp';
Directory created.
SQL> create directory backupfrom as '+RECDISK/TEST/BACKUPSET/2007_07_02';
Directory created.
SQL> BEGIN
2 dbms_file_transfer.copy_file
3 (
4 source_directory_object => 'backupfrom',
5 source_file_name => 'nnndf0_BACKUP_TEST_000_0702070200_0.548.62683',
6 destination_directory_object => 'backupto',
7 destination_file_name => 'nnndf0_BACKUP_TEST_000_0702070200_0.548.62683'
8 );
9 END;
10 /
BEGIN
*
ERROR at line 1:
ORA-19505: failed to identify file
"+RECDISK/TOTALDB/BACKUPSET/2007_07_02/nnndf0_BACKUP_TEST_000_0702070200_0.548.62683"
ORA-15173: entry 'nnndf0_BACKUP_TEST_000_0702070200_0.548.62683' does not
exist in directory '2007_07_02'
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 84
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 193
ORA-06512: at line 2
ASMCMD
ASMCMD> pwd
+RECDISK/TEST/BACKUPSET/2007_07_02
ASMCMD>
ASMCMD>
ASMCMD> ls
nnndf0_BACKUP_TEST_000_0702070200_0.548.62683
ASMCMD>
ASMCMD>
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |