[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

RMAN performance

Posted on 2012-03-19
6
Medium Priority
?
572 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 78

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 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 800 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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 800 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 48

Assisted Solution

by:schwertner
schwertner earned 400 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses

825 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