which three orders could you perform the following commands to add thread 3 to your database, and ensure that instance RAC01 is using thread 3?

You decide to change the redo thread of one of your database instances.
Now you have only two threads: thread 1 is currently being used by instance RAC01, and thread 2
is currently being used by instance RAC02.

In which three orders could you perform the following commands to add thread 3 to your
database, and ensure that instance RAC01 is using thread 3? (Choose three acceptable orders.
1 srvctl stop instance -d RACDB -i RAC01
2 ALTER DATABASE ENABLE THREAD 3;
3 ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 6;
4 srvctl start instance -d RACDB -i RAC01
5 ALTER SYSTEM SETthread=3 SCOPE=SPFILE SID=’RAC01′;
6 ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 5;

You decide to change the redo thread of one of your database instances.
Now you have only two threads: thread 1 is currently being used by instance RAC01, and thread 2
is currently being used by instance RAC02.

In which three orders could you perform the following commands to add thread 3 to your
database, and ensure that instance RAC01 is using thread 3? (Choose three acceptable orders.
1 srvctl stop instance -d RACDB -i RAC01
2 ALTER DATABASE ENABLE THREAD 3;
3 ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 6;
4 srvctl start instance -d RACDB -i RAC01
5 ALTER SYSTEM SETthread=3 SCOPE=SPFILE SID=’RAC01′;
6 ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 5;

A.
6,3,2, 5,1

B.
6,3,5, 2,1

C.
3,6,5, 2,1

D.
2,6,3, 5,1

E.
2,5,1, 4,6

F.
2,5,1, 4,3



Leave a Reply 0

Your email address will not be published. Required fields are marked *