Snapshot logs getting bigger
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Snapshot logs getting bigger

  1. #1
    Join Date
    Jan 2001
    Posts
    26
    I had several snapshot sites refreshing from one master table.

    I have shutdown and de-commisioned one snapshot database (without breaking the refresh jobs) and this has cause the snapshot log tables in the master site to grow.

    I have tried to use dbms_snapshot.purge_log procedure to clean the snapshots logs but it does not clean it.

    Dropping snapshots and recreating them on several sites is a pain.

    Is there any other way to clean the snapshot logs ?
    Why did purge_log procedure did not clean the snapshot log tables ?

    Thx

    - Jignesh






  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    You can truncate the logs but this may cause you snapshots to be out of sink. Alternatively just do a complete refresh of all snapshots, rather than a rebuild.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Originally posted by jdjoshi

    I have shutdown and de-commisioned one snapshot database (without breaking the refresh jobs) and this has cause the snapshot log tables in the master site to grow.

    Dropping snapshots and recreating them on several sites is a pain.

    Is there any other way to clean the snapshot logs ?
    Why did purge_log procedure did not clean the snapshot log tables ?


    To truncate the snapshot logs and prevent future trouble, you must drop the snapshot in the shutdown database and recreate the snapshot log.
    There is steps on replication admin guide, talking about this steps.
    After recreate the snapshot log, just do a full refresh of all snapshot site, and it will be ok later.
    www.cnoug.org

Posting Permissions

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



Click Here to Expand Forum to Full Width