|
 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 8 - RAC Administration
Redo Thread Maintenance
ALTER DATABASE ADD LOGFILE THREAD 2
GROUP 4 (‘u01/oracle/redo/file4a’,
‘u02/oracle/redo/file4a’) size 50M,
GROUP 5 (‘u01/oracle/redo/file5a’,
‘u02/oracle/redo/file5a’) size 50M,
GROUP 6 (‘u01/oracle/redo/file6a’,
‘u02/oracle/redo/file6a’) size 50M ;
A thread needs to be enabled before an instance
can use it. While enabling, we can specify whether it is a public or
a private thread. For example,
To enable as a public thread:
ALTER DATABASE ENABLE PUBLIC THREAD 2 ;
To enable as a private thread:
The above text is
an excerpt from:
Oracle 10g Grid & Real Application
Clusters
Oracle 10g
Grid
Computing with RAC
ISBN 0-9744355-4-6
by Mike Ault, Madhu Tumma
|
