From Dbvisit Standby version 11.4, the automatic standby update can be managed using CLI. This is done by using either the dbvagentmanager or dbvcontrol binary. The options are very simple and straightforward.
Auto-Update using dbvagentmanager
Below is the option for setting up and managing automatic standby update from dbvagentmanager.
The auto-update has two options.
Modify: This option helps you to manage the automatic standby update for one or multiple configurations.
Status: This option provides the status of a single or multiple configurations
Let's look at the individual options and various functions of these.
Status Option:
[oracle@dbvel71 bin]$ ./dbvagentmanager auto-update status -h Show the status of Automated Standby Update for one or more configurations This command operates on one or more configurations whose primary host is the current host. If the flags specified match more than one configuration, the user is prompted to choose which they wish to operate on, unless the --noprompt flag is specified, in which case all matching configurations are operated on. Usage: dbvagentmanager auto-update status [flags] Examples: To show the status of Automated Standby Update for a named configuration: dbvagentmanager auto-update status --configuration-name DEV To show the status of Automated Standby Update for selected configurations: dbvagentmanager auto-update status To show the status of Automated Standby Update for all configurations with primary on the current host: dbvagentmanager auto-update status --noprompt Flags: -g, --logToStderr send logs to STDERR instead of writing to log files -d, --configuration-name string name of the configuration to operate on -t, --configuration-type string type of the configuration to operate on --instance-name string instance name of the configuration to operate on (SQL Server configurations only) --noprompt update all matching configurations without prompting the user to select -h, --help help for status [oracle@dbvel71 bin]$
Examples:
[oracle@dbvel71 bin]$ ./dbvagentmanager auto-update modify -h Modify the local Automated Standby Update settings for one or more configurations This command operates on one or more configurations whose primary host is the current host. If the flags specified match more than one configuration, the user is prompted to choose which they wish to operate on, unless the --noprompt flag is specified, in which case all matching configurations are operated on. The specified modifications are applied to the Automated Standby Update settings of each of the selected configurations. The user is prompted for confirmation before any updates are performed, unless the --noconfirm flag is specified. If the Agent Manager on this host is not connected to the Control Center, the changes will take effect locally but will not show up in the Control Center until the connection is reestablished. Usage: dbvagentmanager auto-update modify [flags] Examples: To disable Automated Standby Update for a named configuration: dbvagentmanager auto-update modify --configuration-name DEV --disable To enable Automated Standby Update for selected configurations: dbvagentmanager auto-update modify --enable To disable Automated Standby Update for all configurations with primary on the current host: dbvagentmanager auto-update modify --noprompt --disable To enable Automated Standby Update for all configurations with primary on the current host without confirmation: dbvagentmanager auto-update modify --noprompt --enable --noconfirm Flags: -g, --logToStderr send logs to STDERR instead of writing to log files -d, --configuration-name string name of the configuration to operate on -t, --configuration-type string type of the configuration to operate on --instance-name string instance name of the configuration to operate on (SQL Server configurations only) --noprompt update all matching configurations without prompting the user to select --enable enable Automated Standby Update --disable disable Automated Standby Update --set-enabled enabled set whether Automated Standby Update is enabled (true or false) (default (unset)) --set-interval-seconds interval set the Automated Standby Update interval in seconds (default (unset)) --noconfirm skip the confirmation prompt and proceed immediately -h, --help help for modify