Oracle 11g ADG
--董佳委
主:150.158.165.41
备:121.5.102.101
更改现在的主备文件:
/etc/hosts文件,tnsnames.ora文件,initorcl.ora文件
更改hosts文件
主:
127.0.0.1 ORADB01 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 ORADB01 localhost localhost.localdomain localhost6 localhost6.localdomain6
...... ORADB02
...... ORADB01
备:
127.0.0.1 localhost.localdomain localhost ORADB02
::1 localhost.localdomain ORADB02
...... ORADB02
...... ORADB01
修改tnsnames.ora文件
主:
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORADB01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
orcldg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORADB02)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcldg)
)
)
备:
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORADB01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
orcldg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORADB02)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcldg)
)
)
修改pfile文件:
主:
*.db_cache_size=754974720
*.java_pool_size=33554432
*.large_pool_size=16777216
*.pga_aggregate_target=5737807872
*.sga_target=2610612736
*.shared_pool_size=0
*.streams_pool_size=16777216
*.audit_file_dest='/u01/app/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oradata/orcl/control01.ctl','/u01/app/flash_recovery_area/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_unique_name='orcl'
*.db_recovery_file_dest='/u01/app/flash_recovery_area'
*.db_recovery_file_dest_size=16777216000
*.diagnostic_dest='/u01/app'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.fal_client='orcl'
*.fal_server='orcldg'
*.log_archive_config='DG_CONFIG=(orcl,orcldg)'
*.log_archive_dest_1='LOCATION=/u01/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
*.log_archive_dest_2='SERVICE=orcl LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcldg'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=5729419264
*.processes=4000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=4000
*.sga_target=1610612736
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
备:
(基本上主库的复制一下,然后改改就可以了,要对照备库实例的文件路径)
*.db_cache_size=754974720
*.java_pool_size=33554432
*.large_pool_size=16777216
*.pga_aggregate_target=5737807872
*.sga_target=2610612736
*.shared_pool_size=0
*.streams_pool_size=16777216
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.1.0'
*.control_files='/u01/app/oradata/orcl/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl/control02.ctl'
*.db_block_size=8192