aix oracle -t -v,Oracle 11g Aix 双机 物理Standby配置 01

一 环境准备：

primarystandby

AIX版本# oslevel -r5300-075300-07

IP10.10.10.7210.10.10.73

HOSTNAMEaixstudywangwang2

SIDsalessales

TNSNAMESSALESSALES2

归档文件路径/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'