问题描述：搭建DG，找不到密码文件的位置，就给备库重新生成了一个密码文件，传到了备库，但是拉到了备库以后，恢复过程中，trace日志在报错，后来才知道windows下的密码文件跟linux平台下的面文件不一样
*** 2021-09-11 14:57:05.412 *** 2021-09-11 14:57:05.412 4132 krsh.c Clearing online redo logfile 2 complete DDE: 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 file OSD-04002: 无法打开文件 O/S-Error: (OS 2) 系统找不到指定的文件。 DDE: Problem Key 'ORA 313' was flood controlled (0x1) (no incident) ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\APP\ADMINISTRATOR\ORADATA\ORCLSTB\REDO03.LOG' ORA-27041: unable to open file OSD-04002: 无法打开文件 O/S-Error: (OS 2) 系统找不到指定的文件。 ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\APP\ADMINISTRATOR\ORADATA\ORCLSTB\REDO03.LOG' ORA-27041: unable to open file OSD-04002: 无法打开文件 O/S-Error: (OS 2) 系统找不到指定的文件。 ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\APP\ADMINISTRATOR\ORADATA\ORCLSTB\REDO03.LOG' ORA-27041: unable to open file OSD-04002: 无法打开文件 O/S-Error: (OS 2) 系统找不到指定的文件。 *** 2021-09-11 14:57:05.412 4132 krsh.c Clearing online redo logfile 3 C:\APP\ADMINISTRATOR\ORADATA\ORCLSTB\REDO03.LOG DDE: 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 file OSD-04002: 无法打开文件 O/S-Error: (OS 2) 系统找不到指定的文件。 DDE: Problem Key 'ORA 313' was flood controlled (0x1) (no incident) ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\APP\ADMINISTRATOR\ORADATA\ORCLSTB\REDO03.LOG' ORA-27041: unable to open file OSD-04002: 无法打开文件 O/S-Error: (OS 2) 系统找不到指定的文件。 ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\APP\ADMINISTRATOR\ORADATA\ORCLSTB\REDO03.LOG' ORA-27041: unable to open file OSD-04002: 无法打开文件 O/S-Error: (OS 2) 系统找不到指定的文件。 ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: 'C:\APP\ADMINISTRATOR\ORADATA\ORCLSTB\REDO03.LOG' ORA-27041: unable to open file OSD-04002: 无法打开文件 O/S-Error: (OS 2) 系统找不到指定的文件。 *** 2021-09-11 14:57:05.491 4132 krsh.c Clearing online redo logfile 3 complete *** 2021-09-11 14:57:05.491 4132 krsh.c Media Recovery Waiting for thread 1 sequence 54 Redo shipping client performing standby login OCISessionBegin failed. Error -1 .. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied ' OCISessionBegin failed. Error -1 .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges ' OCISessionBegin failed -1 .. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges ' *** 2021-09-11 14:57:05.522 4132 krsh.c Error 1031 received logging on to the standby *** 2021-09-11 14:57:05.522 4132 krsh.c FAL[client, MRP0]: Error 1031 connecting to orcl for fetching gap sequence ORA-01031: insufficient privileges ORA-01031: insufficient privileges
密码文件：
1.windows系统下 oracle口令文件在：$ORACLE_HOME/database目录下； 命名规则为：PWD$SID.ora 2.linux系统下 oracle口令文件在：$ORACLE_HOME/dbs目录下； 命名规则为：orapw$SID
windows密码文件
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
