Re: Redo logs: more/larger/location ?

>Alter Database Add Logfile Group 4 'file path' size 32m;
will add a Redolog file . You can thus add files to handle your current transaction with increased size and then drop the existing ( inactive) ones with Smaller Size using
>Alter system switch logfile ; # this can be used to cycle the redo log
files
> Select * from v$log; # to show the status of the log groups
>Alter DAtabase drop logfile group 1;

etc

The 'file path' may have a new location ..this will move U'r location of the redo logs..

Hope this helps..

-Thiru

"Joe M." wrote:

> How do you add more or increase the size of the redo logs? Also, I have
> moved the location of some tablespaces to reduce contention but how do I
> move the location of the redo logs?
>
> Thanks,
> jm
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Sep 20 1999 - 13:23:07 CDT