Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 10g and oracle 9i RMAN

Re: oracle 10g and oracle 9i RMAN

From: sybrandb <sybrandb_at_gmail.com>
Date: Tue, 10 Jul 2007 03:49:25 -0700
Message-ID: <1184064565.397918.36450@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.

--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jul 10 2007 - 05:49:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US