Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: rman incremental merge

RE: rman incremental merge

From: Stephens, Chris <chris_stephens_at_admworld.com>
Date: Mon, 4 Dec 2006 11:16:52 -0600
Message-ID: <7070047601C21A4CB387D50AD3661F6E05ACFAC3@050EXCHANGE.research.na.admworld.com>

 

We use them here without a problem. ...we just recently had to recover a database to a point in time prior to olap going bizark. Works fine if you have the disk space.

chris
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Don Seiler Sent: Monday, December 04, 2006 11:12 AM To: Randy.Steiner_at_nyct.com
Cc: Jared Still; oracle-l_at_freelists.org
Subject: Re: rman incremental merge

The usage that I've seen and used is to start with a level 0, and from there on out you'd only take level 1 incrementals. Then, based on your recovery window, you could roll your base backup image forward, for example to 7 days ago, if that is your window. It saves you the time of not having to do another level 0, but having a recent level 0 image to start with for recovery.

The reason I stopped using it is that you HAVE to do a backup COPY. I didn't have the disk to hold an actual copy, and needed to have compression.

Don.

On 12/4/06, Steiner, Randy <Randy.Steiner_at_nyct.com> wrote:
> In the documentation, it is refered to as Incrementally Updated
Backups:
> Rolling forward image copy backups.
>
> It is a level 1 incremental that is applied to the image copy and
> rolled forward to the point in time when the level 1 was created.
>
>
>
> > -----Original Message-----
> > From: Jared Still [mailto:jkstill_at_gmail.com]
> > Sent: Monday, December 04, 2006 11:50 AM
> > To: Steiner, Randy
> > Cc: oracle-l_at_freelists.org
> > Subject: Re: rman incremental merge
> >
> > On 12/4/06, Steiner, Randy <Randy.Steiner_at_nyct.com> wrote:
> >
> > Have people been using the incremental merge feature of rman
> > successfully?
> >
> > It seems a little scary to me.
> >
> >
> > By 'incremental merge', are you referring to restoring a database
> > using incremental backups? (sorry, unfamiliar with this term)
> >
> > If so, consider this: why would that be any scarier than apply
> > archive logs?
> >
> >
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l



CONFIDENTIALITY NOTICE: 
	This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged,
confidential and exempt from disclosure under applicable law.  If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.  If you have received this
communication in error, please notify us immediately by email reply.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 04 2006 - 11:16:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US