Data Guard

Standard Edition on Oracle Database Appliance

By Franck Pachot . The Oracle Database Appliance is really interresting for small enterprises. It’s very good hardware for very good price. It’s capacity on demand licensing for Enteprise Edition. But small companies usually go to Standard Edition for(…)

Oracle 12c: Can we disable logging for DML?

By Franck Pachot . If we don’t mind about loosing our changes, then can we disable logging for DML? This is a question I’ve heard a lot. Ok, you don’t need to recover your changes but Oracle may want(…)

What’s the consequence of NOLOGGING loads?

By Franck Pachot . When you load data in direct-path and have the NOLOGGING attribute set, you minimize redo generation, but you take the risk, in case of media recovery, to loose the data in the blocks that you’ve(…)

Beyond In-Memory, what’s new in 12.1.0.2 ?

By Franck Pachot . It’s just a patchset. The delivery that is there to stabilize a release with all the bug fixes. But it comes with a lot of new features as well. And not only the one that(…)

Drilling down V$RECOVERY_AREA_USAGE

By Franck Pachot . In a previous post I used X$KCCAGF to get more information about reclaimable archived logs in FRA, because there is a bug in standby (not opened) databases where archivelog deletion policy is ignored. I(…)

Archivelog deletion policy for Standby Database in Oracle Data Guard

By Franck Pachot . Do you use ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY for your Oracle databases in Data Guard? Maybe you also use the Fast Recovery Area as archive log destination. That’s good practice! But did(…)

“ORA-01665: control file is not a standby control file”: what can I do?

You have certainly also received this error once in you Oracle DBA career: “ORA-01665: control file is not a standby control file” while trying to create a standby database with RMAN through a full database backup. In fact, the feature(…)