Re: Create standby DB non-ASM, non_OMF from Primary ASM and OMF
- From: "Brian MacLean" <bpmaclean.oracle@xxxxxxxxx>
- To: campbell.neil@xxxxxxxxxxx
- Date: Wed, 13 Feb 2008 21:40:34 -0700
I like using the dbms_file_transfer package to build standby databases.
Most of the time for me shipping tapes is not an option. It also works
great for moving things in & out, out & in, and around within ASM.
When you transfer the datafiles give them a non OMF name on the output side
and then do "rename" commands on the standby side.
http://blogs.techrepublic.com.com/datacenter/?p=136
http://www.builderau.com.au/program/oracle/soa/Copy-Oracle-s-Automatic-Storage-Management-files-with-DBMS-FILE-TRANSFER/0,339028441,339280831,00.htm
...and my favorite...
http://www.oracle.com/technology/deploy/availability/pdf/asm_cloning.pdf
On Wed, Feb 13, 2008 at 8:27 PM, neil campbell <campbell.neil@xxxxxxxxxxx>
wrote:
>
> 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%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT--
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
