Re: Dropping Online Log Files

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 - 15:49:08 CDT