Database Backup and Recovery (MOSC)

MOSC Banner

Incremental backup size same as full

edited Aug 15, 2013 4:10AM in Database Backup and Recovery (MOSC) 14 commentsAnswered
Hello RMAN gurus,

I have a 10.2.0.5 database running on RH Linux 5.8 in NOARCHIVELOG.  Database size is about 110Gb.  I take one level 0 full backup every Sunday and I take level 1 cumulative backups Mon-sat.  The incremental backup strategy is new and started about a month ago, we used take daily full backups before.  My question is about the size of the incremental backup.  This is a data warehouse with very little daily activity. 

My Sunday full backup set is about 40Gb.  On Monday the size of my incremental backup is about 50Mb, makes sense.  On Tuesday the incremental backup set size is 40Gb, same size as my Sunday full backup!  It stays at 40Gb for the rest of the week until next full backup. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center