This discussion is archived
3 Replies Latest reply: Nov 22, 2012 4:02 AM by IGorbatovsky RSS

RAW primary database and ASM standby database

Sekar_BLUE4EVER Newbie
Currently Being Moderated
Hi,
I would like to know if it is possible to have a ASM standby database for a primary database which is on RAW files.Is there any changes in procedure for a switchover to DR site.
  • 1. Re: RAW primary database and ASM standby database
    user296828 Expert
    Currently Being Moderated
    ASM standby database for a primary database which is on RAW files.
    I think you can use OMF on both Primary & Standby in order to mange database files.
  • 2. Re: RAW primary database and ASM standby database
    teits Journeyer
    Currently Being Moderated
    Sekar_BLUE4EVER wrote:
    Hi,
    I would like to know if it is possible to have a ASM standby database for a primary database which is on RAW files.Is there any changes in procedure for a switchover to DR site.
    Yes, you can. and there is no change in procedure for switchover.
    for creation of standby DB, consider these parameters: db_create_file_dest,db_recovery_file_dest,control_files

    see an example here: http://pythianpang.wordpress.com/2010/02/18/data-guard-non-asm-primary-to-asm-physical-standby/

    HTH
    Tobi

    Edited by: teits on Nov 20, 2012 12:13 PM
  • 3. Re: RAW primary database and ASM standby database
    IGorbatovsky Newbie
    Currently Being Moderated
    Hi,
    It is possible! We use the same configuration. You don't need to worry about switchover or failover differences. The only thing you should take care of is to specify correct parameters for *.db_file_name_convert, *.log_file_name_convert.
    For example:
    *.log_file_name_convert='/oradata/db','+GR1/stdb/redo'
    *.db_file_name_convert='/backup/oradata','+GR2/stdb/datafile','/oradata/db','+GR1/stdb/datafile'

    Let me know if you need more information about this configuration.

    HTH,
    Regards,
    I. Gorbatovsky

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points