You are running a two-node RAC cluster, and each node has one instance that is running. The instances are called RAC01 and RAC02.
The RAC database currently contains only two undo table spaces. Currently, RAC01 is using the undo table space called UNDOTBS1, and RAC02 is using the undo table space called UNDOTBS2.
You issue the following command from the first instance:
ALTER SYSTEM SET UNDO_TABLESPACE=” SID=’RAC02′;
What happens?
A.
RAC02 crashes.
B.
RAC01 and RAC02 crash.
C.
RAC02 uses the SYSTEM rollback segment.
D.
RAC02 uses the system-generated SYS-UNDOTBS undo tablespace.