恢复目录表空间满导致rman错误ORA-01654

查看rman脚本备份日志，发现如下错误: starting full resync of recovery catalogRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: =========

查看rman脚本备份日志，发现如下错误:

starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 10/10/2014 10:26:33
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 10/10/2014 10:26:33
ORA-01654: unable to extend index RMAN_USR.RLH_U1 by 128 in tablespace RMAN_TS

rman恢复目录所在表空间无法扩展

查看表空间利用率

SQL> SELECT * FROM dba_tablespace_usage_metrics ORDER BY used_percent DESC;

恢复目录所在表空间利用率已经达到96%

扩大数据文件大小

SQL> alter database datafile '/u01/oradata/catlogdb/rman01.dbf' resize 300M;

重新运行rman,问题解决。

===
一切拥有权力的人都有滥用权力为自己谋求私利的倾向；任何专制的国家的教育目的都是在极力降低国民的心智。 —— 孟德斯鸠

原文地址：恢复目录表空间满导致rman错误ORA-01654, 感谢原作者分享。