2 Replies Latest reply: Mar 22, 2013 10:49 AM by mseberg RSS

    Few Standby questions

    995615
      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
          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
            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