Oracle 11g Aix 雙機 物理Standby配置 01

一 環境準備：

	primary	standby
AIX 版本# oslevel -r	5300-07	5300-07
IP	10.10.10.72	10.10.10.73
HOSTNAME	aixstudy	wangwang2
SID	sales	sales
TNSNAMES	SALES	SALES2
歸檔檔案路徑	/ww/arch1/sales/	/ww/arch1/sales/
資料檔案路徑	/opt/oradata/sales/	/opt/oradata/sales/

[@more@]

二 引數檔案及服務檔案參考

兩臺節點上有相同的tnsnames.ora和各自的listener.ora

$ more $ORACLE_HOME/network/admin/tnsnames.ora

SALES =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.72)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = sales)

)

)

SALES2 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.73)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = sales2)

)

)

主機上的引數檔案

$ more dbs/initsales.ora

sales.__db_cache_size=121634816

sales.__java_pool_size=4194304

sales.__large_pool_size=4194304

sales.__pga_aggregate_target=109051904

sales.__sga_target=331350016

sales.__shared_io_pool_size=0

sales.__shared_pool_size=192937984

sales.__streams_pool_size=0

*.audit_file_dest='/opt/app/oracle/admin/sales/adump'

*.audit_trail='db'

*.compatible='11.1.0.0.0'

*.control_files='/opt/oradata/sales/control01.ctl','/opt/oradata/sales/control02.ctl

','/opt/oradata/sales/control03.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='sales'

*.db_recovery_file_dest='/opt/app/oracle/flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.db_unique_name='sales'

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

*.log_archive_config='DG_CONFIG=(sales,sales2)'

*.log_archive_dest_1='LOCATION=/ww/arch1/sales/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) D

B_UNIQUE_NAME=sales'

*.log_archive_dest_2='SERVICE=sales2 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

DB_UNIQUE_NAME=sales2'

*.log_archive_dest_state_1='ENABLE'

*.log_archive_dest_state_2='ENABLE'

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

*.log_archive_max_processes=30

*.nls_territory='AMERICA'

*.open_cursors=300

*.pga_aggregate_target=109051904

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=329252864

*.undo_tablespace='UNDOTBS1'

$

備機上的引數檔案

$ more dbs/initsales.ora

sales.__db_cache_size=121634816

sales.__java_pool_size=4194304

sales.__large_pool_size=4194304

sales.__pga_aggregate_target=109051904

sales.__sga_target=331350016

sales.__shared_io_pool_size=0

sales.__shared_pool_size=192937984

sales.__streams_pool_size=0

*.audit_file_dest='/opt/app/oracle/admin/sales/adump'

*.audit_trail='db'

*.compatible='11.1.0.0.0'

*.control_files='/opt/oradata/sales/control01.ctl','/opt/oradata/sales/control02.ctl

','/opt/oradata/sales/control03.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='sales'

*.db_recovery_file_dest='/opt/app/oracle/flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.db_unique_name='sales2'

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

*.log_archive_config='DG_CONFIG=(sales,sales2)'

*.log_archive_dest_1='LOCATION=/ww/arch1/sales/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

DB_UNIQUE_NAME=sales2'

*.log_archive_dest_2='SERVICE=sales

ASYNC

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

DB_UNIQUE_NAME=sales'

*.log_archive_dest_state_1='ENABLE'

*.log_archive_dest_state_2='ENABLE'

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

*.log_archive_max_processes=30

*.nls_territory='AMERICA'

*.open_cursors=300

*.pga_aggregate_target=109051904

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=329252864

*.undo_tablespace='UNDOTBS1'