RE: RMAN Compression verses cold

From: <>
Date: Tue, 15 Jan 2008 15:23:27 -0500
Message-ID: <>

Fyi: just in case I get answers, I will be off-site tomorrow and will not read them until Thursday.  

Thanks in advance though.  

Joel Patterson
Database Administrator
904 727-2546

From: [] On Behalf Of Sent: Tuesday, January 15, 2008 1:49 PM
Subject: RMAN Compression verses cold  

Just took a database from 1 hours cold backup to compressed RMAN hot backup that took 4 hours, (oracle version Only one backup so far. (one Disk Channel). BTW the cold backup 'compress'ed the files also ('*.Z').  

To continue comfortably, I'd about have to do a level 0 on a weekend and either a level 1 the rest of time, or the rest of the week and repeat, (or similar).  

I believe I should be able to pick this up in terms of time. Both backups were to internal drives, one mount point. Although a san could be in the future, not now, (db files go to san).  

I have R. Freemans book, (half way through), but would like a couple comments, or pages. First it seems odd to be so much longer during the same time period even if it is an entire backup.  

I noticed this on other databases as well.  

Joel Patterson
Database Administrator
904 727-2546

From: [] On Behalf Of Allen, Brandon Sent: Tuesday, January 15, 2008 1:04 PM
To:; Subject: RE: RMAN Compression experiences  

My only negative experience with it so far was that the restores took twice as long. This timing was pretty consistent through testing it about 5 times. This was with Oracle, AIX 5.3 and Netbackup 6.0. My backups were consistently faster and much smaller so that's great, but with the restores taking twice as long we decided it wasn't acceptable for our production database, but it's great for test & dev.  



Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

Received on Tue Jan 15 2008 - 14:23:27 CST

Original text of this message