ORA-17501 Error Running Cross Platform Migration Using XTT and DBMS_TRANSFER
(Doc ID 2015883.1)
Last updated on AUGUST 27, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Cross Platform Transportable Tablespaces(XTTS) method for Database migration using document <Note 1389592.1> fails during a datafile copy using DBMS_FILE_TRANSFER option with below error.
- The document is applicable only when dbms_file_transfer is used during prepare phase.
- During the Phase 2 - Prepare Phase using dbms_file_transfer transfer of few files might fail with
BEGIN
*
ERROR at line 1:
ORA-19504: failed to create file
"+<diskgroup>/<db_unique_name>/datafile//DATA_REF_CRM_00.dbf"
ORA-17502: ksfdcre:1 Failed to create file
+<diskgroup>/<db_unique_name>/datafile//DATA_REF_CRM_00.dbf
ORA-17501: logical block size 4281401344 is invalid
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 37
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 132
ORA-06512: at line 2
*
ERROR at line 1:
ORA-19504: failed to create file
"+<diskgroup>/<db_unique_name>/datafile//DATA_REF_CRM_00.dbf"
ORA-17502: ksfdcre:1 Failed to create file
+<diskgroup>/<db_unique_name>/datafile//DATA_REF_CRM_00.dbf
ORA-17501: logical block size 4281401344 is invalid
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 37
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 132
ORA-06512: at line 2
Or
ERROR at line 1:
ORA-19504: failed to create file "/<path>/user_05.dbf"
ORA-27035: logical block size is invalid
Additional information: -125878784
Additional information: 1
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 37
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 132
ORA-06512: at line 2
ORA-19504: failed to create file "/<path>/user_05.dbf"
ORA-27035: logical block size is invalid
Additional information: -125878784
Additional information: 1
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 37
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 132
ORA-06512: at line 2
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 |
| Cause |
| Solution |
| References |