How to set
ARCHIVELOG?
I'm using Oracle 8.05 (standard
edition) and seeking some help
on backup strategy. I want
my DB avaible 24H/24, so according to the docs,
the only solution for me is
to use ARCHIVELOG mode and hot backup. But,
once a day, I fill DB with
~1.000.000 lines, do lot of updates, queries, ...
and then delete the whole
table. These operations generate a lot of redo log
files. Datas used is this
temporary table are not critical, I can afford to
loose them.
So my question is: is
a way to completely disable logging for a
table (or tablespace) ? I've
read docs carefully and the answers seems
to be "no". Any ideas ?
Ans1:
Can you change your strategy
from
'insert
and update'
to
'create
as select'
If so switch the tablespace
to NOLOGGING,
and use the NOLOGGING options
for creating
tables and indexes.
This avoids the generation
of redo log.
There is also a parallel DML
insert option available
in 8.0, which allows you to
do NOLOGGING inserts,
but you may have to go for
a more expensive license
to do that.