RE: Create standby DB non-ASM, non_OMF from Primary ASM and OMF
Date: Thu, 14 Feb 2008 09:34:25 -0500
Message-ID: <8DFA9236C2B0914FA465AF6FF3F7FE5338511C@wosnpntcmx015.DS.WOLSELEY.COM>
Neil,
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
www.wolseley.com
Wolseley plc registered office
Parkview 1220 Arlington Business Park
Theale Nr Reading Rg7 4GA United Kingdom
Registration No. 29846 England
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[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
Hi
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
+DATADG/datafile/system.259.639693489 to
/u02/ora/datafile/system.259.639693489
When I really want the datafile to be something like
/u02/oradata/stdby/system01.dbf'
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 ?
Cheers
Neil
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 14 2008 - 08:34:25 CST