SQL> alter database rename file 'F:\ORACLE\TEST\DISK3\REDO4A.LOG' to 'F:\ORACLE\TEST\DISK3\REDO04A.LOG';
alter database rename file 'F:\ORACLE\TEST\DISK3\REDO4A.LOG' to 'F:\ORACLE\TEST\DISK3\REDO04A.LOG'
*
第 1 行出现错误:
ORA-01511: 重命名日志/数据文件时出错
ORA-01512: 重命名日志文件 F:\ORACLE\TEST\DISK3\REDO4A.LOG 时出错 - 未找到新文件 F:\ORACLE\TEST\DISK3\REDO04A.LOG
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
1 1 5 52428800 1 NO CURRENT 605205 03-3月 -12
2 1 3 52428800 1 YES INACTIVE 573618 03-3月 -12
3 1 4 52428800 1 YES INACTIVE 599438 03-3月 -12
4 1 0 15728640 2 YES UNUSED 0
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
3 ONLINE F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORACLE\REDO03.LOG NO
2 STALE ONLINE F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORACLE\REDO02.LOG NO
1 ONLINE F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORACLE\REDO01.LOG NO
4 ONLINE F:\ORACLE\TEST\DISK3\REDO4A.LOG NO
4 ONLINE F:\ORACLE\TEST\DISK6\REDO04B.LOG NO