-
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
-
Yes
Originally Posted by matthew00
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
-
actually, it should be 20 instead of 24. b/c four log files/per thread plus one and multiply by four.
-
Originally Posted by matthew00
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
-
can any one let me know where this is documented...i want to read more..
-
Originally Posted by Mohith123
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|