2 Replies Latest reply: Mar 13, 2014 10:30 AM by J.A. RSS

    ASM is down.

    1000268

      Hi All,

       

      I do not have ASM configured in my infra. I saw a question in web which asks----what would be the output of the below command when ASM is down?

       

      ASMCMD> lsdsk -l -d

       

      Could someone please help with the result?

       

      Also I have 1 more question.

       

      RMAN>VALIDATE DATABASE - what will this command do?

       

      I wrote in an exam that it would check corrupted blocks that are associated with datafile. Am I wrong?

       

      Regards

      Swapan

        • 1. Re: ASM is down.
          Vincent Li - Oracle

          Hi,

           

          Moved the discussion to RAC, ASM & Clusterware Installation.

           

          ---

          Vincent Li

          • 2. Re: ASM is down.
            J.A.

            Hi

             

            I send you the output BD and Grid 11gR2:

             

            ASMCMD> lsdsk

            Path

            /dev/oracleasm/disks/OCR_VOTE1

            /dev/oracleasm/disks/OCR_VOTE2

            /dev/oracleasm/disks/OCR_VOTE3

            /dev/oracleasm/disks/ORA_DAT1

            /dev/oracleasm/disks/ORA_DAT2

            /dev/oracleasm/disks/ORA_DAT_APP_DT1

            /dev/oracleasm/disks/ORA_DAT_APP_DT2

            /dev/oracleasm/disks/ORA_DAT_APP_DT3

            /dev/oracleasm/disks/ORA_DAT_UAT1

            /dev/oracleasm/disks/ORA_DAT_UAT2

            /dev/oracleasm/disks/ORA_DAT_UAT3

            /dev/oracleasm/disks/ORA_DAT_UAT4

            /dev/oracleasm/disks/ORA_DAT_UAT5

            /dev/oracleasm/disks/ORA_DAT_UAT6

            /dev/oracleasm/disks/ORA_DAT_UAT7

            /dev/oracleasm/disks/ORA_FRA1

            /dev/oracleasm/disks/ORA_FRA_APP_DT1

            /dev/oracleasm/disks/ORA_FRA_UAT1

            /dev/oracleasm/disks/ORA_FRA_UAT2

            ASMCMD>

            ASMCMD> lsdsk -l

            Unknown option: l

            usage: lsdsk [-kptgMI][-G diskgroup ] [--suppressheader] [ --member|--candidate] [--discovery][--statistics][pattern]

            help:  help lsdsk

            ASMCMD>

            ASMCMD> lsdsk -d

            Option d requires an argument

            usage: lsdsk [-kptgMI][-G diskgroup ] [--suppressheader] [ --member|--candidate] [--discovery][--statistics][pattern]

            help:  help lsdsk

            ASMCMD>

            ASMCMD>

            ASMCMD> lsdg

            State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

            MOUNTED  NORMAL  N         512   4096  1048576      3057     2131             1019             556              0             Y  OCR_VOTE/

            MOUNTED  EXTERN  N         512   4096  1048576    204796    77620                0           77620              0             N  ORA_DAT/

            MOUNTED  EXTERN  N         512   4096  1048576    716786   156178                0          156178              0             N  ORA_DAT_UAT/

            MOUNTED  EXTERN  N         512   4096  1048576    307194   106585                0          106585              0             N  ORA_APP_DT/

            MOUNTED  EXTERN  N         512   4096  1048576    102398    44541                0           44541              0             N  ORA_FRA/

            MOUNTED  EXTERN  N         512   4096  1048576    102398    91481                0           91481              0             N  ORA_FRA_APP_DT/

            MOUNTED  EXTERN  N         512   4096  1048576    204796    83332                0           83332              0             N  ORA_FRA_UAT/

            ASMCMD>

            ASMCMD> ls -l    

            State    Type    Rebal  Name

            MOUNTED  NORMAL  N      OCR_VOTE/

            MOUNTED  EXTERN  N      ORA_DAT/

            MOUNTED  EXTERN  N      ORA_DAT_UAT/

            MOUNTED  EXTERN  N      ORA_APP_DT/

            MOUNTED  EXTERN  N      ORA_FRA/

            MOUNTED  EXTERN  N      ORA_FRA_APP_DT/

            MOUNTED  EXTERN  N      ORA_FRA_UAT/

            ASMCMD>

            ASMCMD> ls -l -d

            +

            ASMCMD>

             

             

            On the other hand you can use the VALIDATE option of the BACKUP command to verify that database files exist and are in the correct locations, and have no physical or logical corruptions that would prevent RMAN from creating backups of them

             

            Example:

            BACKUP VALIDATE DATABASE ARCHIVELOG ALL;

             

            4.5 Using RMAN to Validate Database Files

            Regards