• Pattern Matching Metacharacters For asm_diskstring


     

    This document will list the possible meta characters for asm_diskstring parameter

     

    Solution

    * and [] are the two valid meta characters for asm_diskstring parameter.

    SQL> alter system set asm_diskstring='/dev/raw/raw*' scope=both;
    System altered.

    SQL> select path from v$asm_disk;
    PATH
    --------------------------------------------------------------------------------
    /dev/raw/raw1
    /dev/raw/raw2
    /dev/raw/raw3
    /dev/raw/raw4
    /dev/raw/raw5
    /dev/raw/raw11
    /dev/raw/raw12
    /dev/raw/raw7
    /dev/raw/raw8
    /dev/raw/raw9
    /dev/raw/raw10
    /dev/raw/raw6

    12 rows selected.


    SQL> alter system set asm_diskstring='/dev/raw/raw[1-5]' scope=both;
    System altered.

    SQL> select path from v$asm_disk order by 1;
    PATH
    --------------------------------------------------------------------------------
    /dev/raw/raw1
    /dev/raw/raw2
    /dev/raw/raw3
    /dev/raw/raw4
    /dev/raw/raw5


    Characters like $ [0-9*] ^ _ etc would either give error, or will be ignored.


    SQL> alter system set asm_diskstring='/dev/raw/raw$' scope=both;

    alter system set asm_diskstring='/dev/raw/raw$' scope=both
    *
    ERROR at line 1:
    ORA-02097: parameter cannot be modified because specified value is invalid
    ORA-15031: disk specification '/dev/raw/raw$' matches no disks
    ORA-15056: additional error message

     

     

     

     

    From Oracle

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

    Blog http://blog.csdn.net/tianlesoftware

    Email: dvd.dba@gmail.com

    DBA1 群:62697716();   DBA2 群:62697977()   DBA3 群:62697850()  

    DBA 超级群:63306533();  DBA4 群: 83829929  DBA5群: 142216823   

    聊天 群:40132017   聊天2群:69087192

    --加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

    道森Oracle,国内最早、最大的网络语音培训机构,我们提供专业、优质的Oracle技术培训和服务! 我们的官方网站:http://www.daosenoracle.com 官方淘宝店:http://daosenpx.taobao.com/
  • 相关阅读:
    Ant简单工程的构建
    [转载] 无所不能的“蚂蚁”--Ant
    引体向上高级技巧:停顿式引体向上!
    引体向上腰酸?下背痛?你做对了吗?
    划船训练常见错误:含胸驼背肩胛骨活动不足
    引体向上
    仰卧飞鸟:仰卧哑铃飞鸟图解教程
    蝶机夹胸:蝴蝶机夹胸夹胸/飞鸟动作图解教程
    史密斯卧推:杠铃史密斯下斜卧推、上斜机卧推、平板卧推动作图解
    练胸秘籍:胸肌训练5大重点
  • 原文地址:https://www.cnblogs.com/tianlesoftware/p/3609711.html
Copyright © 2020-2023  润新知