Browsed by
Tag: Role Switch

PDBs and role transitions

PDBs and role transitions

Now, we currently do not have per-PDB role transitions. Nevertheless, it is possible to move one PDB to another CDB. However, what if the other CDB is located at the DR site and you don’t want to copy all the data over the network again? Well, this is possible! For this to work, we need 2 CDB’s. One primary in Site A protected by a Standby CDB in Site B. The second CDB is primary in Site B and protected with…

Read More Read More

Is your PDB state saved?

Is your PDB state saved?

This might save you a couple of minutes if you wonder how multitenant works in combination with Oracle Data Guard. The question I got was, is your PDB state saved after a switchover? The short answer is: Yes it is. No statements without proving them of course, so here we go. The primary database: I have the state of my pub always saved in my post creation script, but you can easily retrieve in what state the PDB will be…

Read More Read More

%d bloggers like this: