oracle11gdataguard環境配置匯總
1，master庫
1.1 參數文件initpowerdes.ora
[oracle@oracle_master1 ~]$ cd $ORACLE_HOME/dbs
[oracle@oracle_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 監聽文件
[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.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 監聽文件
[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)
)
)
