This discussion is archived
9 Replies Latest reply: May 7, 2012 3:52 AM by user29991 RSS

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

user29991 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points