Browsed by
Category: dataguard

Redo apply is slow? Or not really?

Redo apply is slow? Or not really?

A common question that often arrives in my mailbox is that redo apply on an Active Data Guard standby database is significantly slower than on the mounted standby. A famous wise man once said: “If the primary can generate it, the standby can apply it”. I totally agree. If the primary can generate it, the standby can apply it. Larry M. Carpenter Let’s start by assuming that the redo apply best practices have been followed and the synchronous best practices…

Read More Read More

VALID_FOR ONLINE_LOGFILES or VALID_FOR ONLINE_LOGFILE ?

VALID_FOR ONLINE_LOGFILES or VALID_FOR ONLINE_LOGFILE ?

This will be a very short blogpost.It started with an internal question and looking into the documentation, I have noticed that in the VALID_FOR specification for configuration a Log Archive Dest (LAD ), there was some confusion about how you need to specify this. So after a bit of research, Oracle Data Guard accepts these keywords in the VALID_FOR clause:

Take into account, that this might change over time. As always, questions, remarks? find me on twitter @vanpupi

Autonomous Data Guard – First steps

Autonomous Data Guard – First steps

Recently we have announced a new member in the Autonomous family: Autonomous Data Guard. Yes it is really autonomous! All is automatic and it is very easy to use. Here are the first steps on how to use it. The GUI way Create your ADB-S Database. You can do this by clicking the “Create autonomous Database” button. Fill in some basic information Make sure you select a 19c database And of course you will need a good password. For Demo…

Read More Read More

Automatic block media recovery to the rescue

Automatic block media recovery to the rescue

As pointed out earlier, Oracle Active Data Guard (ADG) is a lot more than just the read-only standby database. One of the technologies no other product beats us on in regards to disaster recovery is the automatic block media recovery, which is part of the Active Data Guard license. This gets automatically enabled when you open the standby database read-only with redo apply enabled. You do not need to do something specific for it, it is just there. In spite…

Read More Read More

AWR on ADG

AWR on ADG

Active Data Guard is a lot more than the read-only standby database. Let’s focus on this part a bit. Read-only workloads are select workloads and are just queries. Working on a read-only database where redo apply is running results in a complex mechanism of keeping data up to date and combining it with user queries. From time to time, you can’t help but question the performance of the queries or how the overall standby database is performing. What could possibly…

Read More Read More

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

Connectstrings in the OCI

Connectstrings in the OCI

Under the category; asked and answered. When you have created a Data Guard config, the most obvious is that you eventually would like to connect to the Database. This is done using a connect string, often specified in tnsnames.ora or via jdbc-thin. When you read this blog post, then you end up with a Primary and Standby database. One of the questions I got last week “How can we add 2 service names in the same connect string”? I was…

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

%d bloggers like this: