一个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.