Someone asked me this question recently.<\/p>\n
The answer is: yes!<\/strong><\/p>\n Let’s see it in action.<\/p>\n On the primary I have:<\/p>\n And of course the same PDBs on the standby:<\/p>\n Let’s change the PDB RED name to TOBY: The PDB rename operation is straightforward (but it requires a brief downtime). To be done on the primary:<\/p>\n On the standby, I can see that the PDB changed its name:<\/p>\n The PDB name change is propagated transparently with the redo apply.<\/p>\n —<\/p>\n Ludo<\/p>\n","protected":false},"excerpt":{"rendered":" Someone asked me this question recently. The answer is: yes! Let’s see it in action. On the primary I have: —– PRIMARY SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 … Continue reading ----- PRIMARY\r\nSQL> show pdbs;\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED READ ONLY NO\r\n 3 RED READ WRITE NO\r\n 4 SAND READ WRITE NO<\/pre>\n
----- STANDBY\r\nSQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED MOUNTED\r\n 3 RED MOUNTED\r\n 4 SAND MOUNTED<\/pre>\n
SQL> alter pluggable database red close;\r\n\r\nPluggable database altered.\r\n\r\nSQL> alter pluggable database red open restricted;\r\n\r\nPluggable database altered.\r\n\r\nSQL> alter session set container=red;\r\n\r\nSession altered.\r\n\r\nSQL> alter pluggable database rename global_name to toby;\r\n\r\nPluggable database altered.\r\n\r\nSQL> alter session set container=cdb$root;\r\n\r\nSession altered.\r\n\r\nSQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED READ ONLY NO\r\n 3 TOBY READ WRITE YES\r\n 4 SAND READ WRITE NO\r\n\r\nSQL> alter pluggable database toby close;\r\n\r\nPluggable database altered.\r\n\r\n\r\nSQL> alter pluggable database toby open;\r\n\r\nPluggable database altered.\r\n\r\nSQL><\/pre>\n
SQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED MOUNTED\r\n 3 TOBY MOUNTED\r\n 4 SAND MOUNTED\r\nSQL><\/pre>\n