Chapter 11. Data Guard Best Practices

In many Data Guard installation cases, people may think that seeing the main functions of Data Guard running is enough for a successful deployment of Data Guard. In other words, if redo is being transferred from the primary database to a standby database(s), and is being applied on the standby, it's a smooth Data Guard configuration. However, if the configuration is prepared keeping in mind best practices, which is the topic of this chapter, it will be more robust, effective, and complete.

In this chapter, we will discuss the following topics:

• Configuring connection failover

• Archived log deletion policy on a standby database

• Using flashback on a standby database

• Database rolling upgrade using a transient logical standby

• Corruption detection, prevention, and automatic repair with Oracle Data Guard

Let's start with configuring a connection failover in a Data Guard environment.