I have a file system for my archives which gets full in a short span of time. I want RMAN to backup all the archives automatically and delete the archives after backing it up when the archives mount-point gets full.
Is that possible?
Add a comment
|
1 Answer
Yes, it is.
BACKUP ARCHIVELOG ALL DELETE ALL INPUT;
See: Deleting Archived Redo Logs After Backups in non-CDBs
Or you can use FRA and configure an archivelog deletion policy:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DEVICE TYPE DISK';
This way when the FRA is getting full, the database will automatically delete already backed up archivelogs.
See: CONFIGURE delalConf
answered Aug 31, 2015 at 7:39
-
BACKUP ARCHIVELOG ALL DELETE ALL INPUT -- that has to be set in cron for it run at particular times where after backup its deletes the archive logs by itself..but when that has to be run is the question. How will RMAN know that archives file system is full for it run the script??– tesla747Commented Aug 31, 2015 at 7:59
-
@tesla747 That part you have to handle with custom scripts. RMAN will not start a backup job automatically based on the amount of free space in a filesystem. Commented Aug 31, 2015 at 10:18