We are running on 11gr2 RAC along with Standby database.We will have to change undo_tablespace.Suppose that i am doing below
Current undo tablespace is A
I will create new Undo TBS B
Set the undo_tablespace to B
--AT this point do i need to change it on the standby????
After this i drop undo tbs A..Assuming no transaction is using it
and then create A
and then set undo_tablespace back to A.
WHat is the impact on standby..DO i need to keep switching undo_tablespace..Or should be seamless