ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 搭建dataguard时,错误处理

搭建dataguard时,错误处理

原创 Linux操作系统 作者:suifeng2316 时间:2013-01-16 17:29:38 0 删除 编辑

搭建dataguard的物理备库,容易出现以下错误,记录一下。

RMAN> duplicate target database for standby;

主库与备库的版本不一致,出现下列错误。

 主要是由于我主库的是10.2.0.1而现在建备库是,10.2.0.4的版本

Starting Duplicate Db at 16-JAN-13

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

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

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

RMAN-03002: failure of Duplicate Db command at 01/16/2013 15:06:58

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

RMAN> show all

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

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

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

RMAN-03002: failure of show command at 01/16/2013 15:12:29

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

备库初始化参数compatible=10.2.0.1.0没有设置,导致以下错误:

sql statement: alter database mount standby database

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

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

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

RMAN-03002: failure of Duplicate Db command at 01/16/2013 16:44:23

RMAN-03015: error occurred in stored script. Memory Script

RMAN-03009: failure of sql command on clone_default channel at 01/16/2013 16:44:23

RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database

ORA-00201: control file version 10.2.0.1.0 incompatible with ORACLE version 10.2.0.0.0

ORA-00202: control file: '/home1/passport/oradata/standby01.ctl'

 主库备库目录不一致,导致以下错误,解决办法,

1,  在备库创建与主库相同目录

2,  修改备库初始化参数 db_file_name_convert,,log_file_name_convert

released channel: ORA_AUX_DISK_1

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

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

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

RMAN-03002: failure of Duplicate Db command at 01/16/2013 16:48:27

RMAN-05501: aborting duplication of target database

RMAN-05001: auxiliary filename /home1/onlinelog/passportdb/undotbs01.dbf conflicts with a file used by the target database

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

请登录后发表评论 登录
全部评论

注册时间:2011-09-14

  • 博文量
    48
  • 访问量
    193122