1 Reply Latest reply: Apr 6, 2012 4:34 AM by 926275 RSS

    Data guard implementation

    926275
      i am trying to implement data guard in test setup.

      primary database name is test & secondary db name is testdr.. following is a primary database init.ora file...

      test.__db_cache_size=3019898880
      test.__java_pool_size=67108864
      test.__large_pool_size=67108864
      test.__oracle_base='c:\app\administrator'#ORACLE_BASE set from environment
      test.__pga_aggregate_target=2751463424
      test.__sga_target=4093640704
      test.__shared_io_pool_size=0
      test.__shared_pool_size=872415232
      test.__streams_pool_size=0
      *.audit_file_dest='c:\app\administrator\admin\test\adump'
      *.audit_trail='db'
      *.compatible='11.2.0.0.0'
      *.control_files='c:\app\administrator\oradata\test\control01.ctl','C:\app\Administrator\flash_recovery_area\test\control02.ctl'
      *.db_block_size=8192
      *.db_domain=''
      *.db_name='test'
      *.db_recovery_file_dest_size=2g
      *.db_recovery_file_dest='c:\app\administrator\flash_recovery_area'
      *.db_unique_name='test'
      db_file_name_convert='c:\app\Administrator\oradata\testdr\','c:\app\Administrator\oradata\test\'
      log_file_name_convert='c:\app\administrator\oradata\testdr\','c:\app\administrator\oradata\test\'
      *.diagnostic_dest='c:\app\administrator'
      *.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTXDB)'
      *.fal_client='TEST'
      *.fal_server='TESTDR'
      *.log_archive_dest_1='LOCATION=c:\app\administrator\oradata\backup VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=test'
      *.log_archive_dest_2='SERVICE=TESTDR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=testdr'
      *.log_archive_dest_state_1='ENABLE'
      *.log_archive_dest_state_2='DEFER'
      *.log_archive_format='ARC%S_%R.%T'
      *.memory_target=6794772480
      *.open_cursors=300
      *.processes=150
      *.remote_login_passwordfile='EXCLUSIVE'
      *.service_names='TEST'
      *.standby_file_management='AUTO'
      *.undo_tablespace='UNDOTBS1'