Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Need Help with "convert database on target platform"

Sky13Jan 26 2011 — edited Feb 1 2011
We are moveing a 10.2.0.4 database from Windows 32Bit to Linux 64bit. I am going to use the RMAN Convert Database functionality and do the convertion on the target server (Linux). I am having some problems understning the paramaters passed into RMAN for the Convert Database comand.

This is what I am using:
convert database on target platform
convert script 'E:\Oracle\TDB\convert_db.rman'
transport script 'E:\Oracle\TDB\transport_db.sql'
new database 'EBS01PD'
db_file_name_convert '/blackdb/Oracle/oradata/EBIZBLK','/u01/oradata/EBS01PD';

The taget (Linux) server has the source (Windows) servers drive mounted and the datafile are at this path: '/blackdb/Oracle/oradata/EBIZBLK'. I want them to endup in '/u01/oradata/EBS01PD' with the same filenames.

However the CONVERT_DB.RMAN script is assging a FORMAT that I can not seem to control:
CONVERT DATAFILE 'E:\ORACLE\ORADATA\EBIZBLK\APPS_TS_TX_DATA04.DBF'
FROM PLATFORM 'Microsoft Windows IA (32-bit)'
FORMAT 'E:\ORACLE\PRODUCT\10.2.0\DATABASE\DATA_D-EBIZBLK_I-226164864_TS-APPS_TS_TX_DATA_FNO-407_H6M32P82';

I have added this format line to me RMAN script but it failes with this error:

format '/u01/oradata/EBS01PD'

channel ORA_DISK_1: starting to check datafiles
input datafile fno=00047 name=E:\ORACLE\ORADATA\EBIZBLK\INTERIM.DBF
channel ORA_DISK_1: datafile checking complete, elapsed time: 00:00:00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/26/2011 10:18:32
ORA-09210: sftopn: error opening file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 1 2011
Added on Jan 26 2011
#performance-availability, #recovery-manager-rman
4 comments
473 views