question concerning backup, archive logs and recovery

From: Petra Hein/Gerald Bauer <Petra.Hein-Gerald.Bauer_at_t-online.de>
Date: Fri, 30 Mar 2001 09:13:51 +0200
Message-ID: <9a1bag$2h4$04$1@news.t-online.com>

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 Fri Mar 30 2001 - 01:13:51 CST