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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rolling incremental backups & Compressio

Re: Rolling incremental backups & Compressio

From: John Darrah <darrah.john_at_gmail.com>
Date: Tue, 12 Jun 2007 14:57:36 -0600
Message-ID: <ec40ac060706121357o2275db4bla7400b8975a721a@mail.gmail.com>


It does not roll the copy foreword by using archive logs, it takes incremental changes from the datafiles and applies them to the copy. You are correct though, they cannot be compressed.

On 6/11/07, Valentin Minzatu <valentinminzatu_at_yahoo.com> wrote:
>
> As far as I know, 'BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY' rolls
> forward the image copy by applying the archived redo logs to the backup
> image - pretty much like a physical standby - and it is not stored as a
> separate backup, so you cannot compress it. You may want as a safety net to
> create additional backup sets which can be compressed.
>
> Valentin
>
>
>
> ----- Original Message ----
> From: Don Seiler <don_at_seiler.us>
> To: oracle_l <oracle-l_at_freelists.org>
> Sent: Monday, June 11, 2007 5:00:05 PM
> Subject: Rolling incremental backups & Compression
>
> Afternoon everyone. I'm on Oracle 10.2.0.2 on RHEL3.
>
> I'm exploring the option of using the "rolling forward image copy"
> method of incremental backups with RMAN, as detailed in section 4.4.3
> of of Backup and Recovery Basics guide [1].
>
> I know that the initial backup will be an image copy, and therefore
> not compressed. My question is: can the subsequent level 1
> incremental backups be compressed backupsets?
>
> [1]
> http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup004.htm
>
> --
> Don Seiler
> oracle blog: http://ora.seiler.us
> ultimate: http://www.mufc.us
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 12 2007 - 15:57:36 CDT

Original text of this message

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