一个oracle8170数据库,在做rman恢复时遇到这个错误:
RMAN-03022: compiling command: resync
RMAN-03023: executing command: resync
RMAN-08002: starting full resync of recovery catalog
RMAN-01005: resync got ORA-1220, retrying with sort_area_size = 1MB
RMAN-08002: starting full resync of recovery catalog
RMAN-01005: resync got ORA-1220, retrying with sort_area_size = 2MB
RMAN-08002: starting full resync of recovery catalog
RMAN-01005: resync got ORA-1220, retrying with sort_area_size = 3MB
RMAN-08002: starting full resync of recovery catalog
RMAN-01005: resync got ORA-1220, retrying with sort_area_size = 4MB
RMAN-08002: starting full resync of recovery catalog
RMAN-01005: resync got ORA-1220, retrying with sort_area_size = 5MB
RMAN-08002: starting full resync of recovery catalog
RMAN-01005: resync got ORA--1220, giving up
.............................
解决方法：
通过加大SORT_AREA_RETAINED_SIZE and SORT_AREA_SIZE解决.
metalink的解释见： Note:119030.1.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/936/viewspace-60640/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 达梦数据库（DM7）条件语句和循环语句的几个简单的例子
- Hibernate一些问题
- logmnr简易操作说明
- Oracle8i: How to migrate LONG RAW to BLOB[from akadia]
- ora-01591
- ORA-02062: distributed recovery
- ora-00600[4097][],ora-00600[4194][4]
- Migration to 8i / 9i: Set "_SYSTEM_TRIG_ENABLED" to FALSE[akadia]
- Checking if LNS processes need to be shutdown
- 身陷十面埋伏的广东，在为谁哭泣？ [zt] ----“９＋２”泛珠三角，香港能救广东吗？
