Under normal operation, the restart-after-transition property automatically restarts the database after transition when you set its value to 1.

Online failover transition changes the behavior of the restart-after-transition property during failover tranistion to behave as follows:

  • 0 — The database will shut down after online transition is complete.
  • 1 — This value will be ignored. The database will not automatically restart but will remain online.
In addition, the following database startup properties will be ignored when the restart-after-transition property is set to 1:
  • source-startup-arguments
  • target-startup-arguments
  • normal-startup-arguments
  • start-secondary-broker
  • source-secondary-broker-startup-arguments
  • target-secondary-broker-startup-arguments
  • normal-secondary-broker-startup-arguments

This behavior applies to both source and target databases.