Browsed by
Tag: Role Switch

Autonomous Data Guard – the role transition

Autonomous Data Guard – the role transition

The longer Autonomous Data Guard is available, the better it gets and the better it gets, the more questions come up. Some question which hits my mailbox regularly is: This autonomous Data Guard on ADB-S, when you move it to the other side what do we need to change in our connect string. Well, the answer is simple: You do not need to change anything. How does that work? In my earlier post on how to enable Autonomous Data Guard,…

Read More Read More

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: