Weber, Philip wrote:
> Priatna wrote:
>> If we are using Advance Client along with Oracle agent to take RMAN 
>> incremental backup, does it _reads the entire file_ or it reads only the 
>> blocks that have changed? 
>> I didn't find the answer on the document.
>
> I believe so.  If you use rman to take an Oracle incremental level 1+ 
> backup, Oracle does the work to work out what data to send.  It sends 
> its data over the SAN rather than IP which should improve performance.  
> If you use block level incremental backups then it should improve 
> performance by only reading the changed blocks.  That's my understanding 
> anyway.

RMAN incremental backup only takses backup of the changed blocks not the 
entire file.

A level 0 incremental backup captures all the blocks in the datafiles. A 
level 1 incremental only captures the blocks that has been changed.
The level 1 can be cumulative or diffrensial.


-- 
Kai Stian Olstad