Re: What to do with archived redo-logs ?

> 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.

But beware!

1. You need to do a cold backup after you have restarted archivelog mode.
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.

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=
  Received on Wed Jan 07 1998 - 00:00:00 CST