Re: Dropping Online Log Files

From: Chuck Carson <ccarson_No.Spammo_at_echeeba.com>
Date: Sat, 10 May 2003 11:17:00 -0700
Message-ID: <3EBD421C.2080808@echeeba.com>

Connor McDonald wrote:
> Chuck Carson wrote:
>

>>I currently have 5 groups of redo logs and want to reduce this to only
>>2. How can this be achieved? I am running 9.2.0.1 on Solaris 8.
>>
>>Thanks,
>>CC

>
>
> alter database drop logfile group n;
>
> Is there any problem with having 5 ?
>
> hth
> connor

Do I force a log switch first or what is the exact procedure? The reason I do not want 5 anymore is that I am going to dedicated logging disks and can only spare 8 disks (4 disks with mirrors), thus redo1a & 1b, and redo 2a & 2b.

Thanks for the help. I am a sys admin turned DBA so still learning the ropes.

-CC Received on Sat May 10 2003 - 13:17:00 CDT