- Community Home
- >
- Storage
- >
- Entry Storage Systems
- >
- Disk Enclosures
- >
- create an oracle database on a 12H autoraid
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2000 03:40 AM
тАО08-02-2000 03:40 AM
create an oracle database on a 12H autoraid
On this array we have created an Oracle database with a total storage of 35 Gb. The database is spread over two LUNS whith crossed primary / alternate SCSI controllers. This work fine, but after checking de autoraid performance logging with arraydsp en logprint i saw something strange. The working set ratio had a max of 6.2 and in the logprint-info i saw that the raid 1 capacity is far behind the working set amount. My guess is, that the autoraid writes data default to raid 5 when the working set ratio is above 1 and that it does not use the unallocated space if this occures.
My question is now. Has anyone deal with this and can someone tell what i must do too get de database in default raid 1 and which autoraid settings i mayby give another value. Please tell me this.
extra info: We must put all of the database on the autoraid. There is now no other way.
Cees Wielink
Netherlands
- Tags:
- Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2000 04:47 AM
тАО08-02-2000 04:47 AM
Re: create an oracle database on a 12H autoraid
/opt/hparray/bin/arraydsp -r 07010000 08010000 XXXXXXXX
07010000 - from July 1 at midnight
08010000 - to Aug. 1 at midnight
XXXXXXXX - array serial number from /opt/hparray/bin/arraydsp -i
Brian
<*(((>< er
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2000 06:28 AM
тАО08-02-2000 06:28 AM
Re: create an oracle database on a 12H autoraid
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2000 08:23 AM
тАО08-02-2000 08:23 AM
Re: create an oracle database on a 12H autoraid
You state you've created a two LUN-volume on the AutoRAID but you don't mention how big this volume is. With 12 18Gb disk at hand, with active hot spare on, you should have a maximum of 158Gb at your disposal. Make sure you have plenty of space left for your Oracle DBMS.
Concerning your problem:
If you look at the AutoRAID, are both LED's of the controllers active. And how active are the LED's of the harddisks.
Also, could it be possible you have just installed this configuration and maybe restored the data from tape. In that case the AutoRAID will be working hard for a long time to adjust internally to what it will consider to be the best performance-oriented configuration.
You might want to look at iostat or Glance to see how much activity is going on on your volumes (read/writes). If all activity is on the AutoRAID, then it's the AutoRAID at work. You can also check this with the Arraydsp -m command. If the Working Set and Through Put is very high (like yours) but the SCSI Q is (relatively) within specs it's definitily the AutoRAID reconfiguring itself. In the past, I've head the Working Set reach a peak as high as 30 after reconfiguration of the AutoRAID.
BTW, if the AutoRAID is reconfiguring itself, it should not take longer than about 24 hours at most (this is an estimate).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-03-2000 01:19 PM
тАО08-03-2000 01:19 PM