Oracle Rman错误 ORA-17629:/ORA-17627:/ ORA-01017:

[wyl43381998]

两边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

网上的方法尝试了很多哦，都未能解决，

[jdsnhan]

先看关键性信息，invalid username/password; logon denied。Cannot connect to the remote database server 数据库连接失败，肯定没办法执行rman啊。 在sqlplus 下 conn sys/root@orcl as sysdba conn sys/oracle@ORCL2 as sysdba 看是否能正确连通两个数据库

[wyl43381998]

引用 1 楼 jdsnhan 的回复:

先看关键性信息，invalid username/password; logon denied。Cannot connect to the remote database server 数据库连接失败，肯定没办法执行rman啊。 在sqlplus 下 conn sys/root@orcl as sysdba conn sys/oracle@ORCL2 as sysdba 看是否能正确连通两个数据库

可以正常连接的。而且rman也能连上

[wyl43381998]

引用 1 楼 jdsnhan 的回复:

先看关键性信息，invalid username/password; logon denied。Cannot connect to the remote database server 数据库连接失败，肯定没办法执行rman啊。 在sqlplus 下 conn sys/root@orcl as sysdba conn sys/oracle@ORCL2 as sysdba 看是否能正确连通两个数据库

这是在ORCL上连接ORCL2，没有问题，反过来也OK。RMAN能连接上，就不是这个问题了 [oracle@testdb ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 31 08:57:15 2016 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> conn sys/oracle@ORCL2 as sysdba Connected.

[土豆番茄]

楼主是要用热备份恢复做物理standby吗？

[jdsnhan]

参见官方文档： http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcnctg.htm#BRADV89382

[sxq129601]

不知道是不是不同操作系统并且位数不同导致的：最好还是64位的把，现在怎么还用32位 It is preferableto keep the same bit version when performing a restore/recovery. However,excluding the use of duplicate command, the use of the same operating systemplatform should allow for a restore/recovery between bit levels (32 bit or 64bit) of Oracle. Note, this may be specific to the particular operating system andany problems with this should be reported to Oracle Support. If you will berunning the 64-bit database against the 32-bit binary files or vice versa,after the recovery has ended the database bit version must be converted usingutlirp.sql.

[wyl43381998]

引用 5 楼 jdsnhan 的回复:

参见官方文档： http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcnctg.htm#BRADV89382

不行，linux是64位的，win是32位的。始终没有成功，最后我同事用backup先把主库备份之后，再使用rman传输以及dataguard的后续操作才成功，不知道是什么bug

[wyl43381998]

引用 4 楼 shanying_lv 的回复:

楼主是要用热备份恢复做物理standby吗？

是的呢