asked on

RMAN Archivelog retention issue

I'm looking for suggestions about retaining my most recent archive logs. I perform a full backup every other day with a level 1 between. I would like to keep the most recent archive logs associated with the backups online instead of deleting them after backing up and have them used rather than the backup set for performance reasons. And as always, I need to keep it simple for my client, there is no dba assistance on site.

run{
allocate channel c1 type disk;
allocate channel c2 type disk;
backup incremental level 0 database plus archivelog delete all input;
crosscheck archivelog all;
delete noprompt expired archivelog all;
crosscheck backup;
delete noprompt expired backup;
}

Thanks

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ahaz01

ASKER

Excellent suggestions. I will definitely implement the second part of your suggestion and look at my level 0/1 strategy. My thought was to limit the amount backup sets that might have to be applied during a recovery.

slightwv (䄆 Netminder)

>>My thought was to limit the amount backup sets that might have to be applied during a recovery

That was my thoughts also. It is why I implemented Incrementally Updated Backups. It doesn't take that long to roll the lvl1 into the lvl0 and it is a LOT faster than doing a new lvl0!!!

Once it is done you should only ever have to restore the lvl0 and apply the archived redo for that day.