Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN question(s)
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-lReceived on Tue Sep 18 2007 - 01:43:44 CDT