santaclaus 发表于 2018-9-23 14:34:18

Oracle 10g Data Guard

ora12,ORACLE_SID=test2,db_name=test1,db_unique_name=test2  hosts
  193.168.0.11   ora11.zhou.comora11
  127.0.0.1       localhost.localdomain   localhost
  193.168.0.12   ora12.zhou.comora12
  inittest2.ora (里面出现的目录,没有的,要手动建立)
  *.audit_file_dest='/u01/app/oracle/admin/test2/adump'
  *.background_dump_dest='/u01/app/oracle/admin/test2/bdump'
  *.compatible='10.2.0.1.0'
  *.control_files='/u01/app/oracle/oradata/test1/control01.ctl','/u01/app/oracle/oradata/test1/control02.ctl','/u01/app/oracle/oradata/test1/control03.ctl'
  *.core_dump_dest='/u01/app/oracle/admin/test2/cdump'
  *.db_block_size=8192
  *.db_domain=''
  *.db_file_multiblock_read_count=16
  *.db_name='test1'
  *.db_unique_name='test2'
  *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
  *.db_recovery_file_dest_size=2147483648
  *.job_queue_processes=10
  *.open_cursors=300
  *.pga_aggregate_target=16777216
  *.processes=150
  *.remote_login_passwordfile='EXCLUSIVE'
  *.sga_target=167772160
  *.undo_management='AUTO'
  *.undo_tablespace='UNDOTBS1'
  *.user_dump_dest='/u01/app/oracle/admin/test2/udump'
  *.fal_server='TEST1'
  *.fal_client='TEST2'
  *.log_archive_config='DG_CONFIG=(test1,test2)'
  *.log_archive_dest_1='LOCATION=/u01/app/oracle/arch/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=test2'
  *.log_archive_dest_2='SERVICE=test1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=test1'
  *.log_archive_dest_3='LOCATION=/u01/app/oracle/arch3/ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=test2'
  *.log_archive_dest_state_1='ENABLE'
  *.log_archive_dest_state_2='enable'
  *.log_archive_dest_state_3='ENABLE'
  *.log_file_name_convert='/u01/app/oracle/oradata/test1','/u01/app/oracle/oradata/test1'
  *.nls_language='SIMPLIFIED CHINESE'
  *.nls_territory='CHINA'
  *.remote_login_passwordfile='EXCLUSIVE'
  *.STANDBY_ARCHIVE_DEST='/u01/app/oracle/standbyarch/'
  *.standby_file_management='AUTO'

页: [1]
查看完整版本: Oracle 10g Data Guard