Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: backup strategy

Re: backup strategy

From: Audun Jensen <audun_j_at_yahoo.no>
Date: 26 Feb 2001 14:35:51 GMT
Message-ID: <Xns90549EA33691Eaudun.jyahoo.no@130.133.1.4>

"Mike O" <ora7dba_at_yahoo.com> wrote in <976njd$cmm_at_nntpa.cb.lucent.com>:

>Well, as a general rule I backup/secure my databases using not only a
>tape system but also Oracle's EXP (export) utility. The export utility
>is relatively common, in the shops that I have been in.
>
>The ability to import (IMP) a specific schema is handy and quicker to
>use vs restoring a tablespace where the users objects are stored. Now
>keep in mind, a seperate tablespace (tbs) would be better than placing
>objects in a tbs with other objects not belonging to that user (for
>obvious reasons). Recovery of that tbs would require taking it offline
>which could affect more users than just the schema your concerned about.
>
>So the long and the short ... if this is an on the fly process .. I
>would export before/after your process. It depends on your
>requirements. Sounds like you maybe deleting or truncating or dropping
>objects .. so if you need to go back to a process time (mins, hours,
>days) .. just create your exports w/a time-date stamp.
>
>-Mike

One major thing is that this is a 3rd party application, and I'm not sure how to deal with this (meaning I don't know much about these things in the first place and I have no idea of how our future customers DBA-routines are regarding this). This implies that my solution should be "flexible" so these sites could do things like they are used too.

What I've thinking of is this:
Use one data- and one index tablespace for all schemas (to avoid many tablespaces and also datafiles).
But then the database also should be exported for instance daily to allow for importing a customers project if needed. Is it possible to run an "online" export? If so, how is consistency dealt with? How long will (approx.) an export of 25 Gb data take?

TIA AJ Received on Mon Feb 26 2001 - 08:35:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US