兩邊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
網上的方法嘗試了很多哦，都未能解決，
uj5u.com熱心網友回復：
先看關鍵性資訊，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
看是否能正確連通兩個資料庫
uj5u.com熱心網友回復：
可以正常連接的。而且rman也能連上uj5u.com熱心網友回復：
這是在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.
uj5u.com熱心網友回復：
樓主是要用熱備份恢復做物理standby嗎？uj5u.com熱心網友回復：
參見官方檔案：http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcnctg.htm#BRADV89382
uj5u.com熱心網友回復：
不行，linux是64位的，win是32位的。始終沒有成功，最后我同事用backup先把主庫備份之后，再使用rman傳輸以及dataguard的后續操作才成功，不知道是什么bug
uj5u.com熱心網友回復：
是的呢uj5u.com熱心網友回復：
不知道是不是不同作業系統并且位數不同導致的：最好還是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.
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/113598.html
標籤：基礎和管理
上一篇：oracle APEX 中item 設定為popup LOV型別，如何實作從表中獲取可選的VALUE值并可編輯添加新的值
下一篇：資料庫Oracle問題