一 环境准备:
| 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/ |
二 参数文件及服务文件参考
两台节点上有相同的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'
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/271063/viewspace-1014083/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/271063/viewspace-1014083/