问题描述:搭建DG,找不到密码文件的位置,就给备库重新生成了一个密码文件,传到了备库,但是拉到了备库以后,恢复过程中,trace日志在报错,后来才知道windows下的密码文件跟linux平台下的面文件不一样
*** 2021-09-11 14:57:05.412*** 05.412 4132 krsh.cClearing online redo logfile 2 completeDDE: Problem Key 'ORA 312' was flood controlled (0x1) (no incIDent)ORA-00312: online log 3 thread 1: C:\APP\adminISTRATOR\ORADATA\ORCLSTB\REDO03.LOG'ORA-27041: unable to open fileOSD-04002: 无法打开文件O/S-Error: (OS ) 系统找不到指定的文件。DDE: Problem Key ORA 31300313: open Failed for members of log group 3 of thread 1) 系统找不到指定的文件。ORA-) 系统找不到指定的文件。*** 3 C:\APP\adminISTRATOR\ORADATA\ORCLSTB\REDO03.LOGDDE: Problem Key 05.491 complete*** krsh.cMedia Recovery Waiting for thread 1 sequence 54Redo shipPing clIEnt performing standby loginOCISessionBegin Failed. Error -.. Detailed OCI error val is 1017 and errmsg ORA-01017: invalID username/password; logon denIEd'OCISessionBegin Failed. Error -1031 and errmsg ORA-01031: insufficIEnt privileges'OCISessionBegin Failed -'*** 05.522 krsh.cError 1031 received logging on to the standby*** krsh.cFAL[clIEnt,MRP0]: Error 1031 connecting to orcl for fetching gap sequenceORA-01031: insufficIEnt privilegesORA-01031: insufficIEnt privileges
密码文件:
.windows系统下oracle口令文件在:$ORACLE_HOME/database目录下;命名规则为:PWD$SID.ora .linux系统下oracle口令文件在:$ORACLE_HOME/dbs目录下;命名规则为:orapw$SID
windows密码文件
总结
以上是内存溢出为你收集整理的DG:windows密码文件全部内容,希望文章能够帮你解决DG:windows密码文件所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)