Re: block chg tracking

From: Kenny Payton <k3nnyp_at_gmail.com>
Date: Sat, 14 Feb 2015 06:48:20 -0500
Message-ID: <CAEidWqPuDsSYhUtrLKywS5NqquPN1uncYVSCkqDpqJ8J=rQhkA_at_mail.gmail.com>

We moved our local standby databases to netapp (any snapshot storage could suffice) and replaced RMAN backups with standby snapshots. This gives us image file full backups every two hours. It also removed the RMAN cpu/io from production.

We rely on autobackup for controlfile and spfile.

We also need to run occasional validates to catch any potential corruption.

Restore options are copy from image files or switch to copy and roll forward using archivelogs shipped and retained on the standby. Two hours of logs beats full or incr restores hands down. We could also take an immediate snap and reduce the roll forward to almost nothing.

Kenny

On Feb 13, 2015 7:50 PM, "Mladen Gogala" <dmarc-noreply_at_freelists.org> wrote:

> Ah yes, the good, old merge backup. However, it's cheating. One does not
> do "recover datafile" if the data file becomes corrupt, one does "switch
> datafile to copy" and then applies logs. Yes, I agree, that's the way of
> restoring incremental backups only. In addition to that, this will require
> a fairly large amount of storage. Device type SBT is still cheaper when it
> comes to storage.
>
>
> On 02/13/2015 03:17 PM, Seth Miller wrote:
>
> http://docs.oracle.com/database/121/ADMQS/backrest.htm#ADMQS0932
>
> Seth Miller
>
> On Fri, Feb 13, 2015 at 12:55 PM, Mladen Gogala <
> dmarc-noreply_at_freelists.org> wrote:
>
>> On 02/13/2015 01:48 PM, Seth Miller wrote:
>>
>>> If RTO is an issue how about a database backup that doesn't require a
>>> level 0 restore, only the the level 1's and the archive and redo logs.
>>>
>>> In fact, this is the default backup strategy for 12c.
>>>
>>> Seth Miller
>>>
>>>
>> Huh? You mean that in 12c it is possible to restore incremental backup,
>> without restoring the last full? Do you have a link to the place where I
>> could read about it? That looks mighty strange.
>>
>> --
>> Mladen Gogala
>> Oracle DBA
>> http://mgogala.freehostia.com
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> Mladen Gogala
> Oracle DBAhttp://mgogala.freehostia.com
>
>

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

Received on Sat Feb 14 2015 - 12:48:20 CET