dg rac 到单机配置

1，主数据库参数设置（zmsft）

--主备都设置
alter system set log_archive_config='dg_config=(zmsft,zmsftdg)';
--主设置
alter system set log_archive_dest_3='service=zmsftdg valid_for=(online_logfiles,primary_role) db_unique_name=zmsftdg';
--主设置
alter system set log_archive_dest_state_3 = 'enable';

2，备参数文件设置

*.audit_file_dest='/u01/app/oracle/admin/zmsft/adump'
*.audit_trail='NONE'
*.background_dump_dest='/u01/app/oracle/diag/rdbms/zmsftdg/zmsftdg/trace'#Deprecate parameter
*.compatible='11.2.0.4.0'
*.control_files='/zmsft/control01.ctl'
*.core_dump_dest='/u01/app/oracle/diag/rdbms/zmsftdg/zmsftdg/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='+NEWDATA/newzmsft/datafile','/zmsft','+NEWDATA/zmsft/datafile','/zmsft','+NEWDATA/zmsft/tempfile','/zmsft'
*.db_files=2000
*.db_name='zmsft'
*.db_unique_name='zmsftdg'
*.deferred_segment_creation=FALSE
*.diagnostic_dest='/u01/app/oracle'
*.fal_server='zmsft'
*.log_archive_config='dg_config=(zmsft,zmsftdg)'
*.log_archive_dest_1='location=/zmsftarch'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=53469184# log buffer update
*.log_file_name_convert='+NEWDATA/zmsft/onlinelog','/zmsft'
*.memory_max_target=30G
*.memory_target=30G
*.open_cursors=4000
*.optimizer_dynamic_sampling=2
*.optimizer_mode='ALL_ROWS'
*.pga_aggregate_target=0
*.plsql_warnings='DISABLE:ALL'# PL/SQL warnings at init.ora
*.processes=1200
*.query_rewrite_enabled='TRUE'
*.remote_login_passwordfile='EXCLUSIVE'
*.result_cache_max_size=78656K
*.sessions=1824
*.skip_unusable_indexes=TRUE
*.standby_file_management='auto'

3,相关命令

$ 启动日志应用进程
alter database recover managed standby database disconnect from session
/
$ 取消日志用用
recover managed standby database cancel;
$ 检查同步状态
set linesize 1000;
set pagesize 500
select sequence#,FIRST_TIME,NEXT_TIME,applied from v$archived_log
/

4,监听文件配置

#配置RAC的SCAN地址
zmsft =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.0.66)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = zmsft)
    )
  )

zmsftdg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.0.70) (PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = zmsftdg)
    )
  )

静态监听配置

$ cat listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.0.70)(PORT = 1521))
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME =zmsftdg)
      (ORACLE_HOME = /u01/app/oracle/product/11.2)
      (SID_NAME = zmsftdg)
    )
  )