Oracle 11g ADG 搭建

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