RE: Backups versus snapshots

From: Dimensional DBA <dimensional.dba_at_comcast.net>
Date: Thu, 18 Sep 2014 13:12:21 -0700
Message-ID: <00a701cfd37c$dc1542a0$943fc7e0$_at_comcast.net>

I agree with Kevin and IMHO that includes Data Dedupe backups and Incremental forever backups as being much more risky than real backups.    

Matthew Parker

Chief Technologist

425-891-7934 (cell)

Dimensional.dba_at_comcast.net

 <http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Closson (Redacted sender "ora_kclosson_at_yahoo.com" for DMARC)
Sent: Thursday, September 18, 2014 1:03 PM To: development_at_the-playground.de; dmarc-noreply_at_freelists.org; Seth Miller; kmoore_at_zephyrus.com
Cc: andrew.kerber_at_gmail.com; Oracle-L_at_freelists.org Subject: Re: Backups versus snapshots  

I'll try to be as succinct as I can. If you ever need to see your data again, do not trade anything for backups.    

---

From: Martin Bach <development_at_the-playground.de> To: dmarc-noreply_at_freelists.org; Seth Miller <sethmiller.sm_at_gmail.com>; "kmoore_at_zephyrus.com" <kmoore_at_zephyrus.com> Cc: "andrew.kerber_at_gmail.com" <andrew.kerber_at_gmail.com>; "Oracle-L_at_freelists.org" <oracle-l_at_freelists.org> Sent: Thursday, September 18, 2014 12:22 PM Subject: Re: Backups versus snapshots  

Just out of interest,

What happens in that case if you have to restore the database system to what it was last month to check if there was a data entry error? That kind of scenario, in addition to longer term archival (think regulators) are my concerns when thinking about snapshot only based approaches. Snapshots before software releases, end of year processing etc sound nice to me though.

Martin  

On 18 September 2014 20:46:47 CEST, Kevin Closson <dmarc-noreply_at_freelists.org> wrote:  

array snapshots that are crash consistent don't require the database to be in backup mode (all EMC and most all other array snap technology I know of are crash consistent)

---

From: Seth Miller <sethmiller.sm_at_gmail.com> To: kmoore_at_zephyrus.com
Cc: Kevin Closson <ora_kclosson_at_yahoo.com>; "andrew.kerber_at_gmail.com" <andrew.kerber_at_gmail.com>; "Oracle-L_at_freelists.org" <oracle-l_at_freelists.org>

Sent: Thursday, September 18, 2014 10:06 AM 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_at_zephyrus.com> 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_at_zephyrus.com>
> To: andrew.kerber_at_gmail.com
> Cc: "Oracle-L_at_freelists.org" <oracle-l_at_freelists.org>
> 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
>>
>
>
> --
> http://www.freelists.org/webpage/oracle-l

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



 

 


-- 
Martin Bach
Enkitec
martincarstenbach.wordpress.com <http://martincarstenbach.wordpress.com/> 

 



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

Received on Thu Sep 18 2014 - 22:12:21 CEST