afile copyRECID=9 STAMP=863257694 file name=/export/11g/oradata/orcl/example01.dbf Finished Duplicate Db at10-NOV-14
RMAN> exit
Recovery Managercomplete.
至此备库创建完成。
期间遇到很多的问题，现在总结如下：
1、执行[oracle@st dbs]rman target sys/oracle@orcl1 auxiliarysys/oracle@orcl2时候，提示不能连接到orcl1，但是能ping同pr，原来是防火墙没有开通过
2、tnsname.ora文件中service_name 与连接对端的监听中的service_name相对应。
3、备库中的配置了静态监听，具体原因参见：http://blog.itpub.net/23135684/viewspace-692707
4、执行duplicate target database for standby from active database nofilenamecheck;运行过程中出现了以下错误，是因为缺少文中的第四步，没有在备库上创建相应的目录。
| RMAN> duplicate target database for standby from active database;
Starting Duplicate Db at 10-NOV-14
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK ……省略 contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/export/11g/oradata/orcl/control01.ctl';
restore clone controlfile to '/export/11g/flash_recovery_area/orcl/control02.ctl' from
'/export/11g/oradata/orcl/control01.ctl';
}
executing Memory Script Starting backup at 10-NOV-14
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 11/10/2014 09:24:29
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/10/2014 09:24:29
ORA-17628: Oracle error 19505 returned by remote Oracle server |
5、执行duplicate target database for standby from active database nofilenamecheck;，运行过程中出现了以下错误，是因为没有使用nofilenamecheck。
| RMAN> duplicate target database for standby from active database; Starting Duplicate Db at 10-NOV-14
using channel ORA_AUX_DISK_1 …… …… 省略 contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script 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 11/10/2014 09:33:14
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /export/11g/oradata/orcl/example01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /export/11g/oradata/orcl/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /export/11g/oradata/orcl/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /export/11g/oradata/orcl/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /export/11g/oradata/orcl/system01.dbf conflicts with a file used by the target database |