Re: What to do with archived redo-logs ?

John P. Higgins wrote:
>
> > OK, this explains a lot, but I still have the following question :
> > Is it possible to switch this 'archive'-stuff off for a specific period
> > of time. E.g. before we start a big batch-job , and switch the
> > archiving back on after the job is done ?
>
> Of course you can do this.

HOW can I do that ?
Do I have to restart my ORACLE DATABASE to switch it off an back on, or can I do this ONLINE (= without restarting the database ?)

>
> But beware!
>
> 1) You need to do a cold backup after you have restarted archivelog
> mode.

Why ?
Why shouldn't I do a normal (Online backup) backup ?

>
> 2) If your database crashes before the new cold backup finishes, you
> must recover up to the point archiving stopped and then re-run the big
> batch job.

Of course, but this can be accepted.

Thanks for the answers I have received until now.. Greetings,
  Chris MARREEL.
>
> John
>
> > Why this question : I only have 3 Gbyte of space available to place the
> > archived redo-logs. During normal working days this is more than
> > enough, but during weekends we start so many batch-jobs who do a great
> > amount of update's on the database and my 3Gbytes if space isn't enough
> > to hold all the archived redo-logs.
> > Thanks in advance
> > Chris MARREEL.
> > --
> > ====================================================================
> > BEKAERT ENGINEERING Tel : 32 / 51 / 333 515
> > Meulebekestraat 139 Fax : 32 / 51 / 333 472
> > 8770 - INGELMUSTER -----------\
> > West-Vlaanderen (BELGIUM) /------\ |
> > | | / |
> > Name : MARREEL Chris | |----\ |
> > Function : System Administrator | | | |
> > Compuserve : 106101,1624 | \----/ | \\|//
> > INTERNET Email: MARREEL_CHRIS/BENG_at_bekaert.com\--------/ (o o)
> > =======================================================oOOo=(_)=oOOo=
 

-- 
====================================================================
BEKAERT ENGINEERING                  Tel : 32 / 51 / 333 515
Meulebekestraat  139                 Fax : 32 / 51 / 333 472
8770 - INGELMUSTER                          -----------\
   West-Vlaanderen (BELGIUM)                  /------\ |
                                              | |    / |
Name          : MARREEL Chris                 | |----\ |
Function      : System Administrator          | |    | |
Compuserve    : 106101,1624                   | \----/ |   \\|//
INTERNET Email: MARREEL_CHRIS/BENG_at_bekaert.com\--------/   (o o)
=======================================================oOOo=(_)=oOOo=