软件开发Oracle 12c

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

参与7

1同行回答

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

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

提问者

mashuaias
系统运维工程师华胜

相关问题

相关资料

问题状态

  • 发布时间:2017-12-21
  • 关注会员:1 人
  • 问题浏览:2287
  • 最近回答:2017-12-21
  • X社区推广