ITPub博客

首页 > Linux操作系统 > Linux操作系统 > asm 小结

asm 小结

原创 Linux操作系统 作者:nokilled 时间:2008-03-24 23:17:03 0 删除 编辑

ORA-15000: command disallowed by current instance type

export ORACLE_SID=+ASM
select name,state from v$asm_diskgroup;

ALTER DISKGROUP dgroup1 MOUNT
ALTER DISKGROUP dgroup1 DISMOUNT;


create diskgroup dgroup1 normal redundancy
failgroup fgroup1 disk 'ORCL:VOL1','ORCL:VOL2'
failgroup fgroup2 disk 'ORCL:VOL3','ORCL:VOL4';

 

SQL> ALTER DISKGROUP dgroup1 dismount;

Diskgroup altered.

SQL>  select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
DGGROUP3                       MOUNTED
DGROUP1                        DISMOUNTED

SQL> ALTER DISKGROUP dgroup1 dismount;
ALTER DISKGROUP dgroup1 dismount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15001: diskgroup "DGROUP1" does not exist or is not mounted


SQL> alter diskgroup dgroup1 mount;

Diskgroup altered.

SQL>  select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
DGGROUP3                       MOUNTED
DGROUP1                        MOUNTED

SQL> alter diskgroup dggroup3 dismount;

Diskgroup altered.

SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
DGGROUP3                       DISMOUNTED
DGROUP1                        MOUNTED

SQL>  alter diskgroup dggroup3 mount;

Diskgroup altered.

SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
DGGROUP3                       MOUNTED
DGROUP1                        MOUNTED

SQL>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/46907/viewspace-217082/,如需转载,请注明出处,否则将追究法律责任。

下一篇: erp clone record
请登录后发表评论 登录
全部评论

注册时间:2007-12-30

  • 博文量
    108
  • 访问量
    284649