Browsed by
Tag: dataguard

When does a Fast-Start Failover (FSFO) with the observer happen?

When does a Fast-Start Failover (FSFO) with the observer happen?

Often asked, well documented but a summary is always good. What are the conditions for the Observer to trigger a fast-start Failover and where do we have to place the observers? As with 19c, you might have noticed that there are less white papers published and however a pdf is easy to read, it is difficult to maintain. The world is evolving rapidly and we want to be able to provide the best and most accurate information regarding 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

OTN Appreciation Day: Dataguard

OTN Appreciation Day: Dataguard

Thanks Tim Hall for the idea about OTN Appreciation day. The feature I like the most in oracle is a rather “old” one, but it can be extremely useful: Dataguard. Why dataguard? I find it extremely easy to set it up, maintain it and it can save you a lot of “troubles”. Especially on big(ger) databases it takes down the time to recover in case of a failure down to seconds instead of hours. The concept is simple: (image borrowed from the…

Read More Read More

%d bloggers like this: