4.重命名redo log member
ALTER DATABASE RENAME FILE '/u01/app/oracle/oradata/MYNEWDB/onlinelog/o1_mf_1_89y70t1b_.log' TO '/home/o1_mf_1_89y70t1b_test.log';
5.打开数据库
alter database open;
6.确认是否已经切换到新的位置
SQL> select * from v$logfile;
rows will be truncated
GROUP# STATUS TYPE MEMBER
---------- ------- ------- -----------------------------------------------------
3 ONLINE /u01/app/oracle/oradata/MYNEWDB/onlinelog/o1_mf_3_814
2 ONLINE /u01/app/oracle/oradata/MYNEWDB/onlinelog/o1_mf_2_814
1 ONLINE /home/o1_mf_1_89y70t1b_test.log
4 ONLINE /u01/app/oracle/oradata/MYNEWDB/onlinelog/o1_mf_4_8b3