RMAN with OMF
447455Aug 6 2009 — edited Aug 6 2009HI ,
Iam using oracle 10.2.0.4 and want to take an rman backup with file conversion option. This is what i used:
convert database
transport script '/home/oracle/transport_FCCEGM.sql'
new database 'FCCEGM'
to platform 'HP-UX (64-bit)'
parallelism 4
format '/home/oracle/fccegm.ora'
db_file_name_convert '/usr/oradata/FCCEGM1/datafile','/usr/oradata/FCCEGM1/rman/';
It complains about my oracle managed file:
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 08/06/2009 13:05:08
ORA-01276: Cannot add file /usr/oradata/FCCEGM1/rman//o1_mf_fcc_data_572ohgtg_.dbf. File has an Oracle Managed Files file name.
My work around is this(remove this part :db_file_name_convert '/usr/oradata/FCCEGM1/datafile','/usr/oradata/FCCEGM1/rman/'; )
so i run this:
convert database
transport script '/home/oracle/transport_FCCEGM.sql'
new database 'FCCEGM'
to platform 'HP-UX (64-bit)'
parallelism 4
format '/home/oracle/fccegm.ora'
It is working but of course the converted file destination is the same as the source. Their is a lot of file.
How can i used Rman backup with oracle managed file and specified the destination?
regards,
F.KABORE