Re: Snapshot Logs Explanation Needed

From: Tracy Rahmlow <Tracy.Rahmlow_at_aexp.com>
Date: Thu, 31 May 2001 12:11:07 -0700
Message-ID: <F001.0031669B.20010531114959@fatcity.com>

Hi Anita,
Ironically that is just what I am trying to do. (ie implement a storage plan which will address the issues discussed in the paper) To your other point, I understand oracle's position, but if I can prohibit changes to the master during the reorg/rebuild, is this still an issue?

---------------------- Forwarded by Tracy Rahmlow on 05/31/2001 12:37 PM
---------------------------

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> cc:

Tracy,

You may know that there were no modifications to the master table made from the time the snapshot log was dropped until it was recreated, but Oracle can't take that chance, otherwise data could get out of sync. That's why you have to either recreate your snapshot or do a complete refresh if the snapshot log is recreated.

To avoid recreating the snapshots I would ask why you need to reorg your master tables (i.e. what do you hope to accomplish by this)? If you're doing it for defragmentation reasons, I suggest you check out the excellent white paper "How to stop defragmenting and start living..." to see if this is really necessary.

http://www.vampired.net/articles/files/stopfrag.zip

HTH,

• Anita
  • Tracy Rahmlow <Tracy.Rahmlow_at_aexp.com> wrote:
    > I would like to reorg many tables which have
    > snapshots associated with them. I
    > understand that if the master table is dropped the
    > snapshot log is also
    > dropped. When a log is dropped, oracle states that
    > you need to do a complete
    > refresh of the affected snapshot. My question is
    > why? If you do not allow
    > users to access the database with the master table,
    > then you should not have
    > any transactions that would be lost. Why can't you
    > create a new log and
    > continue to do a fast refresh? I am trying to
    > avoid having to recreate all
    > the snapshots due to the size and number that we
    > have. Any thoughts? Thanks
    >
    >
    > --
    > Please see the official ORACLE-L FAQ:
    > http://www.orafaq.com
    > --
    > Author: Tracy Rahmlow
    > INET: Tracy.Rahmlow_at_aexp.com
    >
    > Fat City Network Services -- (858) 538-5051 FAX:
    > (858) 538-5051
    > San Diego, California -- Public Internet
    > access / Mailing Lists
    >
    

    ---

    
    > To REMOVE yourself from this mailing list, send an
    > E-Mail message
    > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > 'ListGuru') and in
    > the message BODY, include a line containing: UNSUB
    > ORACLE-L
    > (or the name of mailing list you want to be removed
    > from). You may
    > also send the HELP command for other information
    > (like subscribing).
    

    ---

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tracy Rahmlow
  INET: Tracy.Rahmlow_at_aexp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu May 31 2001 - 14:11:07 CDT