Re: Backups versus snapshots
- From: Kenny Payton <k3nnyp@xxxxxxxxx>
- To: "Powell, Mark" <mark.powell2@xxxxxx>
- Date: Thu, 18 Sep 2014 14:33:43 -0400
I would not recommend this approach without replicating the snapshots to a
separate array.
Another option is something I'm doing, take snapshots of your physical
dataguard database and use it for your production database backups. You
can register the files with rman as image file backups. You can also use
the shipped archived logs during your recovery. I've got around 60T of
database being backed up this way and will more than double that next year.
You need to periodically scan your production copy for block corruption as
Kevin mentioned.
Kenny
On Thu, Sep 18, 2014 at 1:40 PM, Powell, Mark <mark.powell2@xxxxxx> wrote:
> It depends on whose snapshot technology is in use if the database in
> place in backup mode or not. One method would be to tell Oracle to suspend
> IO, make the snapshot or break the mirror, and then to resume IO in Oracle.
>
>
>
> http://docs.oracle.com/cd/E11882_01/server.112/e25494/start.htm#ADMIN11165
>
>
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Seth Miller
> *Sent:* Thursday, September 18, 2014 1:07 PM
> *To:* kmoore@xxxxxxxxxxxx
> *Cc:* Kevin Closson; andrew.kerber@xxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
>
> *Subject:* Re: Backups versus snapshots
>
>
>
> Is it safe to assume these snapshots are being taking with the database in
> backup mode?
>
>
>
> What is the procedure for restoring a non-critical datafile?
>
>
>
> What is the procedure for repairing block corruption?
>
>
>
> You don't have to be an old school DBA to have concerns about this. It's
> not necessarily a bad thing to not have backups as long as everyone
> involved is aware of and accepts the consequences and loss of functionality
> of not having them.
>
>
>
> Seth Miller
>
>
>
> On Thu, Sep 18, 2014 at 11:46 AM, Keith Moore <kmoore@xxxxxxxxxxxx> wrote:
>
> The purpose would be to have a backup if there is a catastrophic SAN
> failure.
> I know EMC and other storage vendors like to think that cannot happen but
> I've
> seen it four or five times over the years, mostly due to human error.
>
> Your database is gone which makes the snapshot (if it still exists)
> invalid.
>
> FYI, we will be using ExtremIO and there are a lot of good things about the
> VBlock. I'm just not comfortable with having zero backups.
>
> Keith
>
>
> > great thread.
> >
> > In this specific model would the purpose of RMAN backup to make sure
> you're
> > not backing up corrupt blocks?
> >
> >
> >
> >
> >
> >
> >
> > Kevin Closson
> > Chief Performance Architect - XtremIO
> > EMC
> >
> >
> > ________________________________
> > From: Keith Moore <kmoore@xxxxxxxxxxxx>
> > To: andrew.kerber@xxxxxxxxx
> > Cc: "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> > Sent: Thursday, September 18, 2014 9:17 AM
> > Subject: Re: Backups versus snapshots
> >
> >
> > I agree. They do not want to pay for the backup infrastructure so if
> that is
> > the final decision by the architecture team, rman backups will not be an
> > option.
> >
> >
> >
> >
> >> Keep snapshots and rman backups. Belt and suspenders.
> >>
> >> Sent from my iPhone
> >>
> >
> >
> > --
> > //www.freelists.org/webpage/oracle-l
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
