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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23073818/viewspace-752762/，如需轉載，請註明出處，否則將追究法律責任。