rac dataguard搭建过程

这几天要为rac大家dataguard，但是实际上rac现在只有但节点运行，因为另一个节点服务器坏了需要维修。


如果某天节点1修好了，在起数据库之前务必先修改tnsname.ora，添加HNDG的部分。不然归档会缺失


sid都叫HNDB
备库监听名叫HNDG好了
db_unique_name 主库叫HNDB，备库叫HNDG






在备库tnsnames.ora添加


HNDB =
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hn-db1-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = hn-db2-vip)(PORT = 1521))
      (LOAD_BALANCE = yes)
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = HNDB)
      )
  )


HNDG =
  (DESCRIPTION =
     (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = hn-dg)(PORT = 1521))
     )
     (CONNECT_DATA =
        (SERVICE_NAME = HNDB)
     )
  )
  
HNDB2 =
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hn-db2-vip)(PORT = 1521))
      (CONNECT_DATA =    
        (SERVER = DEDICATED)        
        (SERVICE_NAME = HNDB)              
        (INSTANCE_NAME = HNDB2)                    
      )
  )
  
HNDB1 =
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hn-db1-vip)(PORT = 1521))
      (CONNECT_DATA =    
        (SERVER = DEDICATED)        
        (SERVICE_NAME = HNDB)              
        (INSTANCE_NAME = HNDB1)                    
      )
  )














在主库tnsnames.ora添加
HNDG =
  (DESCRIPTION =
     (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = hn-dg)(PORT = 1521))
     )
     (CONNECT_DATA =
        (SERVICE_NAME = HNDB)
     )
  )
  










原spfile
HNDB1.__db_cache_size=3724541952
HNDB2.__db_cache_size=3724541952
HNDB1.__java_pool_size=16777216
HNDB2.__java_pool_size=16777216
HNDB1.__large_pool_size=16777216
HNDB2.__large_pool_size=16777216
HNDB1.__shared_pool_size=520093696
HNDB2.__shared_pool_size=520093696
HNDB1.__streams_pool_size=0
HNDB2.__streams_pool_size=0
*.archive_lag_target=0
*.audit_file_dest='/oracle/app/admin/HNDB/adump'
*.background_dump_dest='/oracle/app/admin/HNDB/bdump'
*.cluster_database_instances=2
*.cluster_database=TRUE
*.compatible='10.2.0.3.0'
*.control_file_record_keep_time=10
*.control_files='+VGDATA/hndb/controlfile/current.256.715872251','+VGRECOVERY/hndb/controlfile/current.256.715872253'
*.core_dump_dest='/oracle/app/admin/HNDB/cdump'
*.cursor_sharing='FORCE'
*.db_block_size=8192
*.db_create_file_dest='+VGDATA'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='HNDB'
*.db_recovery_file_dest='+VGRECOVERY'
*.db_recovery_file_dest_size=107374182400
*.dispatchers='(PROTOCOL=TCP) (SERVICE=HNDBXDB)'
HNDB2.instance_number=2
HNDB1.instance_number=1
*.job_queue_processes=10
HNDB1.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.1.101)(PORT = 1521))'
HNDB2.local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.1.103)(PORT = 1521))'
*.log_archive_dest_1='location=+VGRECOVERY'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=800
*.optimizer_index_caching=100
*.optimizer_index_cost_adj=20
*.pga_aggregate_target=734003200
*.processes=900
*.remote_listener='LISTENERS_HNDB'
*.remote_login_passwordfile='exclusive'
*.session_cached_cursors=100
*.sessions=995
*.sga_target=4294967296
HNDB2.thread=2
HNDB1.thread=1
*.undo_management='AUTO'
*.undo_retention=1800
*.undo_tablespace='UNDOTBS1'
HNDB1.undo_tablespace='UNDOTBS1