ORA-17629:rman建立 standby資料庫時報錯
[oracle@oelora ~]$ rman target / auxiliary sys/oraclesys@oelora2
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jul 24 21:36:45 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: OELORA (DBID=1818030427)
connected to auxiliary database: OELORA2 (not mounted)
duplicate target database for standby nofilenamecheck
from active database
dorecover
SPFILE
SET db_unique_name = 'oelora2'
SET log_archive_dest_1 = 'LOCATION=/u01/flash_recovery_area/OELORA/archivelog/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'
SET log_archive_dest_2 = 'SERVICE=oelora REOPEN=60 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oelora'
SET fal_client = 'oelora2'
SET fal_server = 'oelora'
10> SET control_files = '/u01/oradata/oelora2/control01.ctl',' /u01/flash_recovery_area/oelora2/control02.ctl';
Starting Duplicate Db at 2013/07/24 21:37:08
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwoelora' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwoelora2' targetfile
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoelora.ora' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoelora2.ora' ;
sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoelora2.ora''";
}
executing Memory Script
Starting backup at 2013/07/24 21:37:09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/24/2013 21:37:10
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
continuing other job steps, job failed will not be re-run
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/24/2013 21:37:11
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/24/2013 21:37:11
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@oelora ~]$ rman target sys/oraclesys auxiliary sys/oraclesys@oelora2
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jul 24 21:36:45 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: OELORA (DBID=1818030427)
connected to auxiliary database: OELORA2 (not mounted)
duplicate target database for standby nofilenamecheck
from active database
dorecover
SPFILE
SET db_unique_name = 'oelora2'
SET log_archive_dest_1 = 'LOCATION=/u01/flash_recovery_area/OELORA/archivelog/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'
SET log_archive_dest_2 = 'SERVICE=oelora REOPEN=60 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oelora'
SET fal_client = 'oelora2'
SET fal_server = 'oelora'
10> SET control_files = '/u01/oradata/oelora2/control01.ctl',' /u01/flash_recovery_area/oelora2/control02.ctl';
Starting Duplicate Db at 2013/07/24 21:37:08
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwoelora' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwoelora2' targetfile
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoelora.ora' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoelora2.ora' ;
sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoelora2.ora''";
}
executing Memory Script
Starting backup at 2013/07/24 21:37:09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/24/2013 21:37:10
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
continuing other job steps, job failed will not be re-run
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/24/2013 21:37:11
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/24/2013 21:37:11
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
解決方法:
登陸時使用使用者名稱加密碼方式登陸本地庫。不能用OS驗證。[oracle@oelora ~]$ rman target sys/oraclesys auxiliary sys/oraclesys@oelora2
相關文章
- 利用RMAN建立STANDBY資料庫資料庫
- 使用rman建立standby資料庫資料庫
- 使用RMAN建立物理Standby資料庫資料庫
- RMAN duplicate 建立standby RAC資料庫資料庫
- 【RMAN】在備庫執行rman備份時報錯RMAN-06820 ORA-17629
- 使用RMAN建立STANDBY資料庫——RMAN使用者手冊資料庫
- 使用RMAN duplicate 建立standby資料庫(RAC或單機)資料庫
- Dataguard Standby備份報錯RMAN-06820 ORA-17629解決
- Oracle Standby資料庫建立Oracle資料庫
- RAC資料庫建立STANDBY(六)資料庫
- RAC資料庫建立STANDBY(五)資料庫
- RAC資料庫建立STANDBY(四)資料庫
- RAC資料庫建立STANDBY(三)資料庫
- RAC資料庫建立STANDBY(二)資料庫
- RAC資料庫建立STANDBY(一)資料庫
- rman 建立ftp standbyFTP
- 【RMAN】使用RMAN的Duplicate功能建立物理DataGuard報錯(ORA-17627、ORA-17629)處理
- ORACLE DUPLICATE建立物理standby資料庫Oracle資料庫
- standby 資料庫的建立過程資料庫
- laravel 資料庫遷移時報錯Laravel資料庫
- 使用RMAN建立Duplicate資料庫資料庫
- 【轉】RMAN建立duplicate資料庫資料庫
- 通過RMAN Duplicate建立Oracle物理standby備庫Oracle
- opensips建立資料庫時報database engine not specified錯誤的解決資料庫Database
- 關於建立DataGuard Physical Standby資料庫資料庫
- Standby資料庫簡單建立過程資料庫
- 使用RMAN增量備份前滾STANDBY資料庫資料庫
- 康孚備份資料庫時報錯資料庫
- 利用RMAN建立備用資料庫資料庫
- 建立Oracle ADG standby資料庫若干方法Oracle資料庫
- 建立Local Physical Standby Oracle9i standby 資料庫筆記Oracle資料庫筆記
- 物理Standby資料庫及邏輯Standby資料庫(Physical Standby & Logical Standby)資料庫
- RMAN備份 建立catalog資料庫資料庫
- 基於RMAN 建立測試資料庫資料庫
- 【DATAGUARD 學習】使用duplicate 建立物理standby 資料庫資料庫
- 建立物理STANDBY資料庫——DATA GUARD概念和管理資料庫
- 使用RMAN建立資料庫備份庫(筆記)資料庫筆記
- dbca建立資料庫時報錯ORA-13516: AWR Operation failed: CATPROC not valid資料庫AI