一次ASM空间满了的问题解决

环境

操作系统版本：IBM AIX on POWER Systems 5.3 (64-bit)

oracle版本: 10.2.0.3

现象

客户发现UAT环境应用连数据库连不上，通过VPN登陆到客户服务器，查看asm日志发现有以下报错

AMS alter log.

WARNING: allocation failure on disk FRAGRP_0001 for file 335 xnum 320

Fri Oct 21 09:48:08 2011

WARNING: allocation failure on disk FRAGRP_0001 for file 338 xnum 456

Fri Oct 21 09:48:08 2011

WARNING: allocation failure on disk FRAGRP_0001 for file 335 xnum 399

WARNING: allocation failure on disk FRAGRP_0000 for file 335 xnum 386

Fri Oct 21 09:48:09 2011

WARNING: allocation failure on disk FRAGRP_0001 for file 338 xnum 469

WARNING: allocation failure on disk FRAGRP_0001 for file 338 xnum 476

Fri Oct 21 09:48:10 2011

WARNING: allocation failure on disk FRAGRP_0001 for file 335 xnum 379

Fri Oct 21 09:48:10 2011

WARNING: allocation failure on disk FRAGRP_0000 for file 338 xnum 856

Fri Oct 21 09:48:11 2011

WARNING: allocation failure on disk FRAGRP_0001 for file 335 xnum 389

Fri Oct 21 09:48:11 2011

WARNING: allocation failure on disk FRAGRP_0001 for file 338 xnum 466

使用下面命令查看ASM磁盘情况

select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB,FREE_MB，usable_file_mb from v$asm_diskgroup;

发现存放archivelog 的ASMDiskGroup空间不够了

解决方案

1.使用rman清理掉archivelog，清理完之后不要忘记做全备

rman target /

delete archivelog all;

2.切换redo log

alter system switch logfile;

alter ssytem switch logfile;

3.重新看应用已经可以连接上了

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

转载于:http://blog.itpub.net/21605631/viewspace-710295/