Antwort: SAN Config with ASM
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 AmbergReceived on Thu Jan 07 2010 - 07:52:28 CST
|------------>
| 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