Re: RMAN impact

  • From: "Joel Garry" <joelgarry@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 10 Mar 2006 15:31:20 -0800

Li wrote:

>We are currently using traditional OS level backup. Our current systems
>not 24/7 so we can afford to have a 2-hour window to just do backups.
We are
>in the process of implementing a new 24/7 system. Apparently the
>way of backup is not suitable for this new system. There are 2 choices
>me: RMAN or backup agent. I am thinking to use RMAN if it doesn't
impact the
>database too much and users are able to access the database as usual
>the backup time period.

One thing about RMAN is it is much easier on a running database than
other backups.  See
up.htm#1004920 about fractured blocks - that means more data must be
written to redo during non-rman backups.  Less of an issue if you are
using a method that breaks a mirror so doesn't keep the db in backup
mode for long.  But of course, resilvering a mirror sometimes has its
own issues.

Joel Garry 


Other related posts: