12c R2 RAC环境打开备库提示ORA-10458

miss_puff

12c R2 RAC环境打开备库报错
打开备库报错
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/sztech/datafile/system01.dbf'

查看alter日志
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------
FAL[client, ARC2]: Error 16191 connecting to SZTECH for fetching gap sequence
2017-08-04T17:08:44.850713+08:00
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
      returning error ORA-16191
------------------------------------------------------------


主库查询v$archive_dest
SQL> select dest_name,status,error from v$archive_dest

DEST_NAME                      STATUS             ERROR
------------------------------ ------------------ -----------------------------------------------------------------
LOG_ARCHIVE_DEST_1             VALID
LOG_ARCHIVE_DEST_2             ERROR              ORA-01033: ORACLE initialization or shutdown in progress



判断是备库的密码文件不对，在主库用sysdba的身份连接备库失败
[oracle@rac01 oracle]$ sqlplus sys/oracle@sztechdg as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 4 17:00:32 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:


解决办法：拷贝主库的密码文件至备库，密码文件的命名方式为orapwSID，注意12c的密码文件是放在ASM磁盘上的。在grid用户下使用cp命令拷贝到本地