I can you identify the log files that are safe to delete that are on the consolidated database? I have a backlog of log files that will not get auto deleted after the backups are being made.
Would it be a safe assumtion knowing that all my remotes have replciated in within the last 30 days to delete all the log files that are greater than 30 days old?
asked 27 Dec '11, 18:38
IMHO, that task should be left to the SQL Remote system itself, by using the DELETE_OLD_LOGS option and setting it to something different than its default value OFF:
Note that the possibility to set it to n days was introduced with 10.0.1, however "ON" and "DELAY" can be used with v8 as well, such as:
set option PUBLIC.delete_old_logs = 'delay';
I would recommend that for both the cons and the remotes.
Knowing that all remotes have replicated in the last n days is not really enough to know, methinks - a remote may have missed a message and asked the cons for a re-send, so not all operations from older logs are necessarily confirmed. However, querying the SYSREMOTEUSER system table will tell you which is the largest offset confirmed by all remotes.
answered 28 Dec '11, 05:03