Re: RMAN or Hot Backup

From: Bob Jones <email_at_me.not>
Date: Sat, 11 Apr 2009 12:27:27 -0500
Message-ID: <3q4El.11996$jZ1.8205_at_flpi144.ffdc.sbc.com>


<johnbhurley_at_sbcglobal.net> wrote in message news:ce5dc836-055f-4b77-af0f-9313ca6ed146_at_f25g2000vbf.googlegroups.com... On Apr 10, 9:21 pm, "Bob Jones" <em..._at_me.not> wrote:

snip

>> - 1. More redo is generated. This can be an issue on a system that
>> - generates lots of redo to begin with.
>>
>> Just make sure I hear this correctly. Non-RMAN backups cause more redo to 
>> be
>> generated?

> Bob you are making me nervous here.

> It is hard to understand how someone who apparently has some amount of
> experience and some amount of responsibilities for oracle systems does
> not understand this point and why.

Understand what? Non-RMAN backups have to be hot backups?

> The implications of putting a semi active or active oracle database
> system into backup mode ( either the whole database or piece by
> piece ) on the generation of online log activity has been well
> understood for 10 years and more.

So your conclusion is that all non-RMAN backups must generate more redo logs.

> It is certainly for many people still running non rman hot backups
> "tolerable" additional activiity but it is not exactly something new.
> Gotta think this was in the 7.3 Loney Oracle DBA book ...

You are completely off topic. Received on Sat Apr 11 2009 - 12:27:27 CDT

Original text of this message