搭建_DG 几个需要理解的名词

  1 ：  

  2 :  db_unique_name   主备必须不一致， 同时可以等于（不等于） 数据库的service_name.

        db_unique_name   必须和参数*.log_archive_config='dg_config 配合使用 ---此参数是配置主备的数据库

 3 :  db_unique_name 可以和 net-service-name 同名，也可以不同名。

 

 4 ： *.log_archive_dest_2='service=dominic_s      ---参数 “ *.log_archive_dest_2” 对应的service  为 net-service, 而非 db-service

 5 :  fal_server, fal_client  分别对应的是 tnsname.ora    的net-server服务名。

6 : 搭建之间最好通过 rman target sys/oracle@lmocm_p auxiliary sys/oracle@lmocm_s  测试是否执行为报错，  监听的问题，也可能引起DG搭建失败的问题 ，如下日志(日志应用时）：  通过netmgr 查看一下

  主： 

------------------------------------------------------------------

TNS-12541: TNS:no listener

    ns secondary err code: 12560

    nt main err code: 511

   

TNS-00511: No listener

    nt secondary err code: 111

    nt OS err code: 0

Error 12541 received logging on to the standby

Check whether the listener is up and running.

PING[ARC2]: Heartbeat failed to connect to standby 'dominic_s'. Error is 12541.

---------------------------------------------------------------------

 备：

TNS-12564: TNS:connection refused

    ns secondary err code: 0

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

Error 12514 received logging on to the standby

FAL[client, ARC2]: Error 12514 connecting to dominic_p for fetching gap sequence

ARC3: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

7 :关于启动关闭顺序

启动的时候，先从库的listener，然后启动从库，然后启动主库的listener 接着是主库
关闭的时候正好相反，先关闭主库，然后是从库。

8: 一些常用的view 
V$ARCHIVE_DEST_STATUS 这里面会纪录到standby的状态和恢复到那个日志
V$ARCHIVE_GAP 这里面会纪录当前从库mrp进程恢复需要的胆识还没有传到从库得日志
V$ARCHIVED_LOG 这里面会纪录所有已经归档到从库的日志，并且记录该日志是否已经恢复
V$DATABASE 会纪录系统的保护状态和是否处于force logging状态
V$MANAGED_STANDBY (Physical Standby Databases Only) 会纪录当前从库的一些进程情况和进程的process id，如rfs,mrp等
V$STANDBY_LOG (Physical StandbyDatabases Only) 会纪录当前从库的standby redo log的一些情况。

==================================================================================================

实例：  db_unique_name 和  net-service 不同：

---tnsname.ora   { 这个文件才是关键，多机连接地址指定}

DOMINIC_S =       ---net service 

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = dominic6.com)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = dominic)  --db service

    )

  )

DOMINIC_P =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = dominic5.com)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = dominic)

    )

  )

---listen.ora   { db自身的监听}

 

 LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = dominic5.com)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

  )

ADR_BASE_LISTENER = /u01/app/oracle

或者：

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = dominic)

      (ORACLE_HOME = /u01/app/oracle/product/11.2/dbhome_2)

      (SID_NAME = dominic)

    )

  )

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = dominic5.com)(PORT = 1521))

  )

ADR_BASE_LISTENER = /u01/app/oracle

-------------------------------------------------------------------

  主配置参数文件spfile

*.control_files='/u01/app/oracle/oradata/dominic/control01.ctl','/u01/app/oracle/fast_recovery_area/dominic/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='dominic'     

*.db_unique_name='dominic'

*.fal_server='dominic_p'

*.fal_client='dominic_s'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=6442450944

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=dominicXDB)'

*.log_archive_config='dg_config=(dominic,dominics)'

*.log_archive_dest_1='location=/u01/app/oracle/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=dominic'

*.log_archive_dest_2='service=dominic_s sync affirm lgwr valid_for=(all_logfiles,primary_role) db_unique_name=dominics'

*.log_archive_dest_state_1='enable'

*.log_archive_dest_state_2='enable'

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=1153433600

*.open_cursors=300

*.processes=800

*.remote_login_passwordfile='EXCLUSIVE'

*.standby_file_management='auto'

*.undo_tablespace='UNDOTBS1'

========================================================================

  备配置参数文件spfile:

*.audit_file_dest='/u01/app/oracle/admin/dominic/adump'

*.audit_trail='db'

*.compatible='11.2.0.4.0'

*.control_files='/u01/app/oracle/oradata/dominic/control01.ctl','/u01/app/oracle/fast_recovery_area/dominic/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='dominic'

*.db_unique_name='dominics'

*.fal_server='dominic_p'

*.fal_client='dominic_s'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=6442450944

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=dominicXDB)'

*.log_archive_config='dg_config=(dominic,dominics)'

*.log_archive_dest_1='location=/u01/app/oracle/archivelog valid_for=(all_logfiles,all_roles) db_unique_name=dominics'

*.log_archive_dest_2='service=dominic_p sync affirm lgwr valid_for=(all_logfiles,primary_role) db_unique_name=dominic' 

*.log_archive_dest_state_1='enable'

*.log_archive_dest_state_2='enable'

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=1153433600

*.open_cursors=300

*.processes=800

*.remote_login_passwordfile='EXCLUSIVE'

*.standby_file_management='auto'

*.undo_tablespace='UNDOTBS1'