duplicate報ORA-01017權限問題

環境:

OS:RedHat EnterPrise Linux 5.8 x64

Cluster:Oracle Grid 11.2.0.4

Database:Oracle Database EnterPrise 11.2.0.4

Archive:RAC+DG

今天在配置DG的過程中，前期環境都已經准備好了，就差最後一步將RAC數據duplicate到standby端，但是蹊跷的事情就在這一步發生了，嘗試幾次都無法將數據duplicate過去，當然我嘗試通過拷貝rman備份到對端也無法完成恢復，死活就報ORA-01017錯誤，經過幾個小時的努力，問題最終也算是得到了比較好的解決。如下:

故障現象

rmantarget sys/oracle@jetdb auxiliary sys/oracle@standby
 
RecoveryManager: Release 11.2.0.4.0 - Production on Mon May 26 16:14:36 2014
 
Copyright(c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connectedto target database: JETDB (DBID=2170518470)
connectedto auxiliary database: JETDB (not mounted)
 
RMAN>duplicate target database for standby from active database nofilenamecheck ;
 
Startingrestore at 26-MAY-14
usingtarget database control file instead of recovery catalog
allocatedchannel: ORA_DISK_1
channelORA_DISK_1: SID=416 device type=DISK
 
channelORA_DISK_1: restoring control file
RMAN-00571:===========================================================
RMAN-00569:=============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03002:failure of restore command at 05/26/2014 16:14:54
ORA-19870:error while restoring backup piece /DBBackup/Phycal/stdb_cntl_0fp98vq2_1_1.bkp
ORA-19504:failed to create file "+DATA001/jetdb/controlfile/control01.ctl"
ORA-17502:ksfdcre:3 Failed to create file +DATA001/jetdb/controlfile/control01.ctl
ORA-15001:diskgroup "DATA001" does not exist or is not mounted
ORA-15055:unable to connect to ASM instance
ORA-01017:invalid username/password; logon denied 

問題分析：

1、 從上面告警日志來看，ORA-01017可以很明顯看出是由於權限問題導致。

隨即，我們開始檢查備庫的密碼文件，$ORACLE_HOME/dbs/orapw{SID}是存在的。

[oracle@standby dbs]$ ll$ORACLE_HOME/dbs/orapw*
-rw-r----- 1 oracle oinstall 1536 May 2617:49 /DBSoft/oracle/product/11.2.4/dbhome_1/dbs/orapwstandby

2、 這個時候我們應該查看的是數據庫的alter告警文件:

Errorsin file/DBSoft/oracle/diag/rdbms/standby/standby/trace/standby_asmb_11087.trc  (incident=24130):
ORA-00600:internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], [],[], [], [], []
ORA-27302:failure occurred at: skfnbeqOpenI
Incidentdetails in:/DBSoft/oracle/diag/rdbms/standby/standby/incident/incdir_24130/standby_asmb_11087_i24130.trc
UseADRCI or Support Workbench to package the incident.
See Note411.1 at My Oracle Support for error and packaging details.
ORA-00210:cannot open the specified control file
ORA-00202:control file: '+DATA001/jetdb/controlfile/control01.ctl'
ORA-17503:ksfdopn:2 Failed to open file +DATA001/jetdb/controlfile/control01.ctl
ORA-15001:diskgroup "DATA001" does not exist or is not mounted
ORA-15055:unable to connect to ASM instance
ORA-15055:unable to connect to ASM instance
ORA-00600:internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], [],[], [], [], []
ORA-27302:failure occurred at: skfnbeqOpenI
ORA-1013signalled during: ALTER DATABASE  MOUNT...
Mon May26 16:31:34 2014

從告警文件中我們可以很明顯的看出是ASM磁盤有問題，進入進入grid用戶下用srvctl命令檢查 asm狀態：

[grid@standby~]$ srvctl status asm
ASM isrunning on standby
 
SQL>select name,state,free_mb from v$asm_diskgroup;
 
NAME       STATE          FREE_MB
--------------------- ----------
DATA001    MOUNTED         121112
ARC001     MOUNTED         122483
BAK001     MOUNTED         122826

結果看來ASM也是沒有問題的，那麼唯一的出問題的地方可能就是Oracle哪裡配置的問題。