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: question concerning backup, archive logs and recovery

Re: question concerning backup, archive logs and recovery

From: Jose Nicolau <jose.nicolau_at_clix.pt>
Date: Sat, 31 Mar 2001 10:53:19 -0500
Message-ID: <3AC5FD6F.EEB5C24C@clix.pt>

At table level you can do that, but at tablespace level I don't know.

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 - 09:53:19 CST

Original text of this message

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