Re: Backups versus snapshots
- From: Keith Moore <kmoore@xxxxxxxxxxxx>
- To: Seth Miller <sethmiller.sm@xxxxxxxxx>
- Date: Thu, 18 Sep 2014 17:39:55 -0500
Agreed. In this case they are proposing this for all Tier-1 systems, including
financial systems and I don’t think they appreciate the scenarios where there
could be significant data loss. Interestingly, the Tier-2 and Tier-3 systems
will be backed up as they are on a different architecture.
Keith
On Sep 18, 2014, at 12:06 PM, Seth Miller <sethmiller.sm@xxxxxxxxx> wrote:
> 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:
