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?
Click Here to Expand Forum to Full Width