【Oracle】rman upgrade catalog
Oracle RMAN upgrade catalog
2023-09-14 08:57:29 时间
因为数据库从11.2.0.2 升级到 11.2.0.3,在使用catalog 执行rman备份的时候,报如下错误:
oracle@rac1 rman target / catalog rman/xxxxx@rman
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Jun 13 22:31:07 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: RAC (DBID=12029485965)
connected to recovery catalog database
PL/SQL package RMAN_ALIBANK.DBMS_RCVCAT version 11.02.00.01 in RCVCAT database is not current
PL/SQL package RMAN_ALIBANK.DBMS_RCVMAN version 11.02.00.01 in RCVCAT database is not current
RMAN
RMAN
RMAN show all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 06/13/2012 22:31:23
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 06/13/2012 22:31:23
RMAN-10015: error compiling PL/SQL program
RMAN-10014: PL/SQL error 0 on line 1655 column 12: Statement ignored
RMAN-10014: PL/SQL error 306 on line 1655 column 12: wrong number or types of arguments in call to CHECKTABLESPACE
RMAN exit 因为catalog 数据的版本低于执行rman的数据库版本,所以报如上错误!我们要执行upgrade catalog 来更新catalog!按照官方文档的描述“ Note that UPGRADE CATALOG does not run scripts to perform. the upgrade. Instead, RMAN sends various SQL DDL statements to the recovery catalog to update the recovery catalog schema with new tables, views, columns, and so forth. ” upgrade 命令本身并步执行真正的升级而是执行一下ddl 语句 修改catalog 用户下的表,字段等等!
oracle@rac1 rman target / catalog rman/xxxxx@rman
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Jun 13 22:46:49 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: RAC (DBID=12029485965)
connected to recovery catalog database
PL/SQL package RMAN_ALIBANK.DBMS_RCVCAT version 11.02.00.01 in RCVCAT database is not current
PL/SQL package RMAN_ALIBANK.DBMS_RCVMAN version 11.02.00.01 in RCVCAT database is not current
RMAN upgrade catalog;
recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN UPGRADE CATALOG
recovery catalog upgraded to version 11.02.00.03
DBMS_RCVMAN package upgraded to version 11.02.00.03
DBMS_RCVCAT package upgraded to version 11.02.00.03
RMAN 执行 upgrade catalog 命令要注意: a) You must be connected to the catalog database, and the catalog database must be open. You do not have to be connected to the target database. b) You must enter the UPGRADE command twice in a row to confirm the upgrade. c) You will receive an error if the recovery catalog is already at a version greater than needed by the RMAN executable. RMAN permits the command to be run if the recovery catalog is already current, however, so that the packages can be re-created if necessary. RMAN displays all error messages generated during the upgrade in the message log. 11g upgrade catalog 的官方文档
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Jun 13 22:31:07 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: RAC (DBID=12029485965)
connected to recovery catalog database
PL/SQL package RMAN_ALIBANK.DBMS_RCVCAT version 11.02.00.01 in RCVCAT database is not current
PL/SQL package RMAN_ALIBANK.DBMS_RCVMAN version 11.02.00.01 in RCVCAT database is not current
RMAN
RMAN
RMAN show all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 06/13/2012 22:31:23
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 06/13/2012 22:31:23
RMAN-10015: error compiling PL/SQL program
RMAN-10014: PL/SQL error 0 on line 1655 column 12: Statement ignored
RMAN-10014: PL/SQL error 306 on line 1655 column 12: wrong number or types of arguments in call to CHECKTABLESPACE
RMAN exit 因为catalog 数据的版本低于执行rman的数据库版本,所以报如上错误!我们要执行upgrade catalog 来更新catalog!按照官方文档的描述“ Note that UPGRADE CATALOG does not run scripts to perform. the upgrade. Instead, RMAN sends various SQL DDL statements to the recovery catalog to update the recovery catalog schema with new tables, views, columns, and so forth. ” upgrade 命令本身并步执行真正的升级而是执行一下ddl 语句 修改catalog 用户下的表,字段等等!
oracle@rac1 rman target / catalog rman/xxxxx@rman
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Jun 13 22:46:49 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: RAC (DBID=12029485965)
connected to recovery catalog database
PL/SQL package RMAN_ALIBANK.DBMS_RCVCAT version 11.02.00.01 in RCVCAT database is not current
PL/SQL package RMAN_ALIBANK.DBMS_RCVMAN version 11.02.00.01 in RCVCAT database is not current
RMAN upgrade catalog;
recovery catalog owner is RMAN
enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN UPGRADE CATALOG
recovery catalog upgraded to version 11.02.00.03
DBMS_RCVMAN package upgraded to version 11.02.00.03
DBMS_RCVCAT package upgraded to version 11.02.00.03
RMAN 执行 upgrade catalog 命令要注意: a) You must be connected to the catalog database, and the catalog database must be open. You do not have to be connected to the target database. b) You must enter the UPGRADE command twice in a row to confirm the upgrade. c) You will receive an error if the recovery catalog is already at a version greater than needed by the RMAN executable. RMAN permits the command to be run if the recovery catalog is already current, however, so that the packages can be re-created if necessary. RMAN displays all error messages generated during the upgrade in the message log. 11g upgrade catalog 的官方文档
相关文章
- ORA-02809: Jump buffer not valid ORACLE 报错 故障修复 远程处理
- ORA-14320: DEFAULT cannot be specified for ADD/DROP VALUES or SPLIT ORACLE 报错 故障修复 远程处理
- Oracle 视图 V$TOPLEVELCALL 官方解释,作用,如何使用详细说明
- Oracle角色管理技巧:提升效率和安全性(oracle角色管理)
- SQL和Oracle教程:掌握计算机数据库的基础知识(sql教程oracle)
- 使用Oracle模式轻松实现跨越国际的数据连接(oracle模式)
- Oracle字符串格式化:轻松提高数据效率(oracle字符串格式化)
- 表达式正则表达式:Oracle中的纯数字(oracle纯数字正则)
- 的优化让Oracle生产环境性能更上一层楼(oracle生产环境)
- 权限赋予Oracle:为所有子节点授予权限(oracle所有子节点)
- 精通Oracle触发器的类型知识(oracle触发器类型)
- 深入探究Oracle分析函数的使用方法与技巧(oracle分析函数详解)
- 解密Oracle查询索引的秘密(查询索引oracle)
- Oracle数据库:是否需要付费?(oracle是收费的吗)
- Oracle迁移表:实现数据转换的关键之一(oracle迁移表)
- Oracle工具的比较及优劣势分析(oracle 工具 比较)
- 如何使用Oracle建立序列(oracle怎么建序列)
- 我的Oracle入职之路第三方挑战(oracle入职第三方)
- CMD操作如何连接Oracle数据库(cmd咋连接oracle)
- Java程序建立Oracle数据库表的实现方式(java建oracle表)
- 行版之外Oracle除发行版以外的更多选择(oracle中的除发)
- Oracle余额精准计算保证价值最大化(oracle余额计算)
- 使用Oracle RMAN提高数据库备份效率(oracle之rman)
- Oracle数据库中字符串型主键的研究(oracle主键字符串)
- 使用RMAN更好地管理Oracle(oracle使用rman)
- Oracle中如何有效分配表空间(oracle中分配表空间)
- 值查询查询Oracle中两表不同的值(oracle中两表不同)