Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> resizing redo

resizing redo

From: <nitin_kaul_at_rediffmail.com>
Date: 22 Sep 2005 05:51:58 -0700
Message-ID: <1127393518.750763.228480@f14g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US