ITPub博客

首页 > 数据库 > Oracle > 使用rman命令报MAN-00554错误

使用rman命令报MAN-00554错误

原创 Oracle 作者:xueshancheng 时间:2021-08-15 19:48:03 0 删除 编辑

1 rman报错信息

$ rman

 

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jun 23 18:51:35 2014

 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-03000: recovery manager compiler component initialization failed

RMAN-06035: wrong version of recover.bsq, expecting 10.2.0.1, found 10.2.0.4


2 经过比对,发现两个节点的lib文件不一致,经咨询,应该是在几年前升级PSU导致的问题。

2009年12月28日做数据库升级,过程中有部分的功能升级失败,导致节点2的RMAN不能使用。

节点 1

-rwxr-x---   1 oracle     oinstall   36877360 Dec 28  2009 /oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1

$ -r-xr-xr-x   1 oracle     oinstall   5337112 Apr 22  2008 /oracle/oracle10g2r/dbs/lib/libnnz10.so

$ -r-xr-xr-x   1 bin        bin          85568 Feb 16  2007 /usr/lib/hpux64/librt.so.1

$ -r-xr-xr-x   1 bin        bin          91184 Jun  4  2009 /usr/lib/hpux64/libnss_dns.so.1

$ -r-xr-xr-x   1 bin        bin          78488 Jun  9  2009 /usr/lib/hpux64/libdl.so.1

$ -r-xr-xr-x   1 bin        bin        6580584 Dec  4  2008 /usr/lib/hpux64/libm.so.1

$ -r-xr-xr-x   1 bin        bin        1535512 Jun  6  2009 /usr/lib/hpux64/libpthread.so.1

$ -r-xr-xr-x   1 bin        bin         635200 Dec 13  2008 /usr/lib/hpux64/libunwind.so.1

$ -r-xr-xr-x   1 bin        bin        1510856 Jun  4  2009 /usr/lib/hpux64/libnsl.so.1

$ -r-xr-xr-x   1 bin        bin        4898536 Apr  8  2009 /usr/lib/hpux64/libc.so.1

$ -r-xr-xr-x   1 bin        bin          85568 Feb 16  2007 /usr/lib/hpux64/librt.so.1

$ -r-xr-xr-x   1 bin        bin          91184 Jun  4  2009 /usr/lib/hpux64/libnss_dns.so.1

$ -r-xr-xr-x   1 bin        bin          78488 Jun  9  2009 /usr/lib/hpux64/libdl.so.1

$ -r-xr-xr-x   1 bin        bin        6580584 Dec  4  2008 /usr/lib/hpux64/libm.so.1

$ -r-xr-xr-x   1 bin        bin        1535512 Jun  6  2009 /usr/lib/hpux64/libpthread.so.1

$ -r-xr-xr-x   1 bin        bin         635200 Dec 13  2008 /usr/lib/hpux64/libunwind.so.1

$ -r-xr-xr-x   1 bin        bin        1510856 Jun  4  2009 /usr/lib/hpux64/libnsl.so.1

$ -r-xr-xr-x   1 bin        bin          78488 Jun  9  2009 /usr/lib/hpux64/libdl.so.1

$ -r-xr-xr-x   1 bin        bin          85680 Feb 16  2007 /usr/lib/hpux64/libuca.so.1

 

节点 2

  -rwxr-xr-x   1 oracle     oinstall   36155448 Dec 26  2009 /oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1

$ -r-xr-xr-x   1 oracle     oinstall   5227072 Feb  4  2006 /oracle/oracle10g2r/dbs/lib/libnnz10.so

$ -r-xr-xr-x   1 bin        bin          85568 Feb 16  2007 /usr/lib/hpux64/librt.so.1

$ -r-xr-xr-x   1 bin        bin          91184 Jun  4  2009 /usr/lib/hpux64/libnss_dns.so.1

$ -r-xr-xr-x   1 bin        bin          78488 Jun  9  2009 /usr/lib/hpux64/libdl.so.1

$ -r-xr-xr-x   1 bin        bin        6580584 Dec  4  2008 /usr/lib/hpux64/libm.so.1

$ -r-xr-xr-x   1 bin        bin        1535512 Jun  6  2009 /usr/lib/hpux64/libpthread.so.1

$ -r-xr-xr-x   1 bin        bin         635200 Dec 13  2008 /usr/lib/hpux64/libunwind.so.1

$ -r-xr-xr-x   1 bin        bin        1510856 Jun  4  2009 /usr/lib/hpux64/libnsl.so.1

$ -r-xr-xr-x   1 bin        bin        4898536 Apr  8  2009 /usr/lib/hpux64/libc.so.1

$ -r-xr-xr-x   1 bin        bin          85568 Feb 16  2007 /usr/lib/hpux64/librt.so.1

$ -r-xr-xr-x   1 bin        bin          91184 Jun  4  2009 /usr/lib/hpux64/libnss_dns.so.1

$ -r-xr-xr-x   1 bin        bin          78488 Jun  9  2009 /usr/lib/hpux64/libdl.so.1

$ -r-xr-xr-x   1 bin        bin        6580584 Dec  4  2008 /usr/lib/hpux64/libm.so.1

$ -r-xr-xr-x   1 bin        bin        1535512 Jun  6  2009 /usr/lib/hpux64/libpthread.so.1

$ -r-xr-xr-x   1 bin        bin         635200 Dec 13  2008 /usr/lib/hpux64/libunwind.so.1

$ -r-xr-xr-x   1 bin        bin        1510856 Jun  4  2009 /usr/lib/hpux64/libnsl.so.1

$ -r-xr-xr-x   1 bin        bin          78488 Jun  9  2009 /usr/lib/hpux64/libdl.so.1

$ -r-xr-xr-x   1 bin        bin          85680 Feb 16  2007 /usr/lib/hpux64/libuca.so.1

 

发现节点 1和节点2上有部分的库文件不一致。

三 故障处理

1 关闭节点2数据库

 

2 在节点2上重命名文件:

$ mv /oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1 /oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1.bak623

$ mv /oracle/oracle10g2r/dbs/lib/libnnz10.so /oracle/oracle10g2r/dbs/lib/libnnz10.so.bak623

$ ls -l /oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1 /oracle/oracle10g2r/dbs/lib/libnnz10.so

/oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1 not found

/oracle/oracle10g2r/dbs/lib/libnnz10.so not found

$ ls -l /oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1.bak2014623 /oracle/oracle10g2r/dbs/lib/libnnz10.so.bak2014623

/oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1.bak2014623 not found

/oracle/oracle10g2r/dbs/lib/libnnz10.so.bak2014623 not found

$ ls -l /oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1.bak623 /oracle/oracle10g2r/dbs/lib/libnnz10.so.bak623

-rwxr-xr-x   1 oracle     oinstall   36155448 Dec 26  2009 /oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1.bak623

-r-xr-xr-x   1 oracle     oinstall   5227072 Feb  4  2006 /oracle/oracle10g2r/dbs/lib/libnnz10.so.bak623

 

3 登陆到节点1,拷贝节点1的文件到节点2

$ scp /oracleacle10g2r/dbs/lib/libclntsh.so.10.1 oracle@cwgkdb2:/oracle/oracle10g2r/dbs/lib

Password:

libclntsh.so.10.1                                                                                                                      100%   35MB  35.2MB/s  29.1MB/s   00:01    

$ scp /oracle/oracle10g2r/dbs/lib/libnnz10.so  oracle@cwgkdb2:/oracle/oracle10g2r/dbs/lib

Password:

libnnz10.so                                                                                                                            100% 5212KB   5.1MB/s   5.1MB/s   00:01    

$

 

 

$ ls -l  /oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1 /oracle/oracle10g2r/dbs/lib/libnnz10.so

-rwxr-x---   1 oracle     oinstall   36877360 Jun 23 19:55 /oracle/oracle10g2r/dbs/lib/libclntsh.so.10.1

-r-xr-xr-x   1 oracle     oinstall   5337112 Jun 23 19:55 /oracle/oracle10g2r/dbs/lib/libnnz10.so

 

4 启动数据库

startup

 

5 rman 验证

$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jun 23 19:56:10 2014

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

Connected to an idle instance.

 

SQL> startup

ORACLE instance started.

 

Total System Global Area 3.2212E+10 bytes

Fixed Size                  2213440 bytes

Variable Size            8561899968 bytes

Database Buffers         2.3606E+10 bytes

Redo Buffers               42598400 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

$ rman

 

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jun 23 19:56:59 2014

 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 

RMAN> exit

 

 

Recovery Manager complete.

$ rman target /

 

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jun 23 19:57:20 2014

 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 

connected to target database: CTESTPD (DBID=543556404)

 

RMAN> exit

 

 

Recovery Manager complete.




来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/69996316/viewspace-2787032/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
本人目前就职于北京海天起点技术服务有限股份公司,从事Oracle数据库有十几年了,对Oracle及goldengate比较精通。

注册时间:2021-03-11

  • 博文量
    43
  • 访问量
    11607