Re: Dropping Online Log Files

So if I shut the database down and then startup mount, do I then drop the redo file? If so, doesn't this file still contain tranactions?

-Chuck

Anton Buijs wrote:
> Chuck Carson <ccarson_No.Spammo_at_echeeba.com> schreef in berichtnieuws
> 3EBD421C.2080808_at_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
> |
>
> You can't drop the group when it is in use. One or more forced switches may
> be required to achieve your goal.
> Don't forget to remove the dropped redo log files from the filesystem
> yourself. When on Unix I always use fuser to really be 100% sure no database
> process has the file still open.
>
>
Received on Sat May 10 2003 - 16:33:28 CDT