DG:windows密码文件

2023-05-13,,

问题描述:搭建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密码文件

DG:windows密码文件的相关教程结束。

《DG:windows密码文件.doc》

下载本文的Word格式文档,以方便收藏与打印。