查看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, 感谢原作者分享。
下载本文