Home » RDBMS Server » Backup & Recovery » How Long Will A Full Rman Compressed Backup Take Given The Following Specs (11.2.0.1 Standard Edition, Red Hat Enterprise Linux Server release 7.1 (Maipo))
How Long Will A Full Rman Compressed Backup Take Given The Following Specs [message #644790] Tue, 17 November 2015 22:18 Go to next message
juniordbanewbie
Messages: 217
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 #644791 is a reply to message #644790] Tue, 17 November 2015 22:33 Go to previous messageGo to next message
BlackSwan
Messages: 26204
Registered: January 2009
Location: SoCal
Senior Member
During RMAN backup which system resource (CPU, RAM, Disk, or Network) bottlenecks first?
What is maximum transfer rate the system can sustain writing to Disk sub-system?
Re: How Long Will A Full Rman Compressed Backup Take Given The Following Specs [message #644792 is a reply to message #644791] Tue, 17 November 2015 23:12 Go to previous messageGo to next message
juniordbanewbie
Messages: 217
Registered: April 2014
Senior Member
[root@chicago-db ~]# dd if=/dev/sdg of=/tmp/sdg.img bs=8k count=256k
262144+0 records in
262144+0 records out
2147483648 bytes (2.1 GB) copied, 23.4797 s, 91.5 MB/s

should be about 90Mb/s


During RMAN backup which system resource (CPU, RAM, Disk, or Network) bottlenecks first? I have not done a backup yet. My supervisor is asking me to find out how long it took based on feedback and experience.

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 Go to previous messageGo to next message
John Watson
Messages: 7620
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 Go to previous message
EdStevens
Messages: 985
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.

Previous Topic: Restore database using datafile control file and Redo Logfile
Next Topic: Implications Of A Full Monthly Backup And Recovery Windows of 7 Days
Goto Forum:
  


Current Time: Sun Oct 21 01:48:56 CDT 2018