RE: Create standby DB non-ASM, non_OMF from Primary ASM and OMF
Date: Thu, 14 Feb 2008 09:34:25 -0500
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.
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
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of neil campbell Sent: Wednesday, February 13, 2008 10:27 PM To: oracle-l_at_freelists.org
Subject: Create standby DB non-ASM, non_OMF from Primary ASM and OMF
I am having a bit of a mental block !
Primary is 10.2.0.3 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
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 CarPoint.com.au http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwi de%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F100 4813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT-- http://www.freelists.org/webpage/oracle-l Received on Thu Feb 14 2008 - 08:34:25 CST