Dbvisit Replicate offers automatic house keeping (housekeeping) on the following files:
Dbvisit Replicate plog files
The management of plog files on source and target systems are done according to the following settings:
| Default | ||
|---|---|---|
| DELETE_OBSOLETE_PLOGS_AGE | Delete plogs after specific time period. Time period can be days (d) or hours(h) | 3d |
| DELETE_OBSOLETE_PLOGS_SIZE_MB | Delete plogs are total size of all plogs exceeds size in MB | 1024 |
| DELETE_OBSOLETE_PLOGS_GZIP | Compress the plogs as soon as they are not needed by Dbvisit Replicate anymore | Yes |
The management of the plogs can be found in the Mine/Apply log files
...
by searching for "plog maintenance with settings".
The management is done on every plog switch.
Dbvisit Replicate redo files
If the Fetcher process is used, then redo logs are transferred from the source database server to the server where the Mine process running. Once the redo logs have been mined, they are no longer needed
...
by Dbvisit Replicate and will be managed according to the following settings:
The management of these redo logs are done according to the following settings:
| Default | ||
|---|---|---|
| DELETE_OBSOLETE_RLOGS_AGE | Delete redo logs after specific time period. Time period can be days (d) or hours(h) | 3d |
| DELETE_OBSOLETE_RLOGS_SIZE_MB | Delete redo logs are total size of all plogs exceeds size in MB | 1024 |
| DELETE_OBSOLETE_RLOGS_GZIP | Compress the redo logs as soon as they are not needed by Dbvisit Replicate anymore | Yes |
The management of the redo logs can be found in the Mine
...
log files by searching for "
...
rlog maintenance with settings".
The management is done on every log switch. The redo logs are located in a directory called mine_stage.
Dbvisit Replicate log files
- . These are set managed to keep one backup file and a size limit of 100MB. This is configurable through the parameters:
- LOG_FILE_SIZE
- LOG_FILE_COUNT
- LOG_FILE_DATE_ROTATE
Manual house keeping is required on the following files:
- Dbvisit Replicate trace files
- Dbvisit Replicate Cache files (see below)
...