Re: Full Export Problem

Suggest following:

  Export 0- Full=y, rows=no::: Definition export of all database objects, but  No data. Can be used to recreate database Skeleton, users, tablespaces, etc. Export 1- Sys, System:: Usefule only if these id's have non data dictionary application tables. If they do, shame on you. Should only be used by Oracle internals. Export 2- Schema Set A Export 3- Schema Set b .....

We have been examining this type of scenario for our instances (we have 23, ranging from 50GB to 2TB). It may be usefule for i/o (idiot operator) errors like those who drop tables instead of truncateing them. If you are worried about PIT recovery, archive logging is better. Just get cold backups often. In article <Pine.OSF.3.95.981102130258.14634G-100000_at_gonzo.wolfenet.com>,   Jeremiah Wilton <jeremiah_at_wolfenet.com> wrote:
> On Mon, 2 Nov 1998, Mike Cahall wrote:
> >
> > Yes you can, but your point in time recovery will be different for each
> > group of exported tables, plus if you export across your constraints and
> > your constrained data has changed between the times of your exports, you
> > could have a real mess. I would suggest that instead you do incremental
> > exports for three groups at a time, while doing a full export of one group.
> > Then you could rotate your full exports around and still be able to recover
> > to the same point in time.
>
> Point in time recovery (PITR) does not work with EXPORT, unless you meant
> the point in time that the table got exported! PITR works only with
> databases in ARCHIVELOG mode and backups of datafile images (hot or cold)
> or RMAN backups.
>
> The incemental feature of EXP just backs up ALL of ANY table that got
> modified since the last incremental or full export. No roll forward to a
> point in time is possble with an export.
>
> --
> Jeremiah Wilton http://www.wolfenet.com/~jeremiah
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 03 1998 - 10:56:07 CST