Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> resizing redo
hi
A weird thought...Am trying to resize the redolog file using following..i know it doest not happen..then only way is to drop and recreate the group member..but why am i gettin that error about nonexistent log file...just wanna know under the hood stuff..
SQL> select member from v$logfile;
MEMBER
E:\ORACLE\ORADATA\ORA10G\REDO03.LOG E:\ORACLE\ORADATA\ORA10G\REDO02.LOG E:\ORACLE\ORADATA\ORA10G\REDO01.LOG
SQL> alter database datafile 'E:\ORACLE\ORADATA\ORA10G\REDO01.LOG'
resize 3M;
alter database datafile 'E:\ORACLE\ORADATA\ORA10G\REDO01.LOG' resize 3M
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile
"E:\ORACLE\ORADATA\ORA10G\REDO01.LOG"
regards
Received on Thu Sep 22 2005 - 07:51:58 CDT