...
ASU can be manually disabled or enabled and user can specify interval indicating how frequently should the force online log switch occur.
1. ASU status and modification
ASU status can be checked by mouse-over in the dbvserver DASHBOARD configuration ASU icon:
...
You must click on Set (3) to apply any modifications you made.
2. Checking Standby database gap
| Note |
|---|
In Standard edition, it is not possible to rely in v$ views to determine standby database lag. Sqlplus command archive log list on standby will not have any relevant information either. |
...
Note that both values are independent on each other.
A. Information from Last applied Archivelog Job
This information is displayed as a small information below the configuration name:
...
It is updated automatically by the apply job.
B. Log Gap Report
User has the possibility to run log gap report, which will check the recovery status of standby database. This report can bne initiated by running “View Detailed Log gap Report” (1) from the ACTIONS right pane:
...
| Info |
|---|
Log gap report is an expensive operation, because it requires running SQL in primary and standby database with network roundtrip. When used for monitoring, we recommend interval of at least 2-3 minutes between individual runs. |
3. Manually transferring and applying single archiveglog file
This task is very useful when in doubt about synchronization status and for testing that individual ASU synchronization jobs work without any issues.
| Info |
|---|
ASU must be disabled prior to performing this operation, otherwise ASU transfer and apply jobs can conflict with manual jobs |
A. Transferring archivelog from primary
Transfer of single archivelog can be initiated from the ACTIONS pane:
...
You will be able to view job details:
...
B. Applying transferred archivelog on standby
Apply of single archivelog can be initiated from ACTIONS pane as well:
...