Re: oracle 10g and oracle 9i RMAN

From: Bob Jones <email_at_me.not>
Date: Wed, 11 Jul 2007 02:39:07 GMT
Message-ID: <fpXki.38369$Um6.674@newssvr12.news.prodigy.net>

"sybrandb" <sybrandb_at_gmail.com> wrote in message news:1184064565.397918.36450_at_r34g2000hsd.googlegroups.com...
> On 10 jul, 12:39, peter <hhh.datab..._at_gmail.com> wrote:
>> According to oracle increment backup in oracle 10g RMAN is faster then
>> oracle 9i RMAN,
>> because after enable block change tracking... oracle starts recording
>> changes in blocks in a file.
>> But in oracle 9i also oracle record changes in database to REDO LOG
>> files and how is it different.
>
> The answer to this question is obvious (as with all of your questions,
> as you never RTFM and if you RTFM, don't try to *understand* the
> documentation).
> The redo log is a *chronological* collection of what Oracle calls
> change vectors.
> If you would need to determine which blocks have been changed since
> last backup, you *obviously* would have to scan through *ALL* redologs
> since last backup.
> The block change tracking file is a bitmapped file only stating the
> fact a specific block has changed.
>

Hmmm, I am sure you have RTFM. Does it really scan the redo logs? Received on Tue Jul 10 2007 - 21:39:07 CDT