Re: question concerning backup, archive logs and recovery

"Jose Nicolau" <jose.nicolau_at_clix.pt> wrote in message news:3AC5FD6F.EEB5C24C_at_clix.pt...
> At table level you can do that, but at tablespace level I don't know.
>

You most certainly can NOT switch off redo for a table. Specifying NOLOGGING for a table means that certain special forms of DML are not logged. Ordinary inserts, updates and deletes are STILL logged.

Regards
HJR
> Petra Hein/Gerald Bauer wrote:
>
> > Hi,
> >
> > We have a database running in archive log mode.
> > Is it possible to exclude specific tablespaces from archiving (i.e. all
> > inserts, updates, deletes for these specific tablespaces should not
 produce
> > archive log entries) ?
> >
> > The question arises, because we would like to have two completely
 different
> > applications' data stored in one database (Each application has its own
> > tablespaces.) :
> >
> > The first application is currently backed up by making consistent
 exports of
> > specific users at specific times. There is not necessarily the need to
 run
> > this application in archive log mode.
> >
> > The second application definitely must run in archive log mode.
> >
> > Thanks,
> > Gerald
>
Received on Sat Mar 31 2001 - 04:26:32 CST