一则ORA-12528 問題處理

現象：所有鏈接的用戶端出現如下：

[img]http://note.youdao.com/yws/public/resource/0eda0015c5557e3f7961b9fb28aedad5/916B8442AE904FA99D8317E9D4B6EB40[/img]

aler.log 中記錄：
[img=636,301]http://note.youdao.com/yws/public/resource/0eda0015c5557e3f7961b9fb28aedad5/938DAC5AC256405FB93A12374CE67A79[/img]

分析：
應該是db_recovery_file_dest_size設置過小。查詢僅為4G,修改為20G,問題解決。

[img]http://note.youdao.com/yws/public/resource/0eda0015c5557e3f7961b9fb28aedad5/AC5239D838A74B3AA3F57D4C148C61F4[/img]
[img]http://note.youdao.com/yws/public/resource/0eda0015c5557e3f7961b9fb28aedad5/4E976A2A908640859F9D8B8357DDEB65[/img]
[img]http://note.youdao.com/yws/public/resource/0eda0015c5557e3f7961b9fb28aedad5/B5722E2B57B3449BBE27B9685EC9C02F[/img]

[p=21, null, left][color=rgb(70,70,70)]一.rman清除过期无效的归档日志

[color=rgb(70,70,70)][color=rgb(70,70,70)][size=14px]RMAN> configure retention policy to recovery window of 7 days; RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
[p=21, null, left][color=rgb(70,70,70)]释放的通道: ORA_DISK_1
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=652 devtype=DISK [p=21, null, left][color=rgb(70,70,70)]已存档的日志副本列表[p=21, null, left][color=rgb(70,70,70)]关键字 Thrd Seq S 短时间 名称
------- ---- ------- - ---------- ----
13 1 5440 X 22-4月 -10 /arp/oraarp/archive/1_5440_681226270.dbf
15 1 5441 X 22-4月 -10 /arp/oraarp/archive/1_5441_681226270.dbf[p=21, null, left][color=rgb(70,70,70)]是否确定要删除以上对象 (输入 YES 或 NO)?YES[p=21, null, left][color=rgb(70,70,70)]
[p=21, null, left][color=rgb(70,70,70)]二.增大 db_recovery_file_dest_size
select name,space_limit,space_used,number_of_files from v$recovery_file_dest;
alter system set db_recovery_file_dest_size=8G scope=both;

问题解决。
----------end---------