rman 登录失败 失败原因是创建了新数据库 导致的版本不一样 怎么修复这个问题呢?

Recovery Manager incompatible with TARGET database: RMAN 8.0.3.0 to 8.0.3.0 required
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06429: TARGET database is not compatible with this version of RMAN

1回答

ACDanteACDante  技术经理 , STARSINO
wuwenpingz_kevinyouyouwoxin888等赞同了此回答
1、“创建了新的数据库”这个描述--是指在原有数据库基础上新建了实例?还是对原有数据库进行了升级?还是在本机数据库去连接异机数据库?2、RMAN-06429报错,无法连接,可通过如下步骤确认:① 确认SQLPLUS和RMAN两条命令所在文件路径在同一目录下:已UNIX系统为例:$ which sqlplus$ ...显示全部

1、“创建了新的数据库”这个描述--是指在原有数据库基础上新建了实例?还是对原有数据库进行了升级?还是在本机数据库去连接异机数据库?
2、RMAN-06429报错,无法连接,可通过如下步骤确认:
① 确认SQLPLUS和RMAN两条命令所在文件路径在同一目录下:
已UNIX系统为例:
$ which sqlplus
$ which rman

②column comp_id format A10
column version like comp_id
column comp_name format A30
select comp_id, status, version, comp_name from dba_registry order by 1;

select OWNER, OBJECT_NAME, OBJECT_ID, OBJECT_TYPE, STATUS FROM dba_objects where status='INVALID';

For example, from the below, CAPROC has invalid database packages and types:

COMP_ID STATUS VERSION COMP_NAME


CATALOG VALID 11.2.0.3.0 Oracle Database Catalog Views
CATPROC INVALID 11.2.0.3.0 Oracle Database Packages and Types

SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE
, to_char(CREATED,'dd-mon-yyyy hh24:mi:ss') created
, to_char(LAST_DDL_TIME,'dd-mon-yyyy hh24:mi:ss') last_ddl_time
, TIMESTAMP
, STATUS
from dba_objects
where status = 'INVALID'
order by owner, object_name, object_type
/

Run utlrp.sql to recompile the objects:

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

===================================
以上解决方案参考至MOS Metlink:Note:1995192.1

收起
 2017-12-21
浏览577
aixchina 邀答

提问者

mashuaias系统运维工程师, 华胜

问题状态

  • 发布时间:2017-12-21
  • 关注会员:1 人
  • 问题浏览:841
  • 最近回答:2017-12-21
  • 关于TWT  使用指南  社区专家合作  厂商入驻社区  企业招聘  投诉建议  版权与免责声明  联系我们
    © 2019  talkwithtrend — talk with trend,talk with technologist 京ICP备09031017号-30