...
The -g option provides you with standard log output of the status on the screen rather than in the log file. This is useful for troubleshooting , incase in case the auto-update is not working as expected.
...
This option has flags to disable, enable, set time intervals between standby and primary, and various other options.
...
| Code Block |
|---|
[oracle@dbvel71 bin]$ ./dbvagentmanager auto-update modify --disable Trace log will be written to '/usr/dbvisit/standbymp/log/trace/dbvagentmanager_auto-update_modify_13422.trace.log'. Will update configuration orcl21c (Oracle) between dbvel71 and dbvel72 (currently DISABLED with an interval of 600 seconds) to be DISABLED with an interval of 600 seconds ? Update 1 configuration(s) - are you sure? Yes Successfully updated configuration orcl21c (Oracle) between dbvel71 and dbvel72 |
disable with noconfirm: This option does not ask for confirmation but disables your automated standby update
| Code Block |
|---|
[oracle@dbvel71 bin]$ ./dbvagentmanager auto-update modify --disableenable --noconfirm Trace log will be written to '/usr/dbvisit/standbymp/log/trace/dbvagentmanager_auto-update_modify_1230317456.trace.log'. Will update configuration orcl21c (Oracle) between dbvel71 and dbvel72 (currently ENABLEDDISABLED with an interval of 600 seconds) to be DISABLEDENABLED with an interval of 600 seconds ? Update 1 configuration(s) - are you sure? Yes Successfully updated configuration orcl21c (Oracle) between dbvel71 and dbvel72 [oracle@dbvel71 bin]$ |
disable/enable with noprompt noconfirm: This option would disable all the active configurations without letting the user choose what configuration to disable. This is valid only when you have multiple configurations. But confirmation is required to disable/enable.
...
does not ask for confirmation but disables your automated standby update
| Code Block |
|---|
[oracle@dbvel71 bin]$ ./dbvagentmanager auto-update modify --enabledisable --nopromptnoconfirm Trace log will be written to 'C:\Program Files\Dbvisit\standbymp\log\trace\/usr/dbvisit/standbymp/log/trace/dbvagentmanager_auto-update_modify_444412303.trace.log'. Will update configuration AdWorksorcl21c (SQL ServerOracle) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com dbvel71 and dbvel72 (currently DISABLEDENABLED with an interval of 120600 seconds) to be ENABLEDDISABLED with an interval of 120600 seconds WillSuccessfully updateupdated configuration TEAMorcl21c (SQL ServerOracle) between MSSQLSERVERdbvel71 on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently DISABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds and dbvel72 [oracle@dbvel71 bin]$ |
| Code Block |
|---|
[oracle@dbvel71 bin]$ ./dbvagentmanager auto-update modify --enable --noconfirm Trace log will be written to '/usr/dbvisit/standbymp/log/trace/dbvagentmanager_auto-update_modify_18106.trace.log'. Will update configuration NEWorcl21c (SQL ServerOracle) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.comdbvel71 and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.comdbvel72 (currently DISABLED with an interval of 120600 seconds) to be ENABLED with an interval of 120600 seconds WillSuccessfully updateupdated configuration KEYorcl21c (SQL ServerOracle) between MSSQLSERVERdbvel71 on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently DISABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds and dbvel72 [oracle@dbvel71 bin]$ |
Disable/enable with noprompt: This option would disable all the active configurations without letting the user choose what configuration to disable. This is valid only when you have multiple configurations. But confirmation is required to disable/enable.
| Code Block |
|---|
C:\Program Files\Dbvisit\standbymp\bin>dbvagentmanager.exe auto-update modify --enable --noprompt Trace log will be written to 'C:\Program Files\Dbvisit\standbymp\log\trace\dbvagentmanager_auto-update_modify_4444.trace.log'. Will update configuration LINEAdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently DISABLED with an interval of 300120 seconds) to be ENABLED with an interval of 300120 seconds Will ?update Updateconfiguration 5TEAM configuration(s) - are you sure? Yes Successfully updated configuration AdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated configuration TEAM (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated configuration NEW (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated configuration KEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated configuration LINE (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
...
SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently DISABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds
Will update configuration NEW (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently DISABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds
Will update configuration KEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently DISABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds
Will update configuration LINE (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently DISABLED with an interval of 300 seconds) to be ENABLED with an interval of 300 seconds
? Update 5 configuration(s) - are you sure? Yes
Successfully updated configuration AdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com
Successfully updated configuration TEAM (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com
Successfully updated configuration NEW (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com
Successfully updated configuration KEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com
Successfully updated configuration LINE (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
noprompt with noconfirm. This would disable all active configurations and not ask for confirmation or let you choose any configuration.
| Code Block |
|---|
C:\Program Files\Dbvisit\standbymp\bin>dbvagentmanager.exe auto-update modify --enable --noprompt --noconfirm
Trace log will be written to 'C:\Program Files\Dbvisit\standbymp\log\trace\dbvagentmanager_auto-update_modify_4776.trace.log'.
Will update configuration AdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds
Will update configuration TEAM (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds
Will update configuration NEW (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds
Will update configuration KEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds
Will update configuration LINE (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 300 seconds) to be ENABLED with an interval of 300 seconds
Successfully updated configuration AdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com
Successfully updated configuration TEAM (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com
Successfully updated configuration NEW (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com
Successfully updated configuration KEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com
Successfully updated configuration LINE (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
disabling and enabling specific configurations: To use this option -d is used to choose the configuration for which the options can be enabled or disabled
| Code Block |
|---|
[oracle@dbvel71 bin]$ ./dbvagentmanager auto-update modify -d orcl21c --disable
Trace log will be written to '/usr/dbvisit/standbymp/log/trace/dbvagentmanager_auto-update_modify_13790.trace.log'.
Will update configuration orcl21c (Oracle) between dbvel71 and dbvel72 (currently ENABLED with an interval of 600 seconds) to be DISABLED with an interval of 600 seconds
? Update 1 configuration(s) - are you sure? Yes
Successfully updated configuration orcl21c (Oracle) between dbvel71 and dbvel72 |
| Code Block |
|---|
C:\Program Files\Dbvisit\standbymp\bin>dbvagentmanager.exe auto-update modify -d AdWorks --disable
Trace log will be written to 'C:\Program Files\Dbvisit\standbymp\log\trace\dbvagentmanager_auto-update_modify_900.trace.log'.
Will update configuration AdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120 seconds) to be DISABLED with an interval of 120 seconds
? Update 1 configuration(s) - are you sure? Yes
Successfully updated configuration AdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com
|
| Code Block |
|---|
[oracle@dbvel71 bin]$ ./dbvagentmanager auto-update modify -d orcl21c --enable
Trace log will be written to '/usr/dbvisit/standbymp/log/trace/dbvagentmanager_auto-update_modify_18812.trace.log'.
Will update configuration orcl21c (Oracle) between dbvel71 and dbvel72 (currently DISABLED with an interval of 600 seconds) to be ENABLED with an interval of 600 seconds
? Update 1 configuration(s) - are you sure? Yes
Successfully updated configuration orcl21c (Oracle) between dbvel71 and dbvel72
[oracle@dbvel71 bin]$ |
| Code Block |
|---|
C:\Program Files\Dbvisit\standbymp\bin>dbvagentmanager.exe auto-update modify -d AdWorks --enable
Trace log will be written to 'C:\Program Files\Dbvisit\standbymp\log\trace\dbvagentmanager_auto-update_modify_956.trace.log'.
Will update configuration AdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently DISABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds
? Update 1 configuration(s) - are you sure? Yes
Successfully updated configuration AdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
Change Automatic Standby Interval
The option --set-interval-seconds is used to change the automated standby interval time. The -d option is used to specify the configuration for which the interval is changed. The option of noprompt and noconfirm is used in the same way as above. If -d is not used, all the configuration’s interval is changed to the provided value. The -t option is used to change for specific database types (Oracle, SQLServer).
| Code Block |
|---|
[oracle@dbvel71 bin]$ ./dbvagentmanager auto-update modify -d orcl21c --set-interval-seconds 300
Trace log will be written to '/usr/dbvisit/standbymp/log/trace/dbvagentmanager_auto-update_modify_23600.trace.log'.
Will update configuration orcl21c (Oracle) between dbvel71 and dbvel72 (currently ENABLED with an interval of 600 seconds) to be ENABLED with an interval of 300 seconds
? Update 1 configuration(s) - are you sure? Yes
Successfully updated configuration orcl21c (Oracle) between dbvel71 and dbvel72
[oracle@dbvel71 bin]$ |
| Code Block |
|---|
C:\Program Files\Dbvisit\standbymp\bin>dbvagentmanager.exe auto-update modify --enable set-interval-nopromptseconds --noconfirm75 Trace log will be written to 'C:\Program Files\Dbvisit\standbymp\log\trace\dbvagentmanager_auto-update_modify_4776.trace.log'. Will update configuration AdWorks\dbvagentmanager_auto-update_modify_1764.trace.log'. ? Please choose the configurations to operate on AdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120 seconds), TEAM (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120 seconds), NEW (SQL Server) to be between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120 seconds Will update configuration TEAM), KEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120 seconds) to be ENABLED with an interval of 120 seconds Will update configuration NEW , LINE (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120300 seconds) to be ENABLED with an interval of 120 seconds Will update configuration KEYAdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 120 seconds) to be ENABLED with an interval of 12075 seconds Will update configuration LINETEAM (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 300120 seconds) to be ENABLED with an interval of 30075 seconds SuccessfullyWill updatedupdate configuration AdWorksNEW (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated configuration TEAM-labs.com (currently ENABLED with an interval of 120 seconds) to be ENABLED with an interval of 75 seconds Will update configuration KEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated (currently ENABLED with an interval of 120 seconds) to be ENABLED with an interval of 75 seconds Will update configuration NEWLINE (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated configuration KEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com(currently ENABLED with an interval of 300 seconds) to be ENABLED with an interval of 75 seconds ? Update 5 configuration(s) - are you sure? Yes Successfully updated configuration LINEAdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
disabling and enabling specific configurations: To use this option -d is used to choose the configuration for which the options can be enabled or disabled
| Code Block |
|---|
[oracle@dbvel71 bin]$ ./dbvagentmanager auto-update modify -d orcl21c --disable Trace log will be written to '/usr/dbvisit/standbymp/log/trace/dbvagentmanager_auto-update_modify_13790.trace.log'. Will update configuration orcl21c (Oracle) between dbvel71 and dbvel72 (currently ENABLED with an interval of 600 seconds) to be DISABLED with an interval of 600 seconds ? Update 1 configuration(s) - are you sure? Yes Successfully updated configuration orcl21c (Oracle) between dbvel71 and dbvel72-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated configuration TEAM (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated configuration NEW (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated configuration KEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com Successfully updated configuration LINE (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
| Code Block |
|---|
C:\Program Files\Dbvisit\standbymp\bin>dbvagentmanager.exe auto-update modify -d AdWorks KEY --set-interval-seconds 90 --disablenoconfirm Trace log will be written to 'C:\Program Files\Dbvisit\standbymp\log\trace\dbvagentmanager_auto-update_modify_9004836.trace.log'. Will update configuration AdWorksKEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com (currently ENABLED with an interval of 12075 seconds) to be DISABLEDENABLED with an interval of 12090 seconds ? Update 1 configuration(s) - are you sure? Yes Successfully updated configuration AdWorksKEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |