| How Long Will A Full Rman Compressed Backup Take Given The Following Specs [message #644790] |
Tue, 17 November 2015 22:18  |
 |
juniordbanewbie
Messages: 250
Registered: April 2014
|
Senior Member |
|
|
Dear all,
I've a new customer that has the following specifications
cpu specifications
oracle@chicago-db ~]$ lscpu
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) per core: 1
Core(s) per socket: 4
Socket(s): 2
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 63
Model name: Intel(R) Xeon(R) CPU E5-2698 v3 @ 2.30GHz
Stepping: 2
CPU MHz: 2297.339
BogoMIPS: 4594.67
Hypervisor vendor: VMware
Virtualization type: full
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 40960K
NUMA node0 CPU(s): 0-7
memory specifications
[oracle@chicago-db ~]$ grep MemTotal /proc/meminfo
MemTotal: 32782580 kB
[oracle@chicago-db ~]$ grep SwapTotal /proc/meminfo
SwapTotal: 2097148 kB
ie. a memory of 31 GB
Linux specifications
[root@chicago-db ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.1 (Maipo)
[root@chicago-db ~]#
It is also a VMWARE machine
[root@chicago-db ~]# dmidecode -s system-manufacturer
VMware, Inc.
They are currently in archive mode, but I was surprise to know that no backup has been done yet!
Size of DB is 1.4 Terabyte. Archive Log currently occupied 80G. Maximum archive log growth is 22 GB/hour. More recently archive log growth is 400 M/hour. SGA is 805M, PGA target is 268M and Maximum PGA allocated is 473M
The most relevant forum post is http://www.orafaq.com/forum/t/140962/
Quote:
Do a compressed Level 0 Backup on Sunday (This will take roughly 6 hours) to do a complete backup with 4 disk channels allocated to it.
But unfortunately my client is using a Standard Edition, ie. I cannot have 4 channels running at the same time. Other conditions are different too. so maybe based on experience, how long will a compressed rman full backup take? If I based on the above logic does that means that my full rman compressed backup will take 4*6 hours, i.e 24 hours?
thanks and many thanks!
|
|
|
|
|
|
|
|
| Re: How Long Will A Full Rman Compressed Backup Take Given The Following Specs [message #644801 is a reply to message #644792] |
Wed, 18 November 2015 01:30  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Quote:My supervisor is asking me to find out how long it took based on feedback and experience.
As you do not have any feedback and experience of this system, you had better get some. Do a backup, see how long it takes. Or backup just a few datafiles, and extrapolate. Your supervisor will not have a problem with you saying "I don't know, but I'll find out".
|
|
|
|
| Re: How Long Will A Full Rman Compressed Backup Take Given The Following Specs [message #644831 is a reply to message #644792] |
Wed, 18 November 2015 08:17 |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
juniordbanewbie wrote on Tue, 17 November 2015 23:12 I have not done a backup yet. My supervisor is asking me to find out how long it took based on feedback and experience.
There are simply too many variables for anyone else's experience to have significant meaning for your system.
That said,with much fear that you will read too much into it, I'll tell you that I have a 1TB database, 11.2.0.4 StdEd (so, like you, no parallel options) that takes about 13 hours to run my weekly level 0 compressed backup.
Like John said, backup one one file (one of the larger ones) and see how long that takes, then extrapolate.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
