-bash-3.2$ rman target auxiliary nocatalog
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Aug 21 15:44:55 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: YHD (DBID=529155495)
using target database control file instead of recovery catalog connected to auxiliary database: YHD (not mounted)RMAN> duplicate target database for standby from active database;
Starting Duplicate Db at 21-AUG-12
allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=243 device type=DISKcontents of Memory Script:
{ backup as copy reuse targetfile '/home/oracle/product/11203/db1/dbs/orapwyhd' auxiliary format '/data/oracle/product/11203/db1/dbs/orapwyhd' ; } executing Memory ScriptStarting backup at 21-AUG-12
allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=3 device type=DISK Finished backup at 21-AUG-12contents of Memory Script:
{ backup as copy current controlfile for standby auxiliary format '/data/oradata/yhdpri/control01.ctl'; restore clone controlfile to '/data/oradata/yhdpri/control02.ctl' from '/data/oradata/yhdpri/control01.ctl'; } executing Memory ScriptStarting backup at 21-AUG-12
using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/21/2012 15:45:09 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/21/2012 15:45:09 ORA-17628: Oracle error 19505 returned by remote Oracle server--之后还是报错:
RMAN> duplicate target database for standby from active database;
Starting Duplicate Db at 21-AUG-12
using channel ORA_AUX_DISK_1contents of Memory Script:
{ backup as copy reuse targetfile '/home/oracle/product/11203/db1/dbs/orapwyhd' auxiliary format '/data/oracle/product/11203/db1/dbs/orapwyhd' ; } executing Memory ScriptStarting backup at 21-AUG-12
using channel ORA_DISK_1 Finished backup at 21-AUG-12contents of Memory Script:
{ backup as copy current controlfile for standby auxiliary format '/data/oradata/yhdpri/control01.ctl'; restore clone controlfile to '/data/oradata/yhdpri/control02.ctl' from '/data/oradata/yhdpri/control01.ctl'; } executing Memory ScriptStarting backup at 21-AUG-12
using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy copying standby control file output file name=/home/oracle/product/11203/db1/dbs/snapcf_yhd.f tag=TAG20120821T160149 RECID=12 STAMP=791913709 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 21-AUG-12Starting restore at 21-AUG-12
using channel ORA_AUX_DISK_1 DBGSQL: TARGET> begin :fhdbi := dbms_rcvcat.getDbid; end; DBGSQL: sqlcode = 6550 DBGSQL: B :fhdbi = 32767 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/21/2012 16:02:27 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-06550: line 1, column 17: PLS-00201: identifier 'DBMS_RCVCAT.GETDBID' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignoredRMAN>
如果使用的是非catalog,在rman 连接时,加上nocatalog关键字,否则就是上面的错误..