This content has been marked as final. Show 3 replies
I would take a look at this, especially the comments and selects including threads :
Script to Collect Data Guard Physical Standby Diagnostic Information [ID 241438.1]
Equation to determine number of standby redo log file groups :
(max. number of logfiles for each thread + 1) * max. number of threads
Thanks for the quick reply!
Our logs are applying from the primary to the standby, but our question is more of a best practice. Since we originally defined our SRLs with thread 1, would we be better off to recreate them without thread defined.
The white paper "MAA / Data Guard 10g Setup Guide – Creating a RAC Physical Standby for a RAC Primary" has the most information of any in my collection of Oracle Documents.
You can find a copy here :
Jump to pages 9 and 10.