RE: log file size change

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Wed, 03 Oct 2001 08:10:15 -0700
Message-ID: <F001.003A08D7.20011003081526@fatcity.com>

srinivas,
I would suggest that you look at this as 2 seperate tasks.

Relocating/rehosting the database, then
Resizing the redologs.

So leave the create controlfile script as is, then alter database to drop the 25M
log groups and add your new 5M log groups.

Mike Hand
Polaroid Corp

-----Original Message-----
[mailto:Shrinivas.Tatireddy_at_med.ge.com]
Sent: Wednesday, October 03, 2001 11:45 AM To: Multiple recipients of list ORACLE-L

Hi lists,

I need to do a refresh of the database (different servers)

in the source my logfile size is 25 Meg and I want to change it to 5 Meg in the target and recreate the db using controlfile.

I copied all files to target server, what should I change in the trace dump of controlfile.

should I use logfile 'file1','file2' size 5 M reuse.....

( Note: I use reset logs)

regards,
srinivas.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tatireddy, Shrinivas (MED, Keane) INET: Shrinivas.Tatireddy_at_med.ge.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 subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hand, Michael T
INET: HANDM_at_polaroid.com

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