9 Replies Latest reply: May 29, 2013 12:41 AM by Billy~Verreynne RSS

    ASM & single instance

    1009809
      Hello

      ASM is usually used with RAC. Is ASM actually recommended for a single-instance (non-RAC)?

      Thanks
        • 1. Re: ASM & single instance
          AshishShukla
          Hello,

          ASM is recommended even for Single-Instance Database.

          Thanks,
          Ashish Shukla
          • 2. Re: ASM & single instance
            Mahir M. Quluzade
            1006806 wrote:
            Hello

            ASM is usually used with RAC. Is ASM actually recommended for a single-instance (non-RAC)?

            Thanks
            Hi,

            Oracle Recommended, use ASM for store your database files and you can use ASM for RAC and Single Instance Databases.

            Regards
            Mahir M. Quluzade
            • 3. Re: ASM & single instance
              Hemant K Chitale
              Yes, you can use ASM for Single Instance databases as well.

              Whether you choose to use ASM will depend on your DBA team's skill level, storage administration policies etc

              Hemant K Chitale
              • 4. Re: ASM & single instance
                rarain
                Hi,

                ASM features are not dependent on single Instance or RAC environment, You can also use ASM for single Instance for example let's say RAID is not implemented at storage level or probably its a JBOD storage, we can use ASM to stripe the data at diskgroup level for balancing I/O contention and can also use NORMAL redundancy diskgroup for data availability in case of disk faulty. From 11g onwards ASM has much broader scope like we have ACFS which can be use as normal general cluster file system to keep non-database files etc.

                Thanks
                • 5. Re: ASM & single instance
                  Billy~Verreynne
                  1006806 wrote:

                  ASM is usually used with RAC. Is ASM actually recommended for a single-instance (non-RAC)?
                  Simple, real world in my case, example of why ASM for a single instance. Small server. 3 SATA drives (e.g. 500GB and 2x1TB). 1st drive is the root drive (contains o/s and Oracle). 1TB drives as used as raw devices by ASM for a normal redundancy diskgroup (effectively providing a mirrored diskgroup for the database).

                  I have currently 3 such configurations/servers installed for a colleague.

                  ASM does not (only) make sense for RAC. It makes sense as Storage Manager for an Oracle database. Any Oracle database. Single. Or RAC. (the exception being Oracle XE as as XE does not include ASM as a freeware option).
                  • 6. Re: ASM & single instance
                    SAML.
                    Hi,

                    ASM is preferred for both RAC and non-RAC.

                    Cheers,
                    SAM L.
                    • 7. Re: ASM & single instance
                      startup
                      HI,

                      ASM is supportable for RAC and Non-RAC.This can be configured any platform of db.you can configure asm disk manually, tools(oracleasm).For more Information.
                      http://docs.oracle.com/cd/B28359_01/server.111/b31107/asmcon.htm
                      • 8. Re: ASM & single instance
                        onedbguru
                        Billy, just make sure you never go over 50% utilization on a 2-device system. If you lose a disk ASM is going to have a lot of fun getting ASM to provide mirrored blocks on the other remaining device.
                        • 9. Re: ASM & single instance
                          Billy~Verreynne
                          onedbguru wrote:
                          Billy, just make sure you never go over 50% utilization on a 2-device system. If you lose a disk ASM is going to have a lot of fun getting ASM to provide mirrored blocks on the other remaining device.
                          Hmm... something that I now must try to see just how bad it actually is. Now to find a spare server to abuse... :-)

                          Thanks.