This discussion is archived
2 Replies Latest reply: Mar 22, 2013 8:49 AM by mseberg RSS

Few Standby questions

995615 Newbie
Currently Being Moderated
Hello,

1) Should a dedicated network be used for the redo shipping?

2) On the create standby, how many parameters are mandatory?

3) What is the purpose of standby Control file?

Thanks
  • 1. Re: Few Standby questions
    FreddieEssex Pro
    Currently Being Moderated
    1) Typically no. However if your network is busy you may experience some latency with some knock on effects to your data guard environment.

    2) The following link explains this: http://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ps.htm#i68626

    3) The standby controlfile identifies the database as a standby database and not a primary database. So you could put a standby into managed recovery mode and not the primary. From the link above "You cannot use a single control file for both the primary and standby databases."
  • 2. Re: Few Standby questions
    mseberg Guru
    Currently Being Moderated
    Hello;
    1) Should a dedicated network be used for the redo shipping?
    It's not common but if you have either a business need or a network requirement it can be done.
    2) On the create standby, how many parameters are mandatory?
    Not many. For Oracle 10 for example these are common, but not all all required.


    FAL_SERVER
    FAL_CLIENT
    STANDBY_FILE_MANAGEMENT
    DB_FILE_NAME_CONVERT
    LOG_FILE_NAME_CONVERT
    LOG_ARCHIVE_DEST_1
    LOG_ARCHIVE_DEST_2
    LOG_ARCHIVE_DEST_STATE_1
    LOG_ARCHIVE_DEST_STATE_2
    LOG_ARCHIVE_MAX_PROCESSES
    Several default just fine. But DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT are only required if the directory
    structure is different or the standby is on the same server as the primary ( heaven forbid ).


    3) What is the purpose of standby Control file? 
    I like Freddie's answer


    Best Regards

    mseberg

Legend

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