...
From the above screen shot the numbers 1 to 7 indicate the settings for managing oracle archivelogs in the primary database, this is optional if you have your backup jobs that take care of deleting the archivelogs , you can leave this setting disabled. Remember the archivelogs must be retained for the dbvisit process to transfer it from primary tostandby. The setting indicated from number 8 to 12 are for managing the standby database archivelogs.
GUI field names and DDC variables referrence:
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 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 |
|---|
This setting has no influence on whether (archive) log files are deleted for the Number of archivelogs to keep or Days to keep archive log files. These settings will delete (archive) log files once the percentage threshold is met. |
Process Flow for Primary AMM:
...
5.2 Standby Archive Management Settings
...
| Note |
|---|
This setting has no influence on whether archive log files are deleted for Days to keep archive log files or Number of archive log files to keep. These settings will delete archive log files once the percentage threshold is met. |
Flow of standby AMM process:
...
Below is an example of the archive log management settings from both primary and standby. In this example we have set for both primary and standby. We recommend checking the archivelog and database backup schedules and deletion frequencies before enabling this in the primary.
...