Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02236: invalid file name while creating standby redo

krishnakripMay 12 2014 — edited May 13 2014

i am getting ora -02236 while creating standby redo................. why is it so?

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

PL/SQL Release 10.2.0.1.0 - Production

CORE 10.2.0.1.0 Production

TNS for Linux: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

SQL> set lines 300;

SQL> set pages 300;

SQL> /

GROUP# STATUS TYPE MEMBER IS_

---------- ------- ------- ------------------------------ ---

3 ONLINE /u01/oracle/oradata/HITHA/redo NO

03.log

2 ONLINE /u01/oracle/oradata/HITHA/redo NO

02.log

1 STALE ONLINE /u01/oracle/oradata/HITHA/redo NO

01.log

SQL> select bytes from v$log;

BYTES

----------

52428800

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 SIZE 50M;

ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 SIZE 50M

ERROR at line 1:

ORA-02236: invalid file name

SQL> ALTER DATABASE ADD STANDBY LOGFILE SIZE 50M;

ALTER DATABASE ADD STANDBY LOGFILE SIZE 50M

ERROR at line 1:

ORA-02236: invalid file name

This post has been answered by krishnakrip on May 12 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2014

Added on May 12 2014

#general-database-discussions

4 comments

9,926 views