3 Replies Latest reply: Jan 1, 2013 9:40 AM by CKPT RSS

    How to create a standby redolog from rac to non rac ??

    857396
      Hi,

      How to create a standby redolog from rac to non rac DR setup..???

      in rac we can create with specifying thread number for each instances..... but this will be replicating to standby ....so how this will act/create on single DR??
      pls help
        • 1. Re: How to create a standby redolog from rac to non rac ??
          Shivananda Rao
          Hello,

          Take a look at these links

          http://www.oracle.com/technetwork/database/features/availability/maa-wp-10g-racprimarysingleinstance-131970.pdf
          http://oracleinstance.blogspot.com/2012/01/create-single-instance-standby-database.html


          Regards,
          Shivananda
          • 2. Re: How to create a standby redolog from rac to non rac ??
            857396
            Thanks Shivanandha,
            (maximum number of logfiles for each thread + 1) * maximum number of threads

            Using this equation reduces the likelihood that the primary instance's log writer (LGWR) process will be blocked because a standby redo log file cannot be allocated on the standby database. For example, if the primary database has 2 log files for each thread and 2 threads, then 6 standby redo log file groups are needed on the standby database.
            • 3. Re: How to create a standby redolog from rac to non rac ??
              CKPT
              854393 wrote:
              Thanks Shivanandha,
              (maximum number of logfiles for each thread + 1) * maximum number of threads

              Using this equation reduces the likelihood that the primary instance's log writer (LGWR) process will be blocked because a standby redo log file cannot be allocated on the standby database. For example, if the primary database has 2 log files for each thread and 2 threads, then 6 standby redo log file groups are needed on the standby database.
              In maximum performance mode you can keep same number of redo logs but having one more redo log member for each thread is recommended and mandtory for other protection modes.

              How to create a standby redolog from rac to non rac DR setup..???
              in rac we can create with specifying thread number for each instances..... but this will be replicating to standby ....so how this will act/create on single DR??
              pls help

              Yes, even your DR is RAC or non-RAC, you must have both threads, because each instance information exist on own thread, So to perform redo transition from both the instances, you must have both standby redo log threads even though if it is non an RAC DR.
              Hope This helps.