Re: Rolling incremental backups & Compression

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 Mon Jun 11 2007 - 16:17:55 CDT