How to set the Undo_tablespace in PDB in Physical Standby RAC Database. (Doc ID 2726173.1)

1. Primary - Make Change in Primary Database in PDB in each Instances:

For e.g

Instance 1 -> alter system set undo_tablespace=PDB1_UNDO_KDRACBKP1 container=current sid='KDRACBKP1' scope=both;

Instance 2 -> alter system set undo_tablespace=PDB1_UNDO_KDRACBKP2 container=current sid='KDRACBKP2' scope=both;

2. Standby - Restart the Standby database to apply the changes.

3. To Check the assigned Undo Tablespace :

select inst_id,con_id,name,value from gv$parameter where name='undo_tablespace' order by 1