设为首页 加入收藏

TOP

配置ORACLE11GADG(四)
2014-11-23 21:38:49 来源: 作者: 【大 中 小】 浏览:44次
Tags：配置 ORACLE11GADG
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
首页 上一页 1 2 3 4 下一页 尾页 4/4/4
【大 中 小】【打印】 【繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部】
分享到: 
上一篇：Oracle11g新特性系统分区表 下一篇：oracle触发器产生单据号

评论

帐　　号: 密码: (新用户注册)
验 证 码:
表　　情:
内　　容: