Bismillah


Why would you want to re-create your controlfile just to increase the
size of your redo?

Its more work than its worth. Plus recreating your controlfiles means
that you need to do incomplete recovery to open the database. Plus
recreating your controlfiles could break rman.


besides all of that, Its not a problem to change the size of redo
via the create control file command. I have done it many times,
but only because I was going to recreate the control file any way.

Besides if you drop and create the log files with larger sizes, this
can be done without stopping the database. I have done this many times
while the production database is in use during the day. (THIS COULD BE
A BIT DANGEROUS BECAUSE REMOVING (i.e. deleting) A LOG FILE THAT HAS NOT
BEEN DROPPED
FROM THE DATA DICTIONARY IS BAD).


hth

peace




-----Original Message-----
From: muhammad.salman.[Email Address Removed] Friday, November 30, 2001 1:16 AM
To: LazyDBA.com Discussion
Subject: RESIZE OF ONLINE REDOLOGS



Bismillah

Hi All !

When ever we need to resize Online Redo Logs ORacle Recommend to

re-create new redo logs with bigger size.

I didnt get when re-creating Control file can also resize Redologs then

why it is not recommended .

Best Regards

Your DBA

Salman Faheem

---------------------------------------------------------------------------
This message (including any attachments) is confidential and may be
privileged. If you have received it by mistake please notify the sender by
return e-mail and delete this message from your system. Any unauthorised
use or dissemination of this message in whole or in part is strictly
prohibited. Please note that e-mails are susceptible to change. ABN AMRO
Bank N.V. (including its group companies) shall not be liable for the
improper or incomplete transmission of the information contained in this
communication nor for any delay in its receipt or damage to your system.
ABN AMRO Bank N.V. (or its group companies) does not guarantee that the
integrity of this communication has been maintained nor that this
communication is free of viruses, interceptions or interference.
---------------------------------------------------------------------------


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page