Using the My Oracle Support Portal (MOSC)

MOSC Banner

alert+ASM.log

Comments

  • user13133086
    user13133086 Posts: 4 Blue Ribbon
    edited Sep 24, 2012 6:57PM
    asm instance is not normal, pls help me, thanks 

    +ASM Instance infos:

    epxort ORACLE_SID=+ASM

    GROUP_NUMBER DISK_NUMBER STATE            NAME            PATH
    ------------ ----------- ---------------- --------------- --------------------------------------------------
               0         0 NORMAL                       /dev/rhdisk10
               0          21 NORMAL                           /dev/rhdisk9
               0           2 NORMAL                           /dev/rhdisk12
               0           3 NORMAL                           /dev/rhdisk13
               0           4 NORMAL                           /dev/rhdisk15
               0           5 NORMAL                           /dev/rhdisk16
               0           6 NORMAL                           /dev/rhdisk17
               0           7 NORMAL                           /dev/rhdisk18
               0           8 NORMAL                           /dev/rhdisk19
               0           9 NORMAL                           /dev/rhdisk2
               0          10 NORMAL                           /dev/rhdisk20
               0          11 NORMAL                           /dev/rhdisk21
               0          12 NORMAL                           /dev/rhdisk22
               0          13 NORMAL                           /dev/rhdisk23
               0          14 NORMAL                           /dev/rhdisk24
               0          15 NORMAL                           /dev/rhdisk3
               0          16 NORMAL                           /dev/rhdisk4
               0          17 NORMAL                           /dev/rhdisk5
               0          18 NORMAL                           /dev/rhdisk6
               0          19 NORMAL                           /dev/rhdisk7
               0          20 NORMAL                           /dev/rhdisk8
               0         1 NORMAL                       /dev/rhdisk11

    SQL> select group_number,name,state from v$ASM_diskgroup;
    GROUP_NUMBER NAME            STATE
    ------------ --------------- ----------------------
               0 FRA_DG          DISMOUNTED
               0 MPDB_DG         DISMOUNTED

    ORACLE Instance infos:

    epxort ORACLE_SID=mpdb

    SQL> select group_number,name,state,free_mb, total_mb from v$ASM_diskgroup;

    GROUP_NUMBER NAME                 STATE
    ------------ -------------------- -----------
               1 FRA_DG               CONNECTED
               2 MPDB_DG              CONNECTED

    SQL> select group_number,disk_number,state,name,path from v$asm_disk;

    GROUP_NUMBER DISK_NUMBER STATE    NAME                 PATH
    ------------ ----------- -------- -------------------- --------------------------------------------------
               2           0 NORMAL   MPDB_DG_0000         /dev/rhdisk19
               2           1 NORMAL   MPDB_DG_0001         /dev/rhdisk2
               1           0 NORMAL   FRA_DG_0000          /dev/rhdisk10
               1           1 NORMAL   FRA_DG_0001          /dev/rhdisk11

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center