4 Replies Latest reply: Apr 27, 2012 4:58 AM by Fran RSS

    How to configure RAC TO RAC DATAGUARD..

    user29991
      Dear All,

      i want to configure rac to rac dataguard 10g( primary is having 2 nodes and standby also 2 nodes).

      Pls shear the valuable suggestion/documents to do this activity at your earliest time..

      oracle 10g/os linux5



      Thanks in advance...




      Regards,
      SAM
        • 1. Re: How to configure RAC TO RAC DATAGUARD..
          mBk77
          http://docs.oracle.com/cd/B19306_01/server.102/b14239/rac_support.htm
          • 2. Re: How to configure RAC TO RAC DATAGUARD..
            Shivananda Rao
            Please refer http://www.oracle.com/technetwork/database/features/availability/maa-wp-10g-racprimaryracphysicalsta-131940.pdf
            • 3. Re: How to configure RAC TO RAC DATAGUARD..
              user29991
              Thanks for your immediate replay..

              My primary sid parameter file is as below....what changes i have to do in dr(rac) side..



              tims1.__db_cache_size=4529848320
              tims2.__db_cache_size=4580179968
              tims1.__java_pool_size=33554432
              tims2.__java_pool_size=33554432
              tims1.__large_pool_size=16777216
              tims2.__large_pool_size=16777216
              tims1.__shared_pool_size=1006632960
              tims2.__shared_pool_size=956301312
              tims1.__streams_pool_size=0
              tims2.__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
              *.compatible='10.2.0.1.0'
              *.control_files='/database/tims/control01.ctl','/database/tims/control02.ctl','/database/tims/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='tims'
              *.fal_server='drlnk'
              tims1.instance_number=1
              tims2.instance_number=2
              *.job_queue_processes=10
              *.log_archive_dest_1='location="/database/archivelog/" MANDATORY REOPEN'
              *.log_archive_dest_2='service="drlnk"','LGWR SYNC AFFIRM delay=0 OPTIONAL max_failure=0 reopen=300 register'
              *.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_TIMS'
              *.remote_login_passwordfile='exclusive'
              *.sessions=900
              *.sga_target=5601492992
              *.standby_file_management='auto'
              tims2.thread=2
              tims1.thread=1
              *.undo_management='AUTO'
              tims1.undo_tablespace='UNDOTBS1'
              tims2.undo_tablespace='UNDOTBS2'
              *.user_dump_dest='/u02/app/oracle/product/database/admin/tims/udump'
              *.utl_file_dir='/home/oracle'

              Pls help..


              Regards.
              • 4. Re: How to configure RAC TO RAC DATAGUARD..
                Fran
                are you kidding us?

                He gives you the documentation necessary to understand and do it step by step. do you read the document? or just want that we told you step by step.

                Lazy people makes go out a lot of Oracle gurus of this forum......