DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: replication off

  1. 02-13-2002, 10:45 AM #1
    Prasy
    Prasy is offline Junior Member
    Join Date
    Feb 2001
    Posts
    83
    How do we switch off replication for an import session, if its possible ??
    with regards
    Prasanna S
    Reply With Quote Reply With Quote
  2. 02-13-2002, 11:41 AM #2
    aarroyob
    aarroyob is offline Senior Advisor
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    You can execute the next to stop replication:

    exec dbms_repcat.suspend_master_activity('Refresh_group')

    For start replication:

    exec dbms_repcat.resume_master_activity('Refresh_group','true/false')

    Check the documentation for putting true or false

    Regards

    Angel
    Reply With Quote Reply With Quote
  3. 02-13-2002, 12:19 PM #3
    Prasy
    Prasy is offline Junior Member
    Join Date
    Feb 2001
    Posts
    83
    When u execute suspend_replication_activity, the group's status becomes quiesced. I hope we cannot access the objects in a group which is in quiesced mode. What do u think ??
    with regards
    Prasanna S
    Reply With Quote Reply With Quote
  4. 02-13-2002, 12:27 PM #4
    aarroyob
    aarroyob is offline Senior Advisor
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    As I understand you can access this tables, but with old information

    You only suspend the activity of the propagator, not the access.

    Regards

    Angel
    Reply With Quote Reply With Quote
  5. 02-14-2002, 05:30 PM #5
    Prasy
    Prasy is offline Junior Member
    Join Date
    Feb 2001
    Posts
    83
    Its said that no DML can be performed when the group is in quiesced state
    with regards
    Prasanna S
    Reply With Quote Reply With Quote
  6. 02-14-2002, 06:30 PM #6
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Depend whether or not you are using SYNCRONOUS or ASYNCRONOUS replication. SYNCRONOUS you can't susped replication, you must remove it. Asyncronous... depends on how much you are importing.

    Cheers
    OCP 8i, 9i DBA
    Brisbane Australia
    Reply With Quote Reply With Quote
  7. 02-15-2002, 12:59 PM #7
    Prasy
    Prasy is offline Junior Member
    Join Date
    Feb 2001
    Posts
    83
    How much you are importing ?? I couldn't understand !! My env. is async. and i want to import a table in a master site, without propagating the new changes to other sites
    with regards
    Prasanna S
    Reply With Quote Reply With Quote
  8. 02-21-2002, 06:25 PM #8
    Prasy
    Prasy is offline Junior Member
    Join Date
    Feb 2001
    Posts
    83
    Any help is appreciated..
    with regards
    Prasanna S
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width