Infrastructure at your Service

DataGuard Archives - Blog dbi services

Mouhamadou Diaw

Automatic Block Media Recovery in a DataGuard

By | Database Administration & Monitoring | No Comments

With Oracle 12.2, in a Data Guard environment corrupted data blocks can be automatically replaced with uncorrupted copies of those blocks. There are just some requirements: • The physical standby database must be operating in real-time query mode, which requires an Oracle Active Data Guard license. • The physical standby database must be running real-time apply. Automatic block media recovery works in two directions depending on whether the corrupted blocks are encountered on the primary…

 
Read More
William Sescu

Oracle 12cR2 – DataGuard and Backups to NFS

By | Database Administration & Monitoring, Database management | No Comments

From the RMAN point of view, you have generally two possibilities to store your backups, on Disk or on Tape. In case of a single instance, it doesn’t really matter from the accessible or inaccessible point of view. However, in a DataGuard environment it makes a huge difference. Per default, backups to Tape are always accessible and backups to disk always inaccessible. But what do you do in case you backup to NFS, and you…

 
Read More
William Sescu

Oracle 12cR2 – How to Setup DataGuard observer with Oracle Wallets

By | Database Administration & Monitoring, Database management | One Comment

I am not a big fan of having passwords in clear text laying around. This applies not only to application servers, but also for my Data Guard observer. I do have a script for starting the observer that is reading a config file dgobserver.cfg, and this file contains the Username, Passwords and the Connectstring to my Primary and Standby database. #************************************************************* # Connection string to the primary ConnectStringPrim=”sys/Manager1@DBIT122_SITE1″ #************************************************************* # Connection string to the Standby…

 
Read More
William Sescu

Oracle 12cR2 – DataGuard and TCP.VALID_NODE_CHECKING

By | Database Administration & Monitoring, Database management | No Comments

Security is a quite important topic, especially when running Oracle in the cloud. To make your DataGuard a little bit more secure, you can enable the TCP.VALIDNODE_CHECKING feature. I call it SQL*Net Firewall. Enabling the SQL*Net Firewall is quite straight forward. There are only 3 sqlnet.ora parameters which are involved: TCP.VALIDNODE_CHECKING TCP.INVITED_NODES TCP.EXCLUDED_NODES The parameter TCP.VALIDNODE_CHECKING turns this feature on or off. If enabled, then the incoming connections are allowed only if they originate from…

 
Read More
Mouhamadou Diaw

Dataguard Oracle 12.2 : Support for Multiple Automatic Failover Targets

By | Database Administration & Monitoring | No Comments

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 for only a single fast-start failover target. If the failover target was unable to meet the requirements for fast-start failover at the time of primary failure, then an automatic failure would not occur. Designating multiple failover targets significantly improves the likelihood that there…

 
Read More
William Sescu

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

By | Database Administration & Monitoring | No Comments

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 with a lot of parallel processing very useful. But this blog will not be about Temporary Tablespace Groups. They are already explained in the 12.2 Admin Guide. https://docs.oracle.com/database/122/ADMIN/managing-tablespaces.htm#ADMIN-GUID-55A6AE10-6875-4B73-9A5C-CB4965AD5AFE For my Active DataGuard environment, I would like to use…

 
Read More
Mouhamadou Diaw

Dataguard Oracle 12.2 : Fast-Start Failover with Maximum Protection

By | Database Administration & Monitoring | No Comments

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 the Maximum Protection Below our broker configuration DGMGRL> show configuration; Configuration – ORCL_DR Protection Mode: MaxPerformance Members: ORCL_SITE – Primary database ORCL_SITE1 – Physical standby database ORCL_SITE2 – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated…

 
Read More
William Sescu

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

By | Database Administration & Monitoring, Database management | No Comments

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 SYSDG Administrative Privilege for Oracle Data Guard Operations comes into play. The SYSDG privilege is quite powerful and allows you to work with the Broker (DGMGRL) command line interface and besides that, it enables the following operations: STARTUP…

 
Read More
William Sescu

Oracle 12cR2 – DataGuard and the REDO_TRANSPORT_USER

By | Database Administration & Monitoring, Database management | One Comment

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 high privileged user only for the redo transmission. To overcome this issue, Oracle has implemented the REDO_TRANSPORT_USER initialization parameter. The REDO_TRANSPORT_USER specifies the name of the user whose password verifier is used when a remote login password file…

 
Read More
William Sescu

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

By | Database Administration & Monitoring | One Comment

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 process won’t attach Standby Redo Logs, and you should have at least one more of the Standby Redo Log Group as you have for your Online Redo Log Group per Thread. For my single instance, this should be…

 
Read More