You decide to change the redo thread of one of your database instances.
Right now, you have three enabled threads of two groups each:
— thread 3 consisting of log groups 5 and 6 is currently being used by instance RAC01
— thread 2 consisting of log groups 3 and 4 is currently being used by instance RAC02
— thread 1 consisting of log groups 1 and 2 is not being used.
In which order should you perform the following commands to remove thread 3 from your database and replace it with thread 1, and remove the redo logs associated with thread 3?
1 srvctl stop instance -d RACDB -i RAC01
2 ALTER DATABASE DISABLE THREAD 3;
3 ALTER DATABASE DROP LOGFILE GROUP 6;
4 srvctl start instance -d RACDB -i RAC01
5 ALTER SYSTEM SET thread=1 SCOPE=SPFILE SID=’RAC01′;
6 ALTER DATABASE DROP LOGFILE GROUP 5;
A.
2, 5, 1, 4, 3, 6
B.
5, 1, 4, 2, 3, 6
C.
3, 6, 5, 1, 4, 2
D.
2, 3, 6, 5, 1, 4