Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

backup archivelog-limit

lm422407shApr 13 2011 — edited Apr 14 2011
Is there any way to limit the archive log file back up, I don’t want to take all the archive logs generated since it reaches 80 to 90 GB and more than 100 files. Backup time takes more than hour to complete and also it affects the performance of other process. I want take only 10 or 20 files at the time so that I can reduce the backup time during batch process, at the same time it solves my space issue.
I am using the following script and it takes all the archive logs exist.

backup as compressed backupset
filesperset 20
format $BKUP_FORMAT
archivelog all
delete input;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2011
Added on Apr 13 2011
6 comments
1,812 views