BE SHARING

DataGuard

Dataguard Oracle 12.2 : Support for Multiple Automatic Failover Targets

15.12.2016 by Oracle Team

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(…)

Database Administration & Monitoring

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

15.12.2016 by Oracle Team

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(…)

Database Administration & Monitoring

Dataguard Oracle 12.2 : Fast-Start Failover with Maximum Protection

14.12.2016 by Oracle Team

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(…)

Database Administration & Monitoring

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

14.12.2016 by Oracle Team

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(…)

Database Administration & Monitoring

Oracle 12cR2 – DataGuard and the REDO_TRANSPORT_USER

14.12.2016 by Oracle Team

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(…)

Database Administration & Monitoring

Oracle 12c DataGuard – Insufficient SRLs reported by DGMGRL VALIDATE DATABASE VERBOSE

30.11.2016 by Oracle Team

By William Sescu I have setup a DataGuard environment and followed the instructions from Oracle to create the Standby Redo Logs. The Standby Redo Logs have to be the same size as the Online Redo Logs. If not, the RFS(…)