...
Dbvisit Standby Archive Log Management Module includes the following options:
Alerts through email when Oracle archive logs have reached a set threshold of available disk space.
Can delete Oracle archive logs after a set number of days.
Can ensure that only x number of Oracle archive log files remain on the server.
Can delete Oracle archive logs after available disk space has been used up to ensure continual database operation.
Ensures the Oracle archive logs have been sent to the standby database before removing any archive logs.
Can integrate with Backup software to ensure archive logs have been backed up before removing.
| Note |
|---|
Dbvisit Standby is not replacing your backup scripts or backup software. It is important that you still backup your database and archive log to a different storage or a tape device. |
...
The order of precedence in managing the archive log files are:
If there are archive log files older than days to keep the archive log files, then delete these.
If there are more archive log files than Number of archive log files to keep, then delete these (oldest ones first).
If there are more archive logs that have been backed up by RMAN at least Number of times an archive log has to be backed up rman before being deleted times, then delete these.
If the Threshold in % of how much disk space may be used < mount point fullness criteria are met, then mark archives for deletion (oldest ones first). The number of archives marked for deletion is how many archive logs. The archives will only be deleted if Delete archive files once threshold is reached=Y. After deletion of the archives, and the criteria are still met (Threshold in % of how much disk space may be used < mount point fullness), then mark more archives for deletion (number of archives marked for deletion will be again HOWMANY_ARCHSOURCE, and oldest ones first). This process will continue until the criteria are no longer met.
If Delete archive files once threshold is reached=N, then only a warning email will be sent. No archives will be deleted when the Threshold in % of how much disk space may be used < mount point fullness criteria are met. Setting variable Delete archive files once threshold is reached=N has no influence over days to keep the archive log files and Number of archive log files to keep. These will still delete archive files when their criteria are met.
...
Number | GUI Field Name | DDC variable | Values |
1 | Enable Archivelog Management on Primary | ARCHSOURCE_MANAGEMENT | Y or N |
2 | Number of archive log files to keep | NUM_ARCHSOURCE_TO_KEEP | whole numbers, 0 to disable |
3 | Days to keep the archive log files | DAYS_TO_KEEP_ARCHSOURCE | whole and decimal numbers, 0 to disable |
4 | Number of times an archive log has to be backed up by rman before being deleted | ARCHSOURCE_BACKUP_COUNT | whole numbers, 0 to disable |
5 | Threshold in % of how much disk space may be used | THRESHOLD_ARCHSOURCE | percent |
6 | Threshold in % of how much FRA space may be used | FRA_THRESHOLD_ARCHSOURCE | percent |
7 | Delete archive files once threshold is reached | DELETE_ARCHSOURCE_THRESHOLD | Y or N |
8 | Enable Archivelog Management on Standby | ARCHDEST_MANAGEMENT | Y or N |
9 | Number of archive log files to keep | NUM_ARCHDEST_TO_KEEP | whole and decimal numbers, 0 to disable |
10 | Days to keep the archive log files | DAYS_TO_KEEP_ARCHDEST | whole and decimal numbers, 0 to disable |
11 | Threshold in % of how much disk space may be used | THRESHOLD_ARCHDEST | percent |
12 | Delete archive files once threshold is reached | DELETE_ARCHDEST_THRESHOLD | Y or N |
5.1 Primary Archive Management Settings
| Note |
|---|
Primary Archive Log Management by Dbvisit deletes own primary database archivelogs - so directly from Flash Recovery Area or log_archive_dest |
( 1 ) Enable archive log management on primary: By default, this setting is set to No and you can enable it when you want Dbvisit to manage the archive logs from the primary database.
...
5.2 Standby Archive Management Settings
| Note |
|---|
Standby Archive Log Management by Dbvisit deletes transferred archivelogs in ARCHDEST location on standby server |
( 8 ) Enable Archive Management on Standby: Specifies if the AMM module to manage the archive log files is turned on or off on the standby server. This is recommended to set to yes as it will manage the archive logs that are shipped from primary to standby’s Archive log destination location(ARCHDEST).
...