一次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/，如需轉載，請註明出處，否則將追究法律責任。