oracle11gdataguard环境配置汇总

页面导航:首页 > 数据库 > oracle > oracle11gdataguard环境配置汇总

oracle11gdataguard环境配置汇总

来源: 作者: 时间:2016-01-29 09:07 【

1,master库1 1 参数文件initpowerdes ora[[email protected]_master1 ~]$ cd $ORACLE_HOME dbs[[email protected]_master1 dbs]$ vim initpowerdes orapowerdes __db_cache_size=322961408powerdes __

1,master库

1.1 参数文件initpowerdes.ora

[[email protected]_master1 ~]$ cd $ORACLE_HOME/dbs
[[email protected]_master1 dbs]$ vim initpowerdes.ora

powerdes.__db_cache_size=322961408
powerdes.__java_pool_size=4194304
powerdes.__large_pool_size=4194304
powerdes.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
powerdes.__pga_aggregate_target=335544320
powerdes.__sga_target=503316480
powerdes.__shared_io_pool_size=0
powerdes.__shared_pool_size=159383552
powerdes.__streams_pool_size=0
*.audit_file_dest='/oracle/app/oracle/admin/powerdes/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/oracle/app/oracle/data/powerdes/control01.ctl','/oracle/app/oracle/flash_recovery_area/powerdes/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/oracle/app/oracle/data/powerdes','/oracle/app/oracle/data/powerdes'
*.db_name='powerdes'
*.db_recovery_file_dest='/oracle/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=5218762752
*.db_unique_name='master'
*.diagnostic_dest='/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=powerdesXDB)'
*.fal_client='master'
*.fal_server='standby'
*.log_archive_config='DG_CONFIG=(master,standby)'
*.log_archive_dest_2='SERVICE=standby1  lgwr sync affirm VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
*.log_file_name_convert='/oracle/app/oracle/data/powerdes','/oracle/app/oracle/data/powerdes'
*.memory_target=836763648
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
~                                   

1.2 监听文件

[[email protected]_master1 dbs]$ cd $ORACLE_HOME/network/admin
[[email protected]_master1 admin]$ vim listener.ora

# listener.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by  configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_master1)(PORT = 1521))
  )

ADR_BASE_LISTENER = /oracle/app/oracle

1.3 服务名文件

[[email protected]_master1 dbs]$ cd $ORACLE_HOME/network/admin
[[email protected]_master1 admin]$ vim tnsnames.ora 

# tnsnames.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

master1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_master1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = master)
    )
  )


standby1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_standby1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = standby)
    )
  )

2,standby库的

2.1 参数文件initstandby.ora

[[email protected]_standby1 dbs]$ cd $ORACLE_HOME/dbs
[[email protected]_standby1 dbs]$ vim initstandby.ora

powerdes.__db_cache_size=335544320
standby.__db_cache_size=335544320
powerdes.__java_pool_size=4194304
standby.__java_pool_size=4194304
powerdes.__large_pool_size=4194304
standby.__large_pool_size=4194304
powerdes.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
standby.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
powerdes.__pga_aggregate_target=335544320
standby.__pga_aggregate_target=335544320
powerdes.__sga_target=503316480
standby.__sga_target=503316480
powerdes.__shared_io_pool_size=0
standby.__shared_io_pool_size=0
powerdes.__shared_pool_size=146800640
standby.__shared_pool_size=146800640
powerdes.__streams_pool_size=0
standby.__streams_pool_size=0
*.audit_file_dest='/oracle/app/oracle/admin/powerdes/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/oracle/app/oracle/oradata/standby/control01.ctl','/oracle/app/oracle/flash_recovery_area/standby/control02.ctl'#Restore Controlfile
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/oracle/app/oracle/data/powerdes','/oracle/app/oracle/data/powerdes'
*.db_name='powerdes'
*.db_recovery_file_dest='/oracle/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=5218762752
*.db_unique_name='standby'
*.diagnostic_dest='/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=powerdesXDB)'
*.fal_client='master1'
*.fal_server='standby1'
*.log_archive_config='DG_CONFIG=(master,standby)'
*.log_archive_dest_2='SERVICE=master1  lgwr sync affirm VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=master'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
*.log_file_name_convert='/oracle/app/oracle/data/powerdes','/oracle/app/oracle/data/powerdes'
*.memory_target=836763648
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'

2.2 监听文件

[[email protected]_standby1 dbs]$ cd $ORACLE_HOME/network/admin
[[email protected]_standby1 admin]$ vim listener.ora

# listener.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_standby1)(PORT = 1521))
  )

ADR_BASE_LISTENER = /oracle/app/oracle

2.3 服务名文件

[[email protected]_standby1 dbs]$ cd $ORACLE_HOME/network/admin
[[email protected]_standby1 admin]$ vim listener.ora
[[email protected]_standby1 admin]$ vim tnsnames.ora 

# tnsnames.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

powerdes =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_standby1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = powerdes)
    )
  )

standby1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_standby1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = standby)
    )
  )

master1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_master1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = master)
    )
  )
Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<