Re: RMAN or Hot Backup
From: John Schaeffer <amerar_at_iwc.net>
Date: Fri, 3 Apr 2009 07:36:44 -0700 (PDT)
Message-ID: <80f09c7a-8913-4cd1-a6aa-ce917266b272_at_y9g2000yqg.googlegroups.com>
On Apr 2, 6:26 pm, johnbhur..._at_sbcglobal.net wrote:
> On Apr 2, 6:14 pm, rcyoung <rcyo..._at_aliconsultants.com> wrote:
>
> > If you put ALL your trust in any "hot backup" then you are asking for
> > trouble. Many times you can get by, but sooner or later you will run
> > into a problem that only a "cold backup" can resolve. To borrow some
> > lingo ...."Always have a COLD one on hand!".
>
> I would tend to agree if your recommendation was more like "when
> possible get a periodic cold backup" to complement the rest of your
> backup and recovery environment.
>
> I do get a cold one weekly on cloned disk space ... which could be
> used along with "all the archivelogs" ... but many people do not have
> either the disk space to hold a cold backup or the time to shutdown
> and start backup up.
Date: Fri, 3 Apr 2009 07:36:44 -0700 (PDT)
Message-ID: <80f09c7a-8913-4cd1-a6aa-ce917266b272_at_y9g2000yqg.googlegroups.com>
On Apr 2, 6:26 pm, johnbhur..._at_sbcglobal.net wrote:
> On Apr 2, 6:14 pm, rcyoung <rcyo..._at_aliconsultants.com> wrote:
>
> > If you put ALL your trust in any "hot backup" then you are asking for
> > trouble. Many times you can get by, but sooner or later you will run
> > into a problem that only a "cold backup" can resolve. To borrow some
> > lingo ...."Always have a COLD one on hand!".
>
> I would tend to agree if your recommendation was more like "when
> possible get a periodic cold backup" to complement the rest of your
> backup and recovery environment.
>
> I do get a cold one weekly on cloned disk space ... which could be
> used along with "all the archivelogs" ... but many people do not have
> either the disk space to hold a cold backup or the time to shutdown
> and start backup up.
Well, I am for RMAN, 100%. It just seems to take care of a lot of the BS, has great tracking of things, gives you great detail on what you have on file, and can do test restores and such to make sure you CAN restore, as well as other tools.......
While a hot backup can be done, I'm not sure if you can do incrementals or cumulatives with a hot backup.......if not, the worst case with a cumulative backup is the most recent level 0 (full) and the latest cumulative (level 1)...... Received on Fri Apr 03 2009 - 09:36:44 CDT