topic Re: Bad Oracle Performance while database backup in Operating System - HP-UX

Bad Oracle Performance while database backup

Christian Marquardt_1 — Wed, 11 Apr 2007 02:23:01 GMT

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

Re: Bad Oracle Performance while database backup

Steven E. Protter — Wed, 11 Apr 2007 02:33:48 GMT

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

Re: Bad Oracle Performance while database backup

Christian Marquardt_1 — Wed, 11 Apr 2007 02:42:53 GMT

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

Re: Bad Oracle Performance while database backup

Rasheed Tamton — Wed, 11 Apr 2007 03:02:34 GMT

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.

Re: Bad Oracle Performance while database backup

Eric Antunes — Wed, 11 Apr 2007 06:16:31 GMT

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