环境:
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错误,,经过几个小时的努力,问题最终也算是得到了比较好的解决。
vmware+linux+oracle 10g rac全程详细图解
在centos 6.4下安装oracle 11gr2(x64)
oracle 11gr2 在vmware虚拟机中安装步骤
debian 下 安装 oracle 11g xe r2
oracle 11gr2 在vmware虚拟机中安装步骤
如下:
故障现象:
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哪里配置的问题。
3、这个时候我们应该先看看会不会是权限的问题:
[root@standby ~]# id oracle
uid=501(oracle) gid=504(oinstall)groups=504(oinstall) ,505(dba)
[root@standby ~]# id grid
uid=500(grid) gid=504(oinstall) groups=504(oinstall),503(asmadmin),506(asmdba),507(asmoper)
更多详情见请继续阅读下一页的精彩内容:
