centos oracle11g dataguard备库开启只读时报错

熊英 发布于 2015/01/07 09:52
阅读 613
收藏 0


主库ip:192.168.186.128 备库ip:192.168.186.129

备库

SQL> alter database open read only;

alter database open read only
*
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: '/opt/oracle/app/oradata/orcl/system01.dbf'

看了下alert log,如下:
Fatal NI connect error 12543, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.186.128)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=oracle)(HOST=oracledb2)(USER=oracle))))

  VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
  Time: 07-JAN-2015 09:14:30
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12543

TNS-12543: TNS:destination host unreachable
    ns secondary err code: 12560
    nt main err code: 513

TNS-00513: Destination host unreachable
    nt secondary err code: 113
    nt OS err code: 0
Error 12543 received logging on to the standby
FAL[client, USER]: Error 12543 connecting to orcl for fetching gap sequence
Errors in file /opt/oracle/app/diag/rdbms/orcldg/orcldg/trace/orcldg_ora_3292.trc:
ORA-12543: TNS:destination host unreachable
Errors in file /opt/oracle/app/diag/rdbms/orcldg/orcldg/trace/orcldg_ora_3292.trc:
ORA-12543: TNS:destination host unreachable
Wed Jan 07 09:14:40 2015
FAL[client]: Failed to request gap sequence
 GAP - thread 1 sequence 14-14
 DBID 1395065541 branch 867284807
FAL[client]: All defined FAL servers have been attempted.


备库listener.ora
SID_LIST_LISTENER=
     (SID_LIST =
  (SID_DESC =
      (GLOBAL_DBNAME = orcldg)
      (ORACLE_HOME = /opt/oracle/app/product/11.2.0/dbhome_1)
      (SID_NAME = orcldg)
  )
     )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.186.129)(PORT = 1521))
    )
  )


ADR_BASE_LISTENER = /opt/oracle/app

备库 tnsnames.ora
ORCLDG =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.186.129)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = orcldg)
     )
   )


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.186.128)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

 


加载中
返回顶部
顶部