General
cancel
Showing results for 
Search instead for 
Did you mean: 

Bad Oracle Performance while database backup

Christian Marquardt_1
Regular Advisor

Bad Oracle Performance while database backup

Hello Guys,
we've done a DB restore to cooked filesystem. We've decided that it is more easily to manage the DB while residing in cooked fs then in rawdevices. After done the restore and start the first backup it takes almost TWO HOURS to write a 4,5GB backup to disk. The DB-files on a san-storage (EMC clarion). The backup-drive is another san-storage. If I try to put some data from /dev/zero to a file in the cooked fs everything works fine. Only the database performance is very bad!!! Can everyone have an idea what's going wrong? The HP/UX version is B.11.23 on Itanium.

kind regards
Christian
4 REPLIES
Steven E. Protter
Exalted Contributor

Re: Bad Oracle Performance while database backup

Shalom Christian,

1) Make sure a recent bi-annual patch ste is installed.
2) Make sure that oracle patches in addition to step 1 are installed. IF any were missing install them and relink oracle.
3) Have EMC check the cloning configuration of the disk array. If wrong it can massively impede performance.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Christian Marquardt_1
Regular Advisor

Re: Bad Oracle Performance while database backup

Hi Stephen,

thanks for your answer. I'll check the patches installed ...
I think everything is ok with EMC. If I use the dd everything works fine with a great performance.
Are there any relationships you know between async I/O and filesystem or are there any whitepapers how to setup an oracle DB an hp/ux cooked fs?

Christian
Rasheed Tamton
Honored Contributor

Re: Bad Oracle Performance while database backup

Hello Christian,

For everything related to Oracle and HP-UX. Please see the link

http://h71028.www7.hp.com/enterprise/cache/4281-0-0-0-121.html

Kind Regards,
Rasheed Tamton.
Eric Antunes
Honored Contributor

Re: Bad Oracle Performance while database backup

Hi Christian,

I suppose you are using about rman for backups? What is the database version and what are the non-default parameters (select name, value from v$parameter where isdefault = 'FALSE') values?

Best Regards,

Eric
Each and every day is a good day to learn.