DRAUTO

onconfig.std value

0

range of values

0 signifies OFF = Do not automatically switch the server type in the HDR environment.

1 signifies RETAIN_TYPE = Automatically switch secondary to standard during an HDR failure. Switch back to secondary when restarting HDR.

2 signifies REVERSE_TYPE = Automatically switch secondary to standard on an HDR failure. Switch to primary (and switch original primary to secondary) when restarting HDR.

takes effect

When shared memory is initialized

utilities

ON-Monitor > Parameters > data-Replication > Auto
onstat (See The onstat -g dri Option.)

DRAUTO determines how a secondary database server reacts to an HDR failure. This parameter should have the same value on both HDR servers.

If DRAUTO is set to OFF, the secondary database server remains a secondary database server in read-only mode when an HDR failure occurs.

If DRAUTO is set to either RETAIN_TYPE or REVERSE_TYPE, the secondary database server switches to type standard automatically when an HDR failure is detected. If DRAUTO is set to RETAIN_TYPE, the original secondary database server switches back to type secondary when the HDR connection is restored. If DRAUTO is set to REVERSE_TYPE, the original secondary database server switches to type primary when the HDR connection is restored, and the original primary switches to type secondary.

Use this parameter carefully. A network failure (that is, when the primary database server does not really fail, but the secondary database server perceives network slowness as an HDR failure) can cause the two database servers to become out of synch.