RE: Create standby DB non-ASM, non_OMF from Primary ASM and OMF
- From: <Scott.Washburn@xxxxxxxxxxxx>
- To: <campbell.neil@xxxxxxxxxxx>
- Date: Thu, 14 Feb 2008 09:34:25 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of neil campbell
Sent: Wednesday, February 13, 2008 10:27 PM
To: oracle-l@xxxxxxxxxxxxx
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--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
