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!

rename logfile in ASM

441858Apr 8 2008 — edited Apr 9 2008

Is there any way we can rename a logfile that is in ASM without dropping it and re-creating it?

alter database rename file '+DATA1/vmracdev/onlinelog/redog16l1_fprcprod.log' to '+DATA1/vmracdev/onlinelog/redog16l1_vmracdev.log';
alter database rename file '+DATA1/vmracdev/onlinelog/redog16l1_fprcprod.log' to '+DATA1/vmracdev/onlinelog/redog16l1_vmracdev.log'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01512: error renaming log file DATA1/vmracdev/onlinelog/redog16l1_fprcprod.log - new file DATA1/vmracdev/onlinelog/redog16l1_vmracdev.log not found
ORA-17503: ksfdopn:2 Failed to open file +DATA1/vmracdev/onlinelog/redog16l1_vmracdev.log
ORA-15173: entry 'redog16l1_vmracdev.log' does not exist in directory 'onlinelog'

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2008

Added on Apr 8 2008

#general-database-discussions

6 comments

2,630 views