oerr 错误 还有这个用处

FRA 空间经常由于各种原因导致空间不足，当空间超过80%后，发现不在自动清理
[oracle@stg201 ~]$ oerr ora 19822
19822, 00000, "mmon recovery area usage monitoring interval"
// *Document: NO
// *Cause:  Set on all instances to change recovery area usage monitoring
//          interval.
// *Action: level 1 - once every 15 minutes.
//          level 2 - once every 30 minutes.
//          ...
//          level n - once every n * 15 minutes.
[oracle@stg201]$oerr ora 19823
19823, 00000, "soft limit recovery area space pressure percentage"
// *Document: NO
// *Cause: Set on all instances to alter recovery area space pressure
//         trigger percentage.
// *Action: level 1 to 100 indicates the percentage when the space
//          pressure has to be triggered.
[oracle@stg201]$oerr ora 19824
19824, 00000, "amount of space in MB to be reclaimed on archiver IO error"
// *Document: NO
// *Cause: Set on all instances to alter recovery area reclaimation space
//         on archiver IO error.
// *Action: level indicates the amount in MB.


alter system set event='19823 trace name context forever,level 95' scope=spfile sid='*';

alter system set events '19823 trace name context forever, level 100';

alter system set events '19823 trace name context forever, level 50';
调整这个需要不停的alter system switch logfile  才能删除到50%