Infrastructure at your Service

DataGuard Archives - Blog dbi services

Mouhamadou Diaw

Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE

By | Database Administration & Monitoring | 4 Comments

With Oracle Database 18c, we can now refresh a standby database over the network using one RMAN command, RECOVER STANDBY DATABASE. The RECOVER STANDBY DATABASE command restarts the standby instance, refreshes the control file from the primary database, and automatically renames data files, temp files, and online logs. It restores new data files that were added to the primary database and recovers the standby database up to the current time. When you use the RECOVER…

Read More
Mouhamadou Diaw

Using Oratcptest

By | Database Administration & Monitoring | No Comments

Last day I did some tests with Oratcptest. This a command line tool which can be used to measure network bandwidth and network latency between client and server. In this blog I am going to show how to use this tool in a DataGuard environment. I am using a DataGuard environment with following configuration. Configuration – PROD Protection Mode: MaxAvailability Members: PROD_SITE1 – Primary database PROD_SITE2 – Physical standby database PROD_SITE3 – Physical standby database…

Read More
Mouhamadou Diaw

DataGuard and Transparent Data Encryption

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

Setting up a DatagGard environment for a database with Transparent Data Encryption requires some tasks concerning the encryption keys. Otherwise the steps are the same than for an environment without TDE. In this blog we will present the tasks we have to do on both primary and standby servers for the keys. We will not describe the procedure to build the standby database. We will just talk about tasks for the wallet and we will…

Read More
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
Oracle Team

Oracle 12cR2 – DataGuard and Backups to NFS

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

By William Sescu 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…

Read More
Oracle Team

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

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

By William Sescu 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…

Read More
Oracle Team

Oracle 12cR2 – DataGuard and TCP.VALID_NODE_CHECKING

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

By William Sescu 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…

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
Oracle Team

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

By | Database Administration & Monitoring | No Comments

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

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