日韩黑丝制服一区视频播放|日韩欧美人妻丝袜视频在线观看|九九影院一级蜜桃|亚洲中文在线导航|青草草视频在线观看|婷婷五月色伊人网站|日本一区二区在线|国产AV一二三四区毛片|正在播放久草视频|亚洲色图精品一区

搜索
分享

windows,oracle,dg報(bào)錯(cuò)：ORA-12528，ORA-12154，ORA-10456 ,PING[ARC1]: Heartbeat failed to connect to standb

 印度阿三17 2019-06-25

windows,oracle,dg報(bào)錯(cuò)：ORA-12528，ORA-12154，ORA-10456

最近有需求在windows的2臺(tái)oracle服務(wù)器上搭建dg，在過(guò)程中遇到了一些錯(cuò)誤，跟在linux上不一樣

如下：

環(huán)境：11.2.0.4

主庫(kù)
ip:192.168.19.197
sid:ORCL
db_unique_name:ORCL
安裝路徑：C:\app\Administrator\product\11.2.0\dbhome_1\
數(shù)據(jù)文件路徑：C:\app\Administrator\oradata\ORCL
本地歸檔路徑：C:\app\Administrator\fast_recovery_area\ORCL\ARCHIVELOG

備庫(kù)
ip:192.168.19.194
sid:orclbk
db_unique_name:orclbk
安裝路徑：C:\app\Administrator\product\11.2.0\dbhome_1\
數(shù)據(jù)文件路徑：C:\app\Administrator\oradata\orclbk
本地歸檔路徑：C:\app\Administrator\fast_recovery_area\orclbk\ARCHIVELOG

dg的搭建過(guò)程就不詳細(xì)描述，只針對(duì)錯(cuò)誤進(jìn)行處理，總體在windows下搭建dg跟再linux下類似，只有一處，一會(huì)回講到

--使用rman?auxiliary

主庫(kù)：

SQL> archive log list
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> archive log list;
SQL> select name , open_mode, log_mode,force_logging from gv$database;
SQL> show parameter db_recover
SQL> alter database force logging;
SQL> alter system switch logfile;

--添加standby redo log

alter database add standby logfile group 4 ('C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG') size 50m;

--tns監(jiān)聽配置文件

orclbk_192.168.19.194 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.19.194)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orclbk)
? ? ? (UR=A)
    )
  )

orcl_192.168.19.197 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.19.197)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

--修改參數(shù)文件

alter system set log_archive_config='dg_config=(ORCL,orclbk)'   scope=spfile sid='*';
alter system set log_archive_dest_1='location=C:\app\Administrator\fast_recovery_area\ORCL\ARCHIVELOG valid_for=(all_logfiles,all_roles) db_unique_name=ORCL'  scope=spfile sid='*';
alter system set log_archive_dest_2='service=orclbk_192.168.19.194 valid_for=(online_logfiles,primary_role) db_unique_name=orclbk'   scope=spfile sid='*';
alter system set log_archive_dest_state_1=enable   scope=spfile sid='*';
alter system set log_archive_dest_state_2=enable   scope=spfile sid='*';
alter system set standby_file_management='auto'   scope=spfile sid='*';
alter system set fal_server='orclbk_192.168.19.194'   scope=spfile sid='*';
alter system set fal_client='orcl_192.168.19.197'   scope=spfile sid='*';
alter system set db_file_name_convert='C:\app\Administrator\oradata\ORCL','C:\app\Administrator\oradata\orclbk' scope=spfile sid='*';
alter system set log_file_name_convert='C:\app\Administrator\oradata\ORCL','C:\app\Administrator\oradata\orclbk' scope=spfile sid='*';
alter system set log_archive_format='%t_%s_%r.arch' scope=spfile sid='*';
### scope=spfile 后面主庫(kù)要重啟才生效

備庫(kù)

注意：在windows上（linux略過(guò)），由于cadbk實(shí)例沒(méi)有創(chuàng)建，所以需要ORADIM -NEW -SID cadbk

創(chuàng)建目錄

比如

cd C:\app\Administrator\admin
mkdir orclbk

修改備庫(kù)參數(shù)文件

*.audit_file_dest='C:\app\Administrator\admin\orclbk\adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='C:\app\Administrator\oradata\orclbk\control01.ctl','C:\app\Administrator\fast_recovery_area\orclbk\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='C:\app\Administrator\oradata\ORCL','C:\app\Administrator\oradata\orclbk'
*.db_name='ORCL'
*.service_names='orclbk'
*.db_unique_name='orclbk'
*.db_recovery_file_dest='C:\app\Administrator\fast_recovery_area'
*.db_recovery_file_dest_size=4385144832
*.diagnostic_dest='C:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=CADXDB)'
*.fal_server='orcl_192.168.19.197'
*.fal_client='orclbk_192.168.19.194'
*.log_archive_config='dg_config=(ORCL,orclbk)'
*.log_archive_dest_1='location=C:\app\Administrator\fast_recovery_area\orclbk\ARCHIVELOG valid_for=(all_logfiles,all_roles) db_unique_name=orclbk'
*.log_archive_dest_2='service=cad_192.168.19.197 valid_for=(online_logfiles,primary_role) db_unique_name=ORCL'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arch'
*.log_file_name_convert='C:\app\Administrator\oradata\ORCL','C:\app\Administrator\oradata\orclbk'

--備庫(kù)tns

orclbk_192.168.19.194 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.19.194)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orclbk)
      (UR=A)
    )
  )

orcl_192.168.19.197 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.19.197)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

tnsping orcl_192.168.19.197
tnsping orclbk_192.168.19.194

1 報(bào)錯(cuò)ORA-12528: TNS:listener: all appropriate instances are blocking new connections

由于cadbk實(shí)例是手工ORADIM -NEW -SID orclbk命令添加的，在lsnrctl status的時(shí)候，狀態(tài)為blocked，數(shù)據(jù)庫(kù)實(shí)例orclbk狀態(tài)為nomount，因?yàn)閯?dòng)態(tài)監(jiān)聽的問(wèn)題，對(duì)輔助數(shù)據(jù)庫(kù)沒(méi)法注冊(cè)，這里修改為靜態(tài)注冊(cè)

或者在tns文件中增加

(UR=A)（主庫(kù)備庫(kù)的tns對(duì)應(yīng)都要增加）

在主備執(zhí)行

sqlplus /nolog
conn sys/*@orcl_192.168.19.197 as sysdba
conn sys/*@orclbk_192.168.19.194 as sysdba

正常就可以

2?

rror 12154 received logging on to the standby
FAL[server, ARC3]: Error 12154 creating remote archivelog file 'orclbk'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
Tue Jun 25 15:47:46 2019
Error 12154 received logging on to the standby
PING[ARC1]: Heartbeat failed to connect to standby 'orclbk'. Error is 12154.
Tue Jun 25 15:47:50 2019
Error 12154 received logging on to the standby
Tue Jun 25 15:47:50 2019
Error 12154 received logging on to the standby
Error 12154 for archive log file 3 to 'orclbk'
FAL[server, ARC0]: Error 12154 creating remote archivelog file 'orclbk'
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_nsa2_15224.trc:
ORA-12154: TNS:could not resolve the connect identifier specified
Tue Jun 25 15:49:44 2019
Tue Jun 25 15:49:48 2019
Archived Log entry 17 added for thread 1 sequence 1840 ID 0x5e779e7a dest 1:
Tue Jun 25 15:52:09 2019
Starting background process SMCO
Tue Jun 25 15:52:09 2019
SMCO started with pid=49, OS id=11840 
Tue Jun 25 15:53:42 2019
Error 12154 received logging on to the standby
PING[ARC1]: Heartbeat failed to connect to standby 'orclbk'. Error is 12154.
Tue Jun 25 15:55:23 2019
Tue Jun 25 16:02:00 2019
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
Tue Jun 25 16:02:07 2019
Error 12154 received logging on to the standby
PING[ARC1]: Heartbeat failed to connect to standby 'orclbk'. Error is 12154.

查詢主備庫(kù)

select message from v$dataguard_status;

select dest_name,error,status from v$archive_dest;
LOG_ARCHIVE_DEST_2 ORA-12154: TNS: 無(wú)法解析指定的連接標(biāo)識(shí)符 ERROR

主庫(kù)報(bào)錯(cuò)，這里參數(shù)LOG_ARCHIVE_DEST_2錯(cuò)誤，之前的值是cadbk

alter system set log_archive_dest_2='service=orclbk valid_for=(online_logfiles,primary_role) db_unique_name=orclbk'   scope=both sid='*';

但是在tns文件中定義的orclbk_192.168.19.194，所以要修改--上面貼出的文件中已修改，所以如果按照上面參數(shù)文件是不會(huì)遇到此錯(cuò)誤的。

alter system set log_archive_dest_2='service=orclbk_192.168.19.194 valid_for=(online_logfiles,primary_role) db_unique_name=orclbk'   scope=both sid='*';
alter system set fal_server='orclbk_192.168.19.194'   scope=both sid='*';
alter system set fal_client='orcl_192.168.19.197'   scope=both sid='*';
SQL> select * from v$archive_gap;

   THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
         1          1836           1840
SQL> alter database register physical logfile 'C:\app\Administrator\fast_recovery_area\orclbk\ARCHIVELOG\1_1837_976879612.ARCH';

3?

alter database open
ORA-10456 signalled during: alter database open...

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
          1842
SQL> select DBID,NAME,OPEN_MODE,DATABASE_ROLE from v$database;

      DBID NAME      OPEN_MODE            DATABASE_ROLE
---------- --------- -------------------- ----------------
1584932730 ORCL       MOUNTED              PHYSICAL STANDBY
SQL> alter database open;
alter database open
*
第 1 行出現(xiàn)錯(cuò)誤:
ORA-10456: cannot open standby database; media recovery session may be in
progress


SQL> select DBID,NAME,OPEN_MODE,DATABASE_ROLE from v$database;

      DBID NAME      OPEN_MODE            DATABASE_ROLE
---------- --------- -------------------- ----------------
1584932730 ORCL       MOUNTED              PHYSICAL STANDBY

SQL> alter database recover managed standby database cancel;

數(shù)據(jù)庫(kù)已更改。

SQL> alter database open;

數(shù)據(jù)庫(kù)已更改。

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

數(shù)據(jù)庫(kù)已更改。

SQL> select DBID,NAME,OPEN_MODE,DATABASE_ROLE from v$database;

      DBID NAME      OPEN_MODE            DATABASE_ROLE
---------- --------- -------------------- ----------------
1584932730 ORCL       READ ONLY WITH APPLY PHYSICAL STANDBY
來(lái)源：https://www./content-2-267651.html

    本站是提供個(gè)人知識(shí)管理的網(wǎng)絡(luò)存儲(chǔ)空間，所有內(nèi)容均由用戶發(fā)布，不代表本站觀點(diǎn)。請(qǐng)注意甄別內(nèi)容中的聯(lián)系方式、誘導(dǎo)購(gòu)買等信息，謹(jǐn)防詐騙。如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請(qǐng)點(diǎn)擊一鍵舉報(bào)。
    轉(zhuǎn)藏 分享 獻(xiàn)花（0）

    0條評(píng)論

    發(fā)表

    請(qǐng)遵守用戶 評(píng)論公約

    類似文章 更多