求助 data guard 错误不知道怎么解决

udud123

SQL> select status,error from v$archive_dest where dest_id=2;

STATUS    ERROR
--------- -----------------------------------------------------------------
ERROR     ORA-16191: Primary log shipping client not logged on standby

renxiao2003

http://www.yuloo.com/news/0904/226025.html

udud123

你好，我这个里还有一个错误，帮我看看吧

SQL> select status,error from v$archive_dest where dest_id=2;

STATUS    ERROR
--------- -----------------------------------------------------------------
ERROR     ORA-12505: TNS:listener does not currently know of SID given in
          connect descriptor

tnsname.ora配置如下。不知道是怎么回事
PRIV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.91)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = PRIV)
    )
  )

MTH =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.92)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = MTH)
    )
  )

dingning239

楼主最好检查一下你的参数，同时注意fal_server fal_client这两个参数配置是否正确，还的看你的主备库之间网络是否畅通

duolanshizhe

检查主库与备库之间通讯情况