Re: Backups versus snapshots
- From: Keith Moore <kmoore@xxxxxxxxxxxx>
- To: development@xxxxxxxxxxxxxxxxx
- Date: Thu, 18 Sep 2014 18:01:11 -0500
That’s an interesting question that I’ve asked as well. They have two business
units. One keeps backups for 30 days and then they are completely gone. The
other business unit keeps them for 10 days and then they are gone. We’ve been
asked to restore a copy of a database over 30 days old and had to tell them it
couldn’t be done. They now want to reduce the retention to 3 days using archive
logs which to me seems rather extreme.
I’ve asked before about keeping monthly and yearly copies, etc but never
received any response as to why the policy is what it is.
Keith
On Sep 18, 2014, at 2:22 PM, Martin Bach <development@xxxxxxxxxxxxxxxxx> wrote:
> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
