size of Incremental Backups verses Redo Generated

  • From: kyle Hailey <kylelf@xxxxxxxxx>
  • To: ORACLE-L <Oracle-L@xxxxxxxxxxxxx>
  • Date: Thu, 21 Oct 2010 12:45:55 -0700

What relationship do people see between the size  of Incremental Backups and
the size of the Redo generated between those backups?

Of course it completely depends on the system. If the system is hitting the
same blocks over and over again then the redo could be high and incremental
small but if the system is doing small modifications to blocks scattered
through the database then I'd expect the opposite - larger incremental vs
small redo.

Still ...
I'm interested in real world numbers if anyone has them to share.

Thanks
Kyle Hailey
http://db-optimizer.blogspot.com/

Other related posts: