Browsed by
Month: November 2020

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

%d bloggers like this: