Oracle Database Discussions

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!

Huge archive log size

941070Jul 16 2012 — edited Jul 16 2012

i have 5 redo log files. Each is 4 GB. There are huge transactions (1800-2000 per sec). So we have hourly 5-6 log switches. So hourly archive log size increases by 20-24 GB and per day the size increases by 480 GB.

I planned to take incremental backup of level 0 weekly and level 1 daily with the delete option of archive log "sysdate-1".

But we have limited storage so nearly it's impossible to sphere 480 GB per day and take backup of those 480 GB for 7 days (480*7) GB = 4 TB. How can I tackle this situation? Plz help.

This post has been answered by unknown-698157 on Jul 16 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2012

Added on Jul 16 2012

#11g, #database, #dba, #general-database-discussions, #oracle

6 comments

2,134 views