This topic is pretty easy. You have all the default properties that you can list using the broker:
- FastStartFailoverThreshold = '30'
- OperationTimeout = '30'
- FastStartFailoverLagLimit = '30'
- CommunicationTimeout = '180'
- FastStartFailoverAutoReinstate = 'TRUE'
- FastStartFailoverPmyShutdown = 'TRUE'
- BystandersFollowRoleChange = 'ALL'
To change any of them, all you need is to run: "EDIT DATABASE <database name> SET PROPERTY <property name> = <value>;".
In this specific case, you need to change the FastStartFailoverThreshold. After that time, your DB will be failed over automatically by your observer.
Remember that you need to have fast start failover activated and observer running.
Path to Documentation:
Data Guard Concepts and Administration -> 6.7.1 Changing Properties and States
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!