Well, say rather incrementals aren't used so much for DR anymore. Standbys are
more common for that, but if you do reach the point where your primary and all
standbys are gone, I, as a DBA, would want a technology that I am highly
experienced with, and understand well when I am working on a company's last
resort.
But really, the most commonly reason for rman full and incremental backups is
recovery from logical corruption caused by human error.
Sent from my iPad
On Nov 14, 2015, at 5:15 PM, Neil Chandler <neil_chandler@xxxxxxxxxxx> wrote:
Indeed.
This may sound dumb, but backups aren't really for recovery these days.
Business continuity - 24x7 and all that - means backups are generally
useless. The are for historic regulatory storage. They are for unmitigated
multi-site corruption. I haven't restored a backup to get a system back up
and running - with one weird, unusual but appropriate-for-the-business
exception where we didn't do regular backups - for well over a decade. Maybe
even 20 years. The last critical DB restore I recall was in 1997 for a large
German bank.
Now, you don't restore, you failover. Cluster, data guard, golden gate (a bit
data-lossy but fine for most).
The thought of having to restore tens of TB from compressed slow Sata disk.
*Shudder*
Neil Chandler
Oracle ACE
sent from my phone
On 14 Nov 2015, at 23:02, Tim Gorman <tim@xxxxxxxxx> wrote:
Over my past 16 years as a DBA consultant/contractor, incremental backups
have been very much in the majority. Some use cumulative incrementals, most
use differential incrementals. Many use BCT to make incrementals more
efficient. Many also backup DataGuard physical standbys, instead of the
primaries, although there are some RMAN bugs involved between 11.1.0.6 and
11.2.0.3.
Organizations with strict RTO and RPO objectives use DataGuard, GoldenGate,
or other replication options as the primary recovery method, with RMAN
restore/recovery as the last resort.
On 11/14/15 15:30, Andrew Kerber wrote:
That's about the same as my experience.
Sent from my iPad
On Nov 14, 2015, at 4:13 PM, Neil Chandler <neil_chandler@xxxxxxxxxxx>--
wrote:
I have worked for 5 corporations this year, small and huge. Oracle 10, 11
and 12. All of them used incremental backups.
Regards
Neil Chandler
Oracle ACE
sent from my phone
On 14 Nov 2015, at 17:48, Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:From consulting.
On 11/14/2015 08:38 AM, Andrew Kerber wrote:
am not sure where you get the idea that most places don't use
incremental backups. That is the opposite of my experience.
--
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com
--
//www.freelists.org/webpage/oracle-l
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
