...
The other option is to use --host-name is used for changing the auto-update setting specific to primary host. This can be done to update the setting if configurations have different primary and standby hosts. and --instance-name is used for SQL Server instance names.
The status of the configuration can be directly got from the dashboard option of the dbvcontrol.
| Code Block |
|---|
[oracle@dbvel72 bin]$ ./dbvcontrol dashboard
Trace log will be written to '/usr/dbvisit/standbymp/log/trace/dbvcontrol_dashboard_27355.trace.log'.
Please enter credentials for the StandbyMP Control Center.
? Username: admin
? Password: *****
+--------------------------------------------------------------------------------+
| orcl21c (Oracle) between dbvel71 and dbvel72 |
| |
| Primary database on dbvel71: ONLINE |
| Standby database on dbvel72: RECOVERING |
| Automated Standby Update is enabled and configured to run every 300 seconds. |
| Time gap: 1 minute 16 seconds |
+--------------------------------------------------------------------------------+
|
| Code Block |
|---|
C:\Program Files\Dbvisit\standbymp\bin>dbvcontrol.exe dashboard
Trace log will be written to 'C:\Program Files\Dbvisit\standbymp\log\trace\dbvcontrol_dashboard_3748.trace.log'.
Please enter credentials for the StandbyMP Control Center.
? Username: admin
? Password: *****
+-------------------------------------------------------------------------------------------------------------------------------------------------------+
| AdWorks (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
| |
| Primary database on toru.MP-webinar.envbuilder.cubicle-labs.com: ONLINE |
| Standby database on wha.MP-webinar.envbuilder.cubicle-labs.com: RESTORING |
| Automated Standby Update is enabled and configured to run every 75 seconds. |
| Time gap: 22 seconds |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+
| TEAM (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
| |
| Primary database on toru.MP-webinar.envbuilder.cubicle-labs.com: ONLINE |
| Standby database on wha.MP-webinar.envbuilder.cubicle-labs.com: RESTORING |
| Automated Standby Update is enabled and configured to run every 75 seconds. |
| The Observer is monitoring this configuration. |
| Time gap: 22 seconds |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+
| NEW (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
| |
| Primary database on toru.MP-webinar.envbuilder.cubicle-labs.com: ONLINE |
| Standby database on wha.MP-webinar.envbuilder.cubicle-labs.com: RESTORING |
| Automated Standby Update is enabled and configured to run every 75 seconds. |
| Time gap: 23 seconds |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+
| KEY (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
| |
| Primary database on toru.MP-webinar.envbuilder.cubicle-labs.com: ONLINE |
| Standby database on wha.MP-webinar.envbuilder.cubicle-labs.com: RESTORING |
| Automated Standby Update is enabled and configured to run every 75 seconds. |
| The Observer is monitoring this configuration. |
| Time gap: 23 seconds |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+
| LINE (SQL Server) between MSSQLSERVER on toru.MP-webinar.envbuilder.cubicle-labs.com and MSSQLSERVER on wha.MP-webinar.envbuilder.cubicle-labs.com |
| |
| Primary database on toru.MP-webinar.envbuilder.cubicle-labs.com: ONLINE |
| Standby database on wha.MP-webinar.envbuilder.cubicle-labs.com: RESTORING |
| Automated Standby Update is enabled and configured to run every 75 seconds. |
| The Observer is monitoring this configuration. |
| Time gap: 23 seconds |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+ |