oracle11g dataguard 环境配置汇总

1，master库

1.1 参数文件initpowerdes.ora

[oracle@oracle_master1 ~]$ cd $ORACLE_HOME/dbs[oracle@oracle_master1 dbs]$ vim initpowerdes.orapowerdes.__db_cache_size=322961408powerdes.__java_pool_size=4194304powerdes.__large_pool_size=4194304powerdes.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environmentpowerdes.__pga_aggregate_target=335544320powerdes.__sga_target=503316480powerdes.__shared_io_pool_size=0powerdes.__shared_pool_size=159383552powerdes.__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 监听文件

[oracle@oracle_master1 dbs]$ cd $ORACLE_HOME/network/admin[oracle@oracle_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 Oracle configuration tools.LISTENER =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_master1)(PORT = 1521))  )ADR_BASE_LISTENER = /oracle/app/oracle

---

1.3 服务名文件

[oracle@oracle_master1 dbs]$ cd $ORACLE_HOME/network/admin[oracle@oracle_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

[oracle@oracle_standby1 dbs]$ cd $ORACLE_HOME/dbs[oracle@oracle_standby1 dbs]$ vim initstandby.orapowerdes.__db_cache_size=335544320standby.__db_cache_size=335544320powerdes.__java_pool_size=4194304standby.__java_pool_size=4194304powerdes.__large_pool_size=4194304standby.__large_pool_size=4194304powerdes.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environmentstandby.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environmentpowerdes.__pga_aggregate_target=335544320standby.__pga_aggregate_target=335544320powerdes.__sga_target=503316480standby.__sga_target=503316480powerdes.__shared_io_pool_size=0standby.__shared_io_pool_size=0powerdes.__shared_pool_size=146800640standby.__shared_pool_size=146800640powerdes.__streams_pool_size=0standby.__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 监听文件

[oracle@oracle_standby1 dbs]$ cd $ORACLE_HOME/network/admin[oracle@oracle_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 服务名文件

[oracle@oracle_standby1 dbs]$ cd $ORACLE_HOME/network/admin[oracle@oracle_standby1 admin]$ vim listener.ora[oracle@oracle_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)    )  )