Full vs Incremental

  • From: "Storey, Robert \(DCSO\)" <RStorey@xxxxxxxxxxxxxxxxxx>
  • To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 10 Sep 2010 13:20:40 -0500

So, my backup person and I were having a discussion. We use symatnec's
software to do the backup of our oracle database. It in turn is issuing
the rman scripts.

 

Our database is about medium size, probably about 100gig.  The full
backup takes about 35 minutes.

 

We are doing fulls every night. We used to do traditional hot backups,
but changed to rman and using fulls.

 

So, do I keep doing fulls every night, or do I shift to schedule of
full's with incremental in between?  Are there pro's or cons' to either
setup?

 

Thanks

Other related posts: