Printable View
Hi,
Trying to resize online redologfile as below.
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?
Cheers
Hi,
you have to drop logfile groups a recreate them new size.
Hi,
I know this.
My question is, is it possible to rersize online redo log file.
Cheers
No.
You have to create new redologs with newsize and drop the old one.
Hi,
Good one!
So, I think the RESIZE option is only applicable for datafiles other than online log files.
Cheers
Hello,
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
Orca
Hi,
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.
Cheers
Hy;
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 ;-)
Orca
Hi,
What you said is the basic thing and not the answer to my question!
Does anybody else got into this?
Cheers
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
Hi;Quote:
Originally posted by najmalp
Hi,
What you said is the basic thing and not the answer to my question!
Does anybody else got into this?
Cheers
Sorry that i bored you with basic things, for me understanding the basics helps me to understand why different things works so different. And with Oracle you have a big universum to test this.
Orca
So, are you saying you can't resize an online redo log?Quote:
Originally posted by zainalj
You cannot resize online redolog file.. i repeat
you CANNOT resize online redolog file..