Skip to Main Content

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!

Failed to rename redlog file

535871Dec 12 2009 — edited Dec 12 2009
Experts!

We are facing below exceptions while renaming redo log file on oracle 10g,

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 3423965184 bytes
Fixed Size 2119752 bytes
Variable Size 1828718520 bytes
Database Buffers 1577058304 bytes
Redo Buffers 16068608 bytes
Database mounted.
SQL> ALTER DATABASE RENAME FILE 'E:\RMANDB\RMANDB\REDO01.LOG' TO 'E:\RMANDB\RMAN
DB\REDO09.LOG';
ALTER DATABASE RENAME FILE 'E:\RMANDB\RMANDB\REDO01.LOG' TO 'E:\RMANDB\RMANDB\RE
DO09.LOG'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01512: error renaming log file E:\RMANDB\RMANDB\REDO01.LOG - new file
E:\RMANDB\RMANDB\REDO09.LOG not found
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


Please suggest where we are making mistake...

Thanks,
This post has been answered by unknown-698157 on Dec 12 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2010
Added on Dec 12 2009
5 comments
1,459 views