标题: 12c R2 RAC环境打开备库提示ORA-10458 [打印本页] 作者: miss_puff 时间: 2017-8-4 17:46 标题: 12c R2 RAC环境打开备库提示ORA-10458 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.