Re: Top (=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS
Title: Re: Top (=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS NAS mistakes: Not dedicating two (or more) network segments to NAS access only, segregated from other uses Should you just plug a NAS into a general-purpose LAN and start connecting servers to it? Why would more than one network port on a server using NAS storage be a good idea? Why are two (or more, not one) dedicated network segments a good idea? Not placing data structures like online redo logfiles, RBS/UNDO datafiles, lkDBNAME file, and at least one controlfile on direct-attach HDD or SAN If there is a policy to place all corporate data on the shared storage (NAS), then surely redo, RBS/UNDO etc should not be considered corporate data Often, the lkDBNAME mount lock file in the $ORACLE_HOME/dbs directory should be placed on direct-attach HDD or SAN, else ORA-27086 can happen Oracle documentation mentions resolution of ORA-27806 by running unlocking commands on NetApps console, but the best solution is prevention... Not placing file-systems like user home directories, ORACLE_HOME, admin/log/trc, APPL_TOP, etc on the NAS and placing heavily-accessed datafiles on direct-attach HDD or SAN Why not place low-demand file-systems on the lower-performance storage and high-demand file-systems on higher-performance storage? My $0.02... on 9/25/03 11:59 AM, Gaja Krishna Vaidyanatha at [EMAIL PROTECTED] wrote: Fellow Listers, If you don't deal with Oracle databases on SAN/NAS environments, this posting may not interest you. If so, my apologies, please delete this. Otherwise, please read on. In an effort to better understand what issues you face when deploying an Oracle database in a SAN/NAS environment, I am writing to you to get some real life feedback. Although I have a fair idea, where some of the pain lies, it would be much more valuable if you could tell me. Kind of like From the horse's mouth..;-) And I truly meant that as a compliment...:-) My goal is to fully understand where the real pain lies, so that appropriate solutions can be built to alleviate or even eliminate the pain. You can be as broad or narrow in your responses using the following topics as guidelines: * Initial SAN/NAS Configuration for Database Creation and Application Deployment * Ongoing Storage Volume Management in a SAN/NAS * Ongoing Storage Administration (Growth, Resizing) * Performance Optimization Troubleshooting * Things that require automation * Anything else you think is important that I have missed I do really appreciate you taking the time to put your feedback in black and white. Those of you who take the time and effort to provide feedback, will be entered in a raffle to for some T-shirts and other freebies. Oh, BTW, when you do send your response, please provide your full contact information, so that I know where to mail the goodies. In the interest of not flooding the list, please send me your feedback directly to [EMAIL PROTECTED] As a courtesy to my fellow listers, I will collate all responses and post a summary in the near future. You can count on me to do that. Best regards, Gaja = Gaja Krishna Vaidyanatha | E-Mail: [EMAIL PROTECTED] Principal Technical Product Manager | Phone: (650)-527-3180 Application Performance Management | Web: http://www.veritas.com Veritas Corporation | __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
Re: Top (=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS
I would still rank undo redologs together with regular data because they're crucial for survivability and consistency ofinformation... Tanel. If there is a policy to place all corporate data on the shared storage (NAS), then surely redo, RBS/UNDO etc should not be considered corporate data Often, the lkDBNAME mount lock file in the $ORACLE_HOME/dbs directory should be placed on direct-attach HDD or SAN, else ORA-27086 can happen Oracle documentation mentions resolution of ORA-27806 by running unlocking commands on NetApps console, but the best solution is prevention... Not placing file-systems like user home directories, ORACLE_HOME, admin/log/trc, APPL_TOP, etc on the NAS and placing heavily-accessed datafiles on direct-attach HDD or SAN Why not place low-demand file-systems on the lower-performance storage and high-demand file-systems on higher-performance storage?
Top (=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS
Fellow Listers, If you don't deal with Oracle databases on SAN/NAS environments, this posting may not interest you. If so, my apologies, please delete this. Otherwise, please read on. In an effort to better understand what issues you face when deploying an Oracle database in a SAN/NAS environment, I am writing to you to get some real life feedback. Although I have a fair idea, where some of the pain lies, it would be much more valuable if you could tell me. Kind of like From the horse's mouth..;-) And I truly meant that as a compliment...:-) My goal is to fully understand where the real pain lies, so that appropriate solutions can be built to alleviate or even eliminate the pain. You can be as broad or narrow in your responses using the following topics as guidelines: * Initial SAN/NAS Configuration for Database Creation and Application Deployment * Ongoing Storage Volume Management in a SAN/NAS * Ongoing Storage Administration (Growth, Resizing) * Performance Optimization Troubleshooting * Things that require automation * Anything else you think is important that I have missed I do really appreciate you taking the time to put your feedback in black and white. Those of you who take the time and effort to provide feedback, will be entered in a raffle to for some T-shirts and other freebies. Oh, BTW, when you do send your response, please provide your full contact information, so that I know where to mail the goodies. In the interest of not flooding the list, please send me your feedback directly to [EMAIL PROTECTED] As a courtesy to my fellow listers, I will collate all responses and post a summary in the near future. You can count on me to do that. Best regards, Gaja = Gaja Krishna Vaidyanatha| E-Mail: [EMAIL PROTECTED] Principal Technical Product Manager | Phone: (650)-527-3180 Application Performance Management | Web: http://www.veritas.com Veritas Corporation | __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Top (=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS
Hi, gaja I post the feedback to list and hope others can also cc a copy to the list so that we share our experience. My small database runs on a small basic san: two database on V880/E4500 and two standby server , share a storage which is consistent of 4*Sun T3, with 2 FC-switch. Our pains we suffer: 1. Must have DMP or something like that configured. Or one path fail, database fail. Controller fail is not someting rare.We have an 2 hours outage once because of failed controller on T3 and unproper DMP config. 2.We have raid10 for production and raid5 for standby database. 3.Sun T3(under control of VxVM/VXFS) is really poor in disk performance.We have 9(4-4 mirror, one standby) as raid1 with 1G cache.300+random IO(blocksize 8k) satured the storage.90+% busy and iowait 30+% 4. SAN Zone is not configured here and all server can see all the disks. This gives flexible control but harder to manage. 5. Our basic SAN is not a really SAN. We still use one server to have exclusive control of one T3.So , some T3 are extreme busy while other T3 are basicaly idle. THis waste resource.But as we do not have another software layer, we used SAN just for Failover, any host can take over any storage. Regrads Zhu Chao. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 26, 2003 2:59 AM Fellow Listers, If you don't deal with Oracle databases on SAN/NAS environments, this posting may not interest you. If so, my apologies, please delete this. Otherwise, please read on. In an effort to better understand what issues you face when deploying an Oracle database in a SAN/NAS environment, I am writing to you to get some real life feedback. Although I have a fair idea, where some of the pain lies, it would be much more valuable if you could tell me. Kind of like From the horse's mouth..;-) And I truly meant that as a compliment...:-) My goal is to fully understand where the real pain lies, so that appropriate solutions can be built to alleviate or even eliminate the pain. You can be as broad or narrow in your responses using the following topics as guidelines: * Initial SAN/NAS Configuration for Database Creation and Application Deployment * Ongoing Storage Volume Management in a SAN/NAS * Ongoing Storage Administration (Growth, Resizing) * Performance Optimization Troubleshooting * Things that require automation * Anything else you think is important that I have missed I do really appreciate you taking the time to put your feedback in black and white. Those of you who take the time and effort to provide feedback, will be entered in a raffle to for some T-shirts and other freebies. Oh, BTW, when you do send your response, please provide your full contact information, so that I know where to mail the goodies. In the interest of not flooding the list, please send me your feedback directly to [EMAIL PROTECTED] As a courtesy to my fellow listers, I will collate all responses and post a summary in the near future. You can count on me to do that. Best regards, Gaja = Gaja Krishna Vaidyanatha| E-Mail: [EMAIL PROTECTED] Principal Technical Product Manager | Phone: (650)-527-3180 Application Performance Management | Web: http://www.veritas.com Veritas Corporation | __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
