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: RMAN question(s)

RE: RMAN question(s)

From: Peter McLarty <p.mclarty_at_cqu.edu.au>
Date: Tue, 18 Sep 2007 16:43:44 +1000
Message-ID: <27AA2E9CA7A0C44283BC1E9B00086AA908262185@UNIMAIL.staff.ad.cqu.edu.au>


With 1.2.0.3 databases we are running a lot of backups here with rman, we have ASM. We use compressed backups as we have observed similar results, the Peoplesoft demo database about 7GB reduces to around 770MB. these being backup up to an OCFS filesystem have consistently taken around 3:00 minutes.
Our copys of production rman is reporting as compressing from just under 48GB down to 8GB and running between 10 and 30 minutes to the same OCFS filesystem, most are at the lower end. Interestingly one backup up of the full database to tape took around 2hrs to a virtual tape library, it was uncompressed. We are doing these regular backups to disk as we lost faith in the backup software, It has many issues that we in teh project could not stomach for easy recovery  

We are using compressed as we find it faster, I think the smaller ones consistently took around 10 minutes without compression.  

I should be able to run some tests here, have to give it a spin and confirm the spped on a big database  

Cheers  

Peter    


From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Tuesday, 18 September 2007 11:33 AM To: Brandon.Allen_at_oneneck.com
Cc: robertgfreeman_at_yahoo.com; oracle-l_at_freelists.org Subject: Re: RMAN question(s)

On 9/17/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:

        In case anyone is interested - I did a test of the 10g "as compresssed"

        backupset on a 285GB databases and here are the results:         

	...
	So, I can't really make any conclusions on the backup time yet
due to 
	the large variance in backup times on this environment, but it's
clear
	that the space savings was significant (280-36=244 & 244/280=87%
	reduction) and the runtime from this one sample was close to the
bottom 
	of the normal range so that's promising.
	





--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 18 2007 - 01:43:44 CDT

Original text of this message

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