RE: RMAN question(s)
- From: "Peter McLarty" <p.mclarty@xxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>, <Brandon.Allen@xxxxxxxxxxx>
- Date: Tue, 18 Sep 2007 16:43:44 +1000
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@xxxxxxxxx]
Sent: Tuesday, 18 September 2007 11:33 AM
To: Brandon.Allen@xxxxxxxxxxx
Cc: robertgfreeman@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN question(s)
On 9/17/07, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> 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.
Other related posts:
