RE: Create standby DB non-ASM, non_OMF from Primary ASM and OMF

From: <>
Date: Thu, 14 Feb 2008 09:34:25 -0500
Message-ID: <8DFA9236C2B0914FA465AF6FF3F7FE5338511C@wosnpntcmx015.DS.WOLSELEY.COM>


You could try using the DBMS_FILE_TRANSFER utility which provides a way to copy files between two different servers. I believe this is the utility ASM uses to instantiate an ASM Data Guard database. In 10g release 2 there is a way to transfer files from ASM to an OS file with the DBMS_FILE_TRANSFER utility. This is the only way that I know is available besides RMAN to move database files into and out of ASM.

Scott Washburn  

Oracle Database Administrator
Wolseley North America Division
Wolseley plc registered office
Parkview 1220 Arlington Business Park
Theale Nr Reading Rg7 4GA United Kingdom Registration No. 29846 England        

-----Original Message-----
[] On Behalf Of neil campbell Sent: Wednesday, February 13, 2008 10:27 PM To:
Subject: Create standby DB non-ASM, non_OMF from Primary ASM and OMF


I am having a bit of a mental block !

Primary is on ASM and using OMF, i want to create a standby that does not use ASM and OMF, and i'm (trying to) use RMAN DUPLICATE

When creating the standby, I dont think I can use DB_FILE_NAME_CONVERT as in :- DB_FILE_NAME_CONVERT = '+DATADG', '/u02'

The result would be a filename being converted from something like +DATADG/datafile/system.259.639693489 to

When I really want the datafile to be something like

I could during the RMAN duplicate, use a run block to run SET NEWNAME, which would rename each of the datafiles to the format I want, but then, what would happen when a new file is added to the primary, how would that be propagated to the standby ?

Is there a way around this, or do i have to go from OMF to OMF ?



It's simple! Sell your car for just $30 at de%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F100 4813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT--
Received on Thu Feb 14 2008 - 08:34:25 CST

Original text of this message