RE: Adding redo log member

From: Larry Holder <lholder_at_utm.edu>
Date: Tue, 25 Jul 2000 09:06:40 -0500
Message-Id: <10569.112875@fatcity.com>

>I have a heavy transaction database. I want to
>add redo log member online while users are using
>the database.
>Is there any problem with doing that?
>Ashish
>Toronto, Canada

No, no problem with that. I have even resized redo logs (by deleting and then re-adding at different size) while production was up. In the case of deleting, I first made sure which redo log was currrently active (by issuing a SELECT * FROM V$LOG) and first doing all the inactive logs, then a logswitch to make the active one inactive.

Larry Holder
Senior Systems Analyst, Oracle Database Administrator The University of Tennessee at Martin Computer Center lholder_at_utm.edu (901) 587-7890 www.utm.edu/~lholder Saved by grace <>< Romans 8:38-39 Received on Tue Jul 25 2000 - 09:06:40 CDT