|
 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 8 - RAC Administration
Redo Thread Maintenance
ALTER DATABASE ENABLE PRIVATE THREAD 3 ;
When a thread is enabled as private, you can
use the thread parameter in
the SPFILE (or init.ora) to
associate the instance with a thread. For example, instances
‘racdb1’ and ‘racdb2’ will have thread 1 and 2 respectively.
RACDB1.THREAD=1 # RACDB1 instance uses Thread
1
RACDB2.THREAD=2 # RACDB2 instance uses Thread
2
Now let us look at some examples of how to drop
a group or member.
For dropping an online redo log group, use the
ALTER DATABASE statement with the DROP LOGFILE clause. The following
statement drops redo log group number 3:
ALTER DATABASE DROP LOGFILE GROUP 3;
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
|
