ORA-15053: diskgroup “%s” contains existing files

http://inthirties.com:90/thread-1364-2-1.html

SQL> drop diskgroup dg1;
drop diskgroup dg1
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15053: diskgroup “DG1″ contains existing files

以前的asm盘已经带有了实例的文件，drop的时候出错。

[root@rac1 /]#oerr ORA 15053
15053, 00000, “diskgroup /”%s/” contains existing files”
// *Cause: An attempt was made to drop a diskgroup that still contains
// existing files.
// *Action: Specify the INCLUDING CONTENTS option to drop the diskgroup
// and all of its existing files.
//

加上including contents即可解决。
删除以后，原来的asm盘上的实例文件会全部都删除掉，然后我们创建新的diskgroup

先查询一下我们可以使用的的disk

SQL> select path, mount_status from v$asm_disk;

PATH MOUNT_STATUS
——————– ————–
/dev/rdsk/c3t4d0s4 CLOSED
/dev/rdsk/c3t4d0s6 CLOSED
/dev/rdsk/c3t3d0s1 CLOSED
/dev/rdsk/c3t2d0s1 CLOSED
/dev/rdsk/c3t4d0s5 CLOSED
/dev/rdsk/c3t4d0s3 CLOSED
/dev/rdsk/c3t4d0s1 CLOSED
7 rows selected.

其中的c3t2,ct3分别是ocr和votedisk，我们不再使用，c3t4规划为asm，

SQL>create diskgroup dg1 external redundancy disk ‘/dev/rdsk/c3t4d0s1′;
Diskgroup created.
SQL> alter diskgroup dg1 add disk ‘/dev/rdsk/c3t4d0s3′;
Diskgroup altered.
SQL> alter diskgroup dg1 add disk ‘/dev/rdsk/c3t4d0s4′;
Diskgroup altered.
SQL> alter diskgroup dg1 add disk ‘/dev/rdsk/c3t4d0s5′;
Diskgroup altered.
SQL> alter diskgroup dg1 add disk ‘/dev/rdsk/c3t4d0s6′;
Diskgroup altered.

再来查询一下disk

SQL> select path, mount_status from v$asm_disk;

PATH MOUNT_STATUS
——————– ————–
/dev/rdsk/c3t3d0s1 CLOSED
/dev/rdsk/c3t2d0s1 CLOSED
/dev/rdsk/c3t4d0s3 CACHED
/dev/rdsk/c3t4d0s1 CACHED
/dev/rdsk/c3t4d0s4 CACHED
/dev/rdsk/c3t4d0s6 CACHED
/dev/rdsk/c3t4d0s5 CACHED

disk已经mount叻

再来查看diskgroup
SQL> select name, state, total_mb, free_mb from v$asm_diskgroup;

NAME STATE TOTAL_MB FREE_MB
———————————————————— ———————- ———- ———-
DG1 MOUNTED 3858 3800

diskgroup已经mount了，可以为我们所用了。

• 提供Oracle管理/故障处理/优化/安装/RAC/备份恢复技术服务,提供专业的Oracle培训和咨询服务。
• 邮件: inthirties@gmail.com
• MSN: inthirties@hotmail.com
• QQ: inthirties@qq.com
• 电话: 13828706466