Re: archiving oracle

On 17 Jun 1998 16:13:58 GMT, Leo Kraaij <kraay_at_dds.nl> wrote:
>Hello,
>
>A oracle instance has huge archive files, approximately 25 Mb. A redolog
>switch takes every month(!) places. We want to change this to every two hours.
>How do we do that?

Either run a cron job that does the alter system switch logfile command or replace the files with smaller ones. The Server Administrators Guide is informative.

>
>thanks, Leo

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.