如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com
症状
–问题陈述：
无法使用DBMS_FILE_TRANSFER复制ASM文件。
— 重现步骤：
SQL> create directory backupto as ‘C:\Experteam\Backup\RMAN\Supp’;
新建的目录.
SQL> create directory backupfrom as ‘+RECDISK/TOTALDB/BACKUPSET/2007_07_02’;
新建的目录.
SQL> BEGIN
2 dbms_file_transfer.copy_file
3 (
4 source_directory_object => ‘backupfrom’,
5 source_file_name => ‘nnndf0_BACKUP_TOTALDB_000_0702070200_0.548.62683’,
6 destination_directory_object => ‘backupto’,
7 destination_file_name => ‘nnndf0_BACKUP_TOTALDB_000_0702070200_0.548.62683’
8 );
9 END;
10 /
BEGIN
*
第1行的错误:
ORA-19505: 不能识别文件
“+RECDISK/TOTALDB/BACKUPSET/2007_07_02/nnndf0_BACKUP_TOTALDB_000_0702070200_0.548.62683”
ORA-15173: entry ‘nnndf0_BACKUP_TOTALDB_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/TOTALDB/BACKUPSET/2007_07_02
ASMCMD>
ASMCMD>
ASMCMD> ls
nnndf0_BACKUP_TOTALDB_000_0702070200_0.548.62683
ASMCMD>
ASMCMD>
原因
Bug 6316402 DBMS_FILE_TRANSFER.COPY_FILE CAN NOT IDENTIFY ASM FILE ALTHOUGH IT EXISTS
Bug 6009056 ASMCMD SHOULD BE AWARE OF FULL NAME OF ASM ALIAS NAME
解决方案
对于完整的文件名，我们需要追加file_number||’.’||file_incarnation到file_name。
ASMCMD以及V $ ASM_ALIAS.NAME仅显示文件名称的前48个字符。
例:
SQL> select NAME||’.’||file_number||’.’||file_incarnation
2 from v$asm_alias
3 where name=’annnf0_BACKUP_TOTALDB_000_0808070230_0.620.63003′;
NAME||’.’||FILE_NUMBER||’.’||FILE_INCARNATION
—————————————————————-
annnf0_BACKUP_TOTALDB_000_0808070230_0.620.63003.620.630038277
然后使用包参数中的文件名，如下所示：
annnf0_BACKUP_TOTALDB_000_0808070230_0.620.630038277
参考
BUG:6316402 – DBMS_FILE_TRANSFER.COPY_FILE CAN NOT IDENTIFY ASM FILE ALTHOUGH IT EXISTS
Comment