两边oracle是同版本11.2.0的,但平台一个是redhat 一个window。
[oracle@testdb ~]$ rman target sys/root@orcl auxiliary sys/oracle@ORCL2
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 28 14:52:32 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1451001194)
connected to auxiliary database: ORCL (not mounted)
RMAN> duplicate target database for standby from active database;
Starting Duplicate Db at 28-OCT-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=193 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format
'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ;
}
executing Memory Script
Starting backup at 28-OCT-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=191 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/28/2016 14:56:00
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/28/2016 14:56:00
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server
RMAN> duplicate target database for standby from active database;
Starting Duplicate Db at 28-OCT-16
using channel ORA_AUX_DISK_1
contents of Memory Script:
{
backup as copy reuse
targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format
'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ;
}
executing Memory Script
Starting backup at 28-OCT-16
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/28/2016 15:05:13
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/28/2016 15:05:13
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server网上的方法尝试了很多哦,都未能解决,
[oracle@testdb ~]$ rman target sys/root@orcl auxiliary sys/oracle@ORCL2
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 28 14:52:32 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1451001194)
connected to auxiliary database: ORCL (not mounted)
RMAN> duplicate target database for standby from active database;
Starting Duplicate Db at 28-OCT-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=193 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format
'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ;
}
executing Memory Script
Starting backup at 28-OCT-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=191 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/28/2016 14:56:00
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/28/2016 14:56:00
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server
RMAN> duplicate target database for standby from active database;
Starting Duplicate Db at 28-OCT-16
using channel ORA_AUX_DISK_1
contents of Memory Script:
{
backup as copy reuse
targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format
'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ;
}
executing Memory Script
Starting backup at 28-OCT-16
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/28/2016 15:05:13
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/28/2016 15:05:13
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server网上的方法尝试了很多哦,都未能解决,
解决方案 »
- [Help]如何根据不同月份来读写不同的数据表?
- 关于存储过程在同一环境下执行效率时快时慢的解决方法,请高手指教!在线等
- 有一个项目要把SQL Server2000数据库迁移到Oracle中
- 如果一个表只有两个字段,但是两个字段都是外键行吗?(在oracle中建表时遇到的问题)
- 批量更新的问题
- 大家(特别是高手)都来谈谈自己的ORACLE历程吧,交流经验,相互促进,共同提高!(我散100)
- ??非常棘手的问题:从SqlServer2000中往Oracle中倒入数据表,可是在Oracle上查询表的时候说这个对象不存在??
- 哪位高人能介绍一下sum() 后面的over()的用法
- oracle安装的时候的小问题
- 求版面上的一篇关于oracle和其他几种数据库讨论的帖子!!!
- 急急急,麻烦大家帮我看下为什么提交任务不成功,提示数字溢出!
- 包体中,两个相同结构的游标如何进行合并,及再查询之类的?
数据库连接失败,肯定没办法执行rman啊。
在sqlplus 下conn sys/root@orcl as sysdba
conn sys/oracle@ORCL2 as sysdba
看是否能正确连通两个数据库
[oracle@testdb ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 31 08:57:15 2016Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> conn sys/oracle@ORCL2 as sysdba
Connected.
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcnctg.htm#BRADV89382
不行,linux是64位的,win是32位的。始终没有成功,最后我同事用backup先把主库备份之后,再使用rman传输以及dataguard的后续操作才成功,不知道是什么bug