Nguyen, David M wrote:
How do I increase size of redo logs and how do I create additional redo
logs?
Thanks,
David
--
ALTER DATABASE
You must drop and recreate log files to change their size, which will
bring you to force a log switch.
--
Regards,
Stephane Faroult
Oriole Software
--
First,
Check for the one that is not the current one.
Select * from V$log;
ALTER DATABASE DROP LOGFILE '/u01/oradata/orcl/redo01.log';
delete the file manually
ALTER DATABASE ADD LOGFILE '/u01/oradata/orcl/redo01.log' size 30M;
Change your size to your desire one.
For the other ones do the
You also might need to do an
alter database checkpoint;
if you get a particular error when you try to drop the log (don't remember
it offhand, I always recognize it when I see it :).
Jay Miller
-Original Message-
Sent: Monday, July 08, 2002 2:04 PM
To: Multiple recipients of list
Look on Metalink for Note # 30910.1
It's an excellent guide for recreating redo logs as well as other objects.
Shirley
-Original Message-
Sent: Monday, July 08, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Increase size of REDO log
Nguyen, David M
How about if I use LogMiner to read redo log to check which transaction had
been modified in 5 days ago, how do I know which redo log to look at?
Thanks,
David
-Original Message-
Sent: Monday, July 08, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L
First,
Check for the one
5 days ago ? check your alert log for the date and time of log switch
-Original Message-
Sent: 09 July 2002 04:14
To: Multiple recipients of list ORACLE-L
How about if I use LogMiner to read redo log to check which transaction had
been modified in 5 days ago, how do I know which redo