[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

RMAN performance

Posted on 2012-03-19
6
Medium Priority
?
574 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month9 days, 3 hours left to enroll

590 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