This discussion is archived
3 Replies Latest reply: Jan 1, 2013 7:40 AM by CKPT RSS

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

857396 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

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