Antwort: SAN Config with ASM

From: Martin Klier <Martin.Klier_at_klug-is.de>
Date: Thu, 7 Jan 2010 14:52:28 +0100
Message-ID: <OF1D98A6DE.AEEA4BCD-ONC12576A4.004B6592-C12576A4.004C3751_at_klug-is.de>



Hi Bill,

I'd consider ASM as useful. It's simply flexible, and sometimes a bit nicer and quicker than anything else. And, you finally don't plug a file system layer between your DB and your media. If later migration is a possible scenario, ASM makes migrating from one storage to another quite simple, and sometimes it works without downtime to add/remove a volume physically and logically. If a downtime is needed, it comes from restrictions some OS have with adding/removing FC devices at runtime, but ASM can do it online and live.
The less your future SAN system can do, the more some ASM features are real benefits. For example, cross-site-replication or multi-host-to-multi-storage mirroring (RAC with ASM) are easily to build and operate.

One real CON of ASM is the trouble you have with split mirror backups for large datasets, ASM can't do that on its own, and I never tried it with a storage system that can do it in combination with ASM. Another small CON is, that you sometimes want to access data directly with OS tools (copy, edit, whatever). You can't do with ASM, but for all maintenance tasks there is a way to work on the ASM volume with all modern, nowadays really pretty RMAN versions .

Regards

--
Mit freundlichem Gruß


Martin Klier
Senior Oracle Database Administrator
------------------------------------------------------------------------------

Klug GmbH integrierte Systeme
Lindenweg 13, D-92552 Teunz
Tel.:  +49 9671/9216-245
Fax.: +49 9671/9216-112
mailto: martin.klier_at_klug-is.de
www.klug-is.de
------------------------------------------------------------------------------

Geschäftsführer: Johann Klug, Roman Sorgenfrei
Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608,
HRB Nr. 2037, Amtsgericht Amberg



|------------>
| Von: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------| |Bill Zakrzewski <bill_at_intactus.com> | >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| An: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------| |"Oracle-L_at_freelists.org" <oracle-l_at_freelists.org> | >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Datum: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------| |07.01.2010 13:42 | >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Betreff: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------| |SAN Config with ASM | >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Gesendet | | von: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------| |oracle-l-bounce_at_freelists.org | >--------------------------------------------------------------------------------------------------------------------------------------------------| We are looking to migrate into a 3rd party data center. The data center utilizes a SAN for all of its storage requirements (OS, database, backups). Oracle 10.2.0.4 RH Linux 5.x Does anyone have any experiences with configuring Oracle on a SAN? Will ASM be beneficial? Not sure how proactive the storage team will be at the 3rd party data center. Any PROs or CONs will be helpful. Thanks in advance, Bill -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 07 2010 - 07:52:28 CST

Original text of this message