1

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?

1

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

2
  • 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??
    – tesla747
    Aug 31 '15 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. Aug 31 '15 at 10:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.