DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Determine the appropriate number of standby redo log file groups.

  1. #1
    Join Date
    Mar 2006
    Posts
    176

    Determine the appropriate number of standby redo log file groups.

    I read the Oracle docs and below is what Oracle recommended:

    (maximum number of logfiles for each thread + 1) * maximum number of threads

    Below is what I had on my primary:

    select a.group#,b.thread# from v$logfile a, v$log b
    where a.group#=b.group#
    order by 1

    GROUP# THREAD#
    1 1
    1 1
    2 1
    2 1
    3 2
    3 2
    4 2
    4 2
    5 3
    5 3
    6 3
    6 3
    7 4
    7 4
    8 4
    8 4
    9 5
    9 5
    10 5
    10 5


    Based from the formula and what I had on my primary, is it right to say I would need the total of 24 SRL?

    (5+1)*4 --five log files for each thread plus one and multiply 4?

    thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool Yes

    Quote Originally Posted by matthew00 View Post
    I read the Oracle docs and below is what Oracle recommended:

    (maximum number of logfiles for each thread + 1) * maximum number of threads

    Below is what I had on my primary:

    select a.group#,b.thread# from v$logfile a, v$log b
    where a.group#=b.group#
    order by 1

    GROUP# THREAD#
    1 1
    1 1
    2 1
    2 1
    3 2
    3 2
    4 2
    4 2
    5 3
    5 3
    6 3
    6 3
    7 4
    7 4
    8 4
    8 4
    9 5
    9 5
    10 5
    10 5


    Based from the formula and what I had on my primary, is it right to say I would need the total of 24 SRL?

    (5+1)*4 --five log files for each thread plus one and multiply 4?

    thanks
    Correct.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Mar 2006
    Posts
    176
    actually, it should be 20 instead of 24. b/c four log files/per thread plus one and multiply by four.

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking

    Quote Originally Posted by matthew00 View Post
    actually, it should be 20 instead of 24. b/c four log files/per thread plus one and multiply by four.
    Seems your first post is confusing because of the duplicate entries in your query.

    For example, if you have 5 threads of 2 logs each (or 10 logs), you need an equal number of standby threads (or 10 logs) plus one additional thread ( 2 logs)

    10 regular + 12 standby.

    Ooops, that makes 22...
    Last edited by LKBrwn_DBA; 10-25-2010 at 02:17 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    can any one let me know where this is documented...i want to read more..

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by Mohith123 View Post
    can any one let me know where this is documented...i want to read more..
    Nothing beats the vendor's documentation, isn't it?

    Oracle® Data Guard Concepts and Administration
    10g Release 2 (10.2)
    Part Number B14239-05

    Check online at: http://download.oracle.com/docs/cd/B.../create_ps.htm
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width