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
ahaz01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
>>I perform a full backup every other day with a level 1 between

First, I would suggest you look into Incrementally Updated Backups
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmquick.htm#BRADV89346

In a nutshell:
You take the lvl0, then after you take the next lvl1, you apply the lvl1 back into the lvl0.  No need for a full lvl0 unless something bad happens to the one you have.

And, if you haven't turned on block change tracking, you should look into that as well.

Now to your question:
I separate out the archive log backups as its own backup step.

Then I specify how long to keep them on disk with a separate delete command:
delete archivelog all completed before 'SYSDATE-2';
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ahaz01Author Commented:
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.
0
slightwv (䄆 Netminder) Commented:
>>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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.