I can say, it is better to create new group members of redo logs with bigger
volumes
and delete the smaller ones later after switching logfiles.
To add a new member to a logfile group:
SQL> alter database add member logfile
'/data01/oracle/fpslippers/redo1b.log' to group 1;
To drop a logfile group member:
SQL> alter database drop logfile member
'/data01/oracle/fpslippers/redo1b.log';
After any change to redo logfiles performing the following will manually
switch the logfile.
SQL>alter system switch logfile;
Let me know once you are done or any problems.
Cheers
Baral
-----Original Message-----
From: Nabil Jamaleddin [mailto:Nabil.[Email Address Removed] Friday, November 30, 2001 4:00 PM
To: LazyDBA.com Discussion
Subject: RE: RESIZE OF ONLINE REDOLOGS
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 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
*****************************************************************************
This message is confidential and for use by the addressee only. If you
are not the intended recipient, you must not use, disclose, distribute,
copy, print, or rely on this message. Please notify the sender by
return email and then delete the message from your computer. Royal Skandia
accepts no responsibility for changes made to this message after it was
sent nor for any loss or damage from receipt or use.
Royal Skandia Life Assurance Limited - a member of the Skandia Group of
Companies - Reg No: 24916 Isle of Man - Registered Office: Skandia
House, Finch Road, Douglas, Isle of Man IM99 1NU, British Isles - Regulated
by the Personal Investment Authority for UK Investment Business -
Member of the Association of International Life Offices.
Internet: http://www.royalskandia.com
*****************************************************************************
Oracle LazyDBA home page