博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
rman catalog 问题:DBMS_RCVCAT version导致注册catalog失败
阅读量:2446 次
发布时间:2019-05-10

本文共 2810 字,大约阅读时间需要 9 分钟。

今天把主库PROD升级到了10.2.0.3.0,catalog的库还是保持10.2.0.1.0不变
然后在注册的时候报了如下错误。
export ORACLE_SID=PROD
[oracle@oel1 PROD]$ rman target / catalog
Recovery Manager: Release 10.2.0.3.0 - Production on Wed Oct 31 17:47:51 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: PROD (DBID=209955415)
connected to recovery catalog database
PL/SQL package RCUSER.DBMS_RCVCAT version 10.02.00.00 in RCVCAT database is not current
PL/SQL package RCUSER.DBMS_RCVMAN version 10.02.00.00 in RCVCAT database is not current
RMAN> show all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 10/31/2012 17:47:42
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1, column 2273:
PLS-00302: component 'GETRANGEALBACKUP' must be declared
ORA-06550: line 1, column 2238:
PL/SQL: Statement ignored
ORA-06550: line 1, column 2453:
PLS-00302: component 'RESTORECMD_T' must be declared
ORA-06550: line 1, column 2424:
PL/SQL: Statement ignored
需要来升级catalog
RMAN>
upgrade catalog;
recovery catalog owner is RCUSER
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN>
upgrade catalog;
recovery catalog upgraded to version 10.02.00.03
DBMS_RCVMAN package upgraded to version 10.02.00.00
DBMS_RCVCAT package upgraded to version 10.02.00.00
[oracle@oel1 PROD]$ rman target / catalog
Recovery Manager: Release 10.2.0.3.0 - Production on Wed Oct 31 17:52:10 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: PROD (DBID=209955415)
connected to recovery catalog database
RMAN> show all;
starting full resync of recovery catalog
full resync complete
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default
显示正常了。

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

转载于:http://blog.itpub.net/23718752/viewspace-748032/

你可能感兴趣的文章
Minecraft的官方网站分发了受恶意软件感染的皮肤
查看>>
word模板快速填内容_如何快速轻松地在Word中选择内容块
查看>>
如何在Word 2013中直接从一个表导航到另一个表
查看>>
twitch 录像_如何通过NVIDIA GeForce Experience将您的PC游戏玩法传送到Twitch
查看>>
linux gnome_在Gnome中学习这些鼠标技巧,以获得更高效的Linux体验
查看>>
打印机疑难解答_使用内置电源疑难解答改善Windows 7中的电池寿命
查看>>
drupal加密_立即更新您的Drupal网站,否则黑客可能将其变成加密货币矿工
查看>>
vimrc配置 鼠标光标_在“提示”框中:即时调整窗口大小,包含鼠标光标并了解电池配置...
查看>>
询问HTG:安装XBMC附加组件,缩小视频以进行移动播放,自动更改默认打印机
查看>>
High Sierra推出后如何离开macOS公开Beta
查看>>
如何格式化您的WhatsApp消息
查看>>
pixel2pixel_Pixel 2的视觉核心是什么?
查看>>
更改用户账户设置自动更改_您应该更改的5个SimpliSafe设置
查看>>
excel中转换为数值_如何在Microsoft Excel中转换货币
查看>>
netflix怎么上_如何在Netflix上隐藏电视节目和电影
查看>>
opera_从Opera快速拨号页上删除混乱
查看>>
apple pencil_如何在iPad Pro的Apple Pencil上双击动作
查看>>
linux使用命令重命名_如何在Linux上使用重命名命令
查看>>
xcloud下载_Project xCloud是Microsoft在流Xbox游戏上的赌博
查看>>
gpu驱动程序_如何从错误的GPU驱动程序更新中恢复
查看>>