搭建dataguard时,错误处理

搭建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

请使用浏览器的分享功能分享到微信等