9 Replies Latest reply: May 7, 2012 5:52 AM by user29991 RSS

    ora-29760: instance_number parameter not specified in rac to rac dataguard

    user29991
      Dear Friends,

      I am getting above error when i ma starting my rac data guard on linux. i specify instance number but still its asking

      Pls see the matter and do the needfull.

      this is my pfile

      timsdr1.__db_cache_size=4345298944
      timsdr2.__db_cache_size=4395630592
      timsdr2.__java_pool_size=33554432
      timsdr1.__java_pool_size=33554432
      timsdr1.__large_pool_size=16777216
      timsdr2.__large_pool_size=16777216
      timsdr1.__shared_pool_size=1191182336
      timsdr2.__shared_pool_size=1140850688
      timsdr1.__streams_pool_size=0
      timsdr2.__streams_pool_size=0
      *.audit_file_dest='/u02/app/oracle/product/database/admin/tims/adump'
      *.background_dump_dest='/u02/app/oracle/product/database/admin/tims/bdump'
      *.cluster_database_instances=2
      *.cluster_database=TRUE
      *.db_unique_name=TIMSDR
      *.compatible='10.2.0.1.0'
      *.control_files='/database/timsdr/control01.ctl','/database/timsdr/control02.ctl','/database/timsdr/control03.ctl'
      *.core_dump_dest='/u02/app/oracle/product/database/admin/tims/cdump'
      *.db_block_size=8192
      *.db_domain=''
      *.db_file_multiblock_read_count=16
      *.db_name='tims'
      *.dispatchers='(PROTOCOL=TCP) (SERVICE=timsXDB)'
      *.fal_client='timsdr'
      *.fal_server='tims'
      Service_names=’TIMSDR’
      timsdr1.instance_number=1
      timsdr2.instance_number=2
      *.job_queue_processes=10
      *.log_archive_dest_1='location=/database/timsdr/archivelog/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)db_unique_name=TIMSDR'
      *.log_archive_dest_2='service=TIMS valid_for=(online_logfiles,primary_role) db_unique_name=TIMS'
      Db_file_name_conver=’/database/tims’,’/database/timsdr’
      Log_file_name_covnert=’/database/tims’,’/database/timsdr’
      *.log_archive_dest_state_2='ENABLE'
      *.log_archive_format='ARC_%S_%T_%R'
      *.open_cursors=1000
      *.pga_aggregate_target=1168113664
      *.processes=700
      *.remote_listener='LISTENERS_TIMSDR'
      *.remote_login_passwordfile='exclusive'
      *.sessions=900
      *.sga_target=5601492992
      *.standby_file_management='auto'
      timsdr2.thread=2
      timsdr1.thread=1
      *.undo_management='AUTO'
      timsdr1.undo_tablespace='UNDOTBS1'
      timsdr 2.undo_tablespace='UNDOTBS2'
      TIMSDR1.LOCAL_LISTENER=LISTENER_TIMSDR_HOST1
      TIMSDR2.LOCAL_LISTENER=LISTENER_TIMSDR_HOST2
      Log_archive_config=’dg_config=(TIMSDR,TIMS)’
      *.user_dump_dest='/u02/app/oracle/product/database/admin/tims/udump'
      *.utl_file_dir='/home/oracle'


      Thanks in advance..

      Regards

      SAM