RE: Adding redo log member

From: Rolle, Francis <FRolle_at_oaklandnet.com>
Date: Mon, 24 Jul 2000 10:11:53 -0700
Message-Id: <10568.112768@fatcity.com>

Yes you can add new redo log groups and members while users are accessing the database. Be sure to make new redo log members the same size as your existing ones. If however, you want to change the size of your redo logs....then create a new redo log groups with the increase size then issue the alter database switch log command several time to change to the new redo log groups and then remove the old ones.

Francis

		-----Original Message-----
		From:	root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf
Of Ashish Shah
		Sent:	Monday, July 24, 2000 8:37 AM
		To:	Multiple recipients of list ORACLE-L
		Subject:	Adding redo log member

		Hi All,

		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?

		I just want to double check before I issue 
		alter database ....

		Thanks.


		=====
		Ashish
		Toronto, Canada

		__________________________________________________
		Do You Yahoo!?
		Get Yahoo! Mail - Free email you can access from anywhere!
		http://mail.yahoo.com/
		-- 
		Author: Ashish Shah
		  INET: ar_shah_at_yahoo.com

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /

Mailing Lists         

---

                To REMOVE yourself from this mailing list, send an E-Mail message

                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

		the message BODY, include a line containing: UNSUB ORACLE-L
		(or the name of mailing list you want to be removed from).
You may
		also send the HELP command for other information (like

Received on Mon Jul 24 2000 - 12:11:53 CDT