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