Forum Stats

  • 3,817,093 Users
  • 2,259,275 Discussions
  • 7,893,654 Comments

Discussions

Data Guard, failover to second standby database

pcpaasche
pcpaasche Member Posts: 100 Blue Ribbon

We are working on moving our databases from on-prem to virtual machines in Azure. 

Our application is a critical 24/7/365 system and we are aiming at RPO and RTO as close to zero as possible.

The setup we have planned in Azure is a 3 database setup, hence one primary and two standby databases using Data Guard with Maximum Availability option. 

In case of a failover, one standby database should become primary. 

However, we have been informed that automatic failover can only happen to one of the two standby databases. If failover to the first standby database fails, we will have to do a manual failover to the second standby database. Hence the failover is not automatic and there will be downtime until someone on our internal support comes along to run the needed commands to this second standby database.

Is it correct that automatic failover can only happen to one of the two standby databases and that there must be manual intervention if the second standby database is to become primary?

Tagged: