Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    SOP-Inreasing The ASM Disk

    Uploaded by

    prasadramala
    This document provides steps to increase the available space on an ASM disk group for a Newsis database. It involves checking current disk group usage, identifying candidate disks that can be added, and using ALTER DISKGROUP to add the disks. This increases the total space of the disk group.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    SOP-Inreasing The ASM Disk

    Uploaded by

    prasadramala
    25 views5 pages
    This document provides steps to increase the available space on an ASM disk group for a Newsis database. It involves checking current disk group usage, identifying candidate disks that can be added, and using ALTER DISKGROUP to add the disks. This increases the total space of the disk group.

    Original Description:

    Original Title

    SOP-Inreasing the ASM Disk

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides steps to increase the available space on an ASM disk group for a Newsis database. It involves checking current disk group usage, identifying candidate disks that can be added, and using ALTER DISKGROUP to add the disks. This increases the total space of the disk group.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    25 views5 pages

    SOP-Inreasing The ASM Disk

    Uploaded by

    prasadramala
    This document provides steps to increase the available space on an ASM disk group for a Newsis database. It involves checking current disk group usage, identifying candidate disks that can be added, and using ALTER DISKGROUP to add the disks. This increases the total space of the disk group.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5

    SONY GDC-E(JP)Database Standard Operating Procedure-V 1.

    SOP – INCREASING THE ASM DISK

    Create By  Philbin Francis


    Reviewed By  Vinodh Lingesan
    Approved By  

    TCS –Sony Global Solutions Confidential June 5, 2014

    Page 1 of 5
    SONY GDC-E(JP)Database Standard Operating Procedure-V 1.8

    1 Introduction
    1.1 Purpose
    The purpose of this document is to explain the steps need to be followed to
    increase the ASM Disk group for Newsis

    1.2 Scope of Services


    If there is less space in the ASM disk then we need to follow below steps to
    increase the ASM DG for Newsis

    TCS –Sony Global Solutions Confidential June 5, 2014

    Page 2 of 5
    SONY GDC-E(JP)Database Standard Operating Procedure-V 1.8

    2. Steps need to be followed:

    1. Check for the current usage

    Switch to oragrid user

    Su – oragrid

    Open into ASMCMD module

    [oragrid@gepnis06:oragrid]$asmcmd

    ASMCMD> lsdg

    Offlin Voti
    Bloc Free_ Req_mir_fr Usable_fi e_disk ng_ Nam
    State Type Rebal Sector k AU Total_MB MB ee_MB le_MB s files e
    EXTER
    MOUNTED N N 512 4096 1048576 27786 84 0 84 0 N DG1/
    EXTER
    MOUNTED N N 512 4096 1048576 97251 99 0 99 0 N DG2/
    EXTER
    MOUNTED N N 512 4096 1048576 69465 237 0 237 0 N DG3/
    EXTER DGA
    MOUNTED N N 512 4096 1048576 13893 61 0 61 0 N RCH/
    DISK
    EXTER GPCL
    MOUNTED N N 512 4096 4194304 27784 1736 0 1736 0 Y U/

    Check for the disk which is assigned to each disk group

    ASMCMD> lsdsk -G DG1

    Path

    /dev/rhdisk16

    /dev/rhdisk7

    TCS –Sony Global Solutions Confidential June 5, 2014

    Page 3 of 5
    SONY GDC-E(JP)Database Standard Operating Procedure-V 1.8

    ASMCMD> lsdsk -G DG2

    Path

    /dev/rhdisk10

    /dev/rhdisk12

    /dev/rhdisk13

    /dev/rhdisk15

    /dev/rhdisk17

    /dev/rhdisk19

    /dev/rhdisk8

    ASMCMD> lsdsk -G DG3

    Path

    /dev/rhdisk11

    /dev/rhdisk14

    /dev/rhdisk18

    /dev/rhdisk20

    /dev/rhdisk9

    ASMCMD> lsdsk -G DGARCH

    Path

    /dev/rhdisk4

    ASMCMD> lsdsk -G DISKGPCLU

    Path

    /dev/rhdisk5

    /dev/rhdisk6

    TCS –Sony Global Solutions Confidential June 5, 2014

    Page 4 of 5
    SONY GDC-E(JP)Database Standard Operating Procedure-V 1.8

    2. Check for the disk details

    Switch to oragrid user

    Su – oragrid

    Login into SQLPLUS as sysasm

    [oragrid@gepnis06:oragrid]$sqlplus / as sysasm

    Check for the disk status “Candidate”. (Only the disk with header status can be allocated to
    ASM DISK)

    SQL> select OS_MB, PATH from v$asm_disk where HEADER_STATUS='CANDIDATE';

    OS_MB PATH

    ---------- ----------

    13893 /dev/rhdisk22

    13893 /dev/rhdisk21

    3. Adding unallocated disk to ASM Disk Group

    alter diskgroup DG2 add disk '/dev/rhdisk*21', '/dev/rhdisk*22';

    4. Check whether the DG space has increased


    Switch to oragrid user
    Su – oragrid
    Open into ASMCMD module
    [oragrid@gepnis06:oragrid]$asmcmd
    ASMCMD> lsdg

    TCS –Sony Global Solutions Confidential June 5, 2014

    Page 5 of 5

    You might also like