Browsed by
Tag: Data Guard

OCI cli – tooling made easy

OCI cli – tooling made easy

The OCI tool is easy to use. I had a very interesting conversation with Simon Haslam ( here on Twitter @simon_haslam ) about this. In this blogpost we will highlight the cause (and the solution) of this particular case and in a second part, there is a general workflow which did not let me down for my last deployments. 404 NotAuthorizedOrNotFound Simon and his colleagues are working with ansible and Terraform for automatic provisioning of their full environment which at…

Read More Read More

DBMS_ROLLING explained

DBMS_ROLLING explained

Active Data Guard is more than just the Read-Only Standby database. Together with your Active Data Guard license comes the “Rolling Upgrade using Active Data Guard” Feature, better known as DBMS_ROLLING. If you search this blog for Transient logical standby, you can find it here. But DBMS_ROLLING is way easier. The principle remains the same: Create the guaranteed restore point Build the logminer dictionary Convert the physical standby to a logical standby Upgrade the logical standby Start the apply again…

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

To CDB or not to CDB, that’s the question

To CDB or not to CDB, that’s the question

A product manager has several parts on the job. You can do outbound PM, that is what you, the readers or public, see. But we have also an inbound task. One of the things we do is answer internal questions and advise on how to use the product. This question is coming from a colleague who is doing an upgrade at a customer and facing some strange things with the move from non-cdb towards a cdb. On My Oracle Support…

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: