Cross Platform to ASM Fails on DB_FILE_NAME_CONVERT - Must be completed by tomorrow AM -

From: David Barbour <david.barbour1_at_gmail.com>
Date: Sat, 31 Jan 2015 18:24:08 -0600
Message-ID: <CAFH+ife+Vvda2-dGq=kv8Kd4vMUd6MF5w0gH-MEQpnWtbQKPcA_at_mail.gmail.com>

Stuck.

Source: Oracle 11.2.0.3 HP-UX IA (64-bit) "Cooked Files"

Target: Oracle 11.2.0.3 Linux x86 64-bit ASM

I've copied the source datafiles using rman to a directory on the Linux Server. Now I have an RMAN script to convert the endian and load them into the SM database.

Here's the script (with redundant parts omitted):

RUN
{
CONVERT DATAFILE '/export_tmp/P21_Dump/sr3.data6',

....................................................

'/export_tmp/P21_Dump/sr3.data60'

TO PLATFORM="Linux x86 64-bit"
FROM PLATFORM="HP-UX IA (64-bit)"
DB_FILE_NAME_CONVERT
'/export_tmp/P21_Dump/sr3.data6','+P21DATA01',

.....................................................

'/export_tmp/P21_Dump/sr3.data60','+P21DATA01';
}

exit;

It's failing because it seems to be trying to increment the diskgroup? Here's the log (well, portions of it anyway):

Starting conversion at target at 31-JAN-15 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=807 device type=DISK allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=970 device type=DISK allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1131 device type=DISK allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1292 device type=DISK allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=1451 device type=DISK channel ORA_DISK_1: starting datafile conversion input file name=/export_tmp/P21_Dump/sr3.data5 channel ORA_DISK_2: starting datafile conversion input file name=/export_tmp/P21_Dump/sr3.data29 channel ORA_DISK_3: starting datafile conversion input file name=/export_tmp/P21_Dump/sr3.data50 channel ORA_DISK_4: starting datafile conversion input file name=/export_tmp/P21_Dump/sr3.data49 channel ORA_DISK_5: starting datafile conversion

input file name=/export_tmp/P21_Dump/sr3.data51
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of conversion at target command on ORA_DISK_2 channel at 01/31/2015 18:02:29

ORA-19504: failed to create file "+P21DATA019"
ORA-15001: diskgroup "P21DATA019" does not exist or is not mounted
ORA-15001: diskgroup "P21DATA019" does not exist or is not mounted

Any help? I have to do this tonight.

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Feb 01 2015 - 01:24:08 CET