Data Guard

Oracle Cloud Service – my first outage

By Franck Pachot . We experienced the first planned outage this week-end, so let's see how it is notified and what happens.

You are in Standard Edition One? Don’t worry.

By Franck Pachot . You want the amazing features of Oracle SQL and PL/SQL with minimal cost. Your database is too large for Oracle XE edition, but not big enough to require the cost of Enterprise Edition. You accept to(…)

DataBase Cloud Service performance – Network

By Franck Pachot . In previous posts, I've installed SLOB on the Cloud Services, measured IOPS and(…)

set state=apply-off and datafile consistency

By Franck Pachot . In a standby database (or in any database you recover) do you think the recovery uses buffer cache? And when you stop the apply in a standby database, do you think the datafiles are in a(…)

DataGuard broker properties – Part II: log shipping parameters

By Franck Pachot . In the part I we have seen the properties that are imported when you add a database to the configuration, and which are then managed by the(…)

DataGuard broker properties – Part I: imported parameters

By Franck Pachot . When you are using the DataGuard Broker, you should always use the broker (with DGMGRL or OEM) to change the parameters that are managed, rather than changing them with ALTER SYSTEM. But do you know which(…)

Convert a snapshot standby to a new database

By Franck Pachot . A snapshot standby database is a nice solution when you want a temporary copy of the primary where you can do whatever you want (test a bug fix for example) and then convert it back(…)

Variations on 1M rows insert(2): commit write

By Franck Pachot . In the previous blog post I measured the time it takes to insert 1 million rows. About 45 seconds when done row-by-row which goes down to 7 seconds when inserted in bulk. In both(…)

Cloning a PDB from a standby database

By Franck Pachot . Great events like IOUG Collaborate is a good way to meet experts we know through blogs, twitter,etc. Yesterday evening, with nice music in the background, I was talking with Leighton Nelson about cloning PDB(…)

DataGuard wait events have changed in 12c

By Franck Pachot . There are several new features in 12c about Data Guard: cascaded standby, far sync instance. But there are also some architecture changes: new processes and new wait events. Here is an example of an(…)