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

Posted on Edited on In

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

1
2
3
4
5
6
7
8
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]
SQL> SELECT * FROM dba_tablespace_usage_metrics ORDER BY used_percent DESC;
[/sql]
恢复目录所在表空间利用率已经达到96%

扩大数据文件大小
[sql]
SQL> alter database datafile ‘/u01/oradata/catlogdb/rman01.dbf’ resize 300M;
[/sql]

重新运行rman,问题解决。

===
[erq]