ALTER DATABASE DATAFILE '/u01/oracle/data/redo/redo1.log' resize 5m;
The path given and the name of the file is correct. But it throws the error
ORA-03296: cannot resize datafile - file
/nbd07/oracle/product/8.1.5/oradata/oratest/redolog1.log not found
Hope I can resize online redolog file like any other datafile. There is no problem when I resize a DATA datafile.
Anybody came across this kind of problem?
06-20-2002, 03:01 AM
you have to drop logfile groups a recreate them new size.
06-20-2002, 03:04 AM
I know this.
My question is, is it possible to rersize online redo log file.
06-20-2002, 03:12 AM
You have to create new redologs with newsize and drop the old one.
06-20-2002, 03:22 AM
So, I think the RESIZE option is only applicable for datafiles other than online log files.
06-20-2002, 03:24 AM
LoGFiles are not organized as the other datafiles.
They are not written with blocks but like a byte-stream.
Another different is that orcale supports morroring for logfiles,
probably due to this feature it is not possible to increase the size?
They way to increase the size is as written.
* add new bigger log-groups
* switch logfile to the new groups
* delete/drop the old groups
06-20-2002, 03:46 AM
Of course Oracle provides mirroring! But could that be the reason not to allow RESIZE? No idea!
Could u elaborate on byte-stream writting.
Any idea why Oracle is writting redologs in byte stream instead of Blocks.
06-20-2002, 06:13 AM
A DATAFILE IS NOT A LOGFILE;
Oracle handles both different.
ALTER DATABASE ...DATAFILE ...
changes only DATAFILES but not LOGFILES and NOT CONTROLFILES AND NOT SPFILES;
I hope you can live with that ;-)
06-22-2002, 02:44 AM
What you said is the basic thing and not the answer to my question!
Does anybody else got into this?
06-24-2002, 12:31 AM
You cannot resize online redolog file.. i repeat
you CANNOT resize online redolog file..
but if you still want to.. there is a trick to do that...
1. create new larger redolog file <- make 2 or 3 files
2. switch current onle redo log file to the u havae created one
3. drop the 'old' online redo log file