we have 2 nodes, and one undo tablespace per node. ( undotbs1 , undotbs2 )we have one more undo tablespace for instance2 which is not active( i.e. not set at instance level ) say undotbs3
if undotbs2 in instance2 is full, what will happen ?
the next available active undo tablespace undotbs1 ( in instance1 ) will be used for node 2 ?