Oracle Team

Dataguard Oracle 12.2 : Support for Multiple Automatic Failover Targets

By Mouhamadou Diaw In a previous blog, we talked about Fast-Start Failover with the MaxProtection mode. With Oracle 12.2 Oracle Data Guard now supports multiple failover targets in a fast-start failover configuration. Previous functionality allowed(…)

Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups

By William Sescu Temporary Tablespaces Groups exist for quite a while now (since 10gR2), but they are, for whatever reason not so often used. Personally, I think they are quite cool. Very easy to setup, and especially in big environments(…)

Dataguard Oracle 12.2 : Fast-Start Failover with Maximum Protection

By Mouhamadou Diaw With Oracle 12.1 the one requirement to configure Fast-start Failover is to ensure the broker configuration is operating in either Maximum Availability mode or Maximum Performance mode. With 12.2 Fast-Start Failover can be now configured with(…)

Oracle Database 12c Release 2 Multitenant (Oracle Press)

By Franck Pachot . Here it is. The multitenant book is out for sale...

Oracle 12cR2 – Is the SYSDG Administrative Privilege enough for doing Oracle Data Guard Operations?

By William Sescu For security reasons, you may want that your DataGuard operations are done with a different UNIX user and with a different Oracle user which is not so highly privileged like the SYSDBA.  This is exactly where the(…)

Oracle 12cR2 – DataGuard and the REDO_TRANSPORT_USER

By William Sescu In a DataGuard environment, by default, the password of the SYS user is used to authenticate redo transport sessions when a password file is used. But for security reasons you might not want to use such a(…)

Upgrade to Enterprise Manager 13.2

I will describe how to upgrade Enterprise Manager 13.1.0.0 to the new 13.2.0.0 version. At the beginning we have to ensure that we applied the latest PSU on the repository database. It is mandatory to apply the following patch before(…)

Oracle 12c – RMAN and Unified Auditing – Does it really work?

By William Sescu The new Oracle Unified Auditing feature, audits RMAN operation per default as soon as you relink your Oracle binary and start your instance. A quite cool new feature, because it allows me to audit RMAN(…)

EnterpriseDB Backup and Recovery Tool (BART)

By Mouhamadou Diaw Many tools are proposed for backup and recovery operation of a PostgreSQL database. EnterpriseDB has developed a product named BART (Backup and Recovery Tool). Use of this product needs a subscription but you can download a trial(…)

Installing PostgreSQL 9.6.1 with EnterpriseDB Installer

By Mouhamadou Diaw As you may know PostgreSQL 9.6 was released a few months ago. And EnterpriseDB (EDB) offers a package installer for installing the community version. This EDB package can be downloaded here. In this(…)