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