Solved

RMAN performance

Posted on 2012-03-19
6
561 Views
Last Modified: 2012-03-30
We have an ASM database on a P780 AIX with almost 72 data files and the DB size now is 200 GB
The backup started to take almost 3 hours the I have started to allocate 16 channels as following

RUN {
allocate channel d1 type disk ;
allocate channel d2 type disk ;
allocate channel d3 type disk ;
allocate channel d4 type disk ;
allocate channel d5 type disk ;
allocate channel d6 type disk ;
allocate channel d7 type disk ;
allocate channel d8 type disk ;
allocate channel d9 type disk ;
allocate channel d10 type disk ;
allocate channel d11 type disk ;
allocate channel d12 type disk ;
allocate channel d13 type disk ;
allocate channel d14 type disk ;
allocate channel d15 type disk ;
allocate channel d16 type disk ;
backup check logical as compressed backupset tag='DBPRO_rmanbackup_compressed'
database filesperset 1 plus archivelog;
crosscheck backupset;
crosscheck copy;
crosscheck archivelog all;
delete noprompt expired backup ;
delete expired archivelog all;
delete noprompt obsolete;
}


How can we improve this to be faster ?
Can we use maxopenfiles here?
Is using filesperset 1 correct here?
0
Comment
Question by:it-rex
6 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37739231
Do you need to do a full backup every night?

I would suggest a rolling incremental with block change tracking:

4.4.3 Incrementally Updated Backups: Rolling Forward Image Copy Backups
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm

Then only blocks that have changed are backed up and the incremental is merged back into your level 0 (full) so you always have a full around.
0
 
LVL 11

Author Comment

by:it-rex
ID: 37739239
what if I want to improve this full backup.
before it used to be 1 channel and took 4 hours now with 16 channel  it went down to 1 and 40 minutes,I think we can do more.

thanks
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 200 total points
ID: 37739282
I've not messed a lot with tweaking a multiplexed backup.  I just do the rolling incremental and let RMAN take the defaults.

I would suggest you refer to the docs to answer your questions:

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#autoId15

Hopefully another Expert will stop by later that has done this.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 200 total points
ID: 37739347
...with almost 72 data files and the DB size now is 200 GB
That is an average of less than 3 GB per file!
Definitely try using a larger "files per set", perhaps 24 or more.

And if you have enough backup space, consider an "image copy" with daily incrementals.
Or...do the rolling incremental with block change tracking as slightwv suggest.

Also, instead of continuing to increase the number of data files in the database, increase the size of the existing files!
;)
0
 
LVL 47

Assisted Solution

by:schwertner
schwertner earned 100 total points
ID: 37744200
I guess you have reached the optimal speed of the backup for this 200 GB database.

To increase the speed use something like:

database filesperset 4

Next suggestion (if you can use independent devices outside the ASM):

Distribute the files accross devices:

http://www.dba-oracle.com/t_rman_distribute_backup_files.htm
0
 
LVL 11

Author Closing Comment

by:it-rex
ID: 37787291
Thanks all
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now