Read Only Partitions for Speeding Backups
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Read Only Partitions for Speeding Backups

  1. #1
    Join Date
    Nov 2002
    Location
    Hampshire, UK
    Posts
    2

    Read Only Partitions for Speeding Backups

    A tech bod at our clients has suggested that we use read-only table partitions to speed up backups. Our table is partioned on a numeric representation of the date (e.g. 20020830) and whilst we need to have the data online, we don't expect to need to update anything more than a week (say) old. The logic goes that if the partitions were read only then there would be no need to back them up more than once.

    Is this plausible and, if so, what is the mechanism?

    We are using Oracle 8.1.7 on a Solaris box.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    It's feasable to use this kind of approach, but maybe you would do better to look at using RMAN. The backup can be much more aware of what data has changed, and would not continually backup the same unchanged data every time.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Read Only Partitions for Speeding Backups

    Originally posted by hurleyb
    Is this plausible and, if so, what is the mechanism?
    Sure this is plausible, in fact it is a very common aproach with very large databases.

    The mechanism? Well, you can't make a table or a partition a "read only" there is no such option. However you can make a tablespace read only. So the tables/partition that are not subject to changes should be moved to such read-only tablespaces. If you are putting partitions on read-only tablespaces, do not forget to do the same thing with their corresponding local indexes!

    Once those segments are put on the read-only tablespaces you have to back those tablespaces only once as nothing ever change in them. Of course this is just in theory - in praxis you would still backup those tablespaces periodicaly, but much much less often than you back up your other read-write tablespaces.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Nov 2002
    Location
    Hampshire, UK
    Posts
    2
    Thanks for the reply, that all sounds plausible and I have something to go on with.

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