[img]http://dl2.iteye.com/upload/attachment/0099/4458/60d1b537-bc31-3a81-9669-a8039f7c20fe.jpg[/img]
1.关闭数据库
shutdown
2.使用os 命令将redo log files 拷贝到新的位置
mv /u01/app/Oracle/oradata/MYNEWDB/onlinelog/o1_mf_1_89y70t1b_.log /home/o1_mf_1_89y70t1b_test.log
3.启动数据库,只装载,不打开。
CONNECT / as SYSDBA
STARTUP MOUNT
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
1.关闭数据库
shutdown
2.使用os 命令将redo log files 拷贝到新的位置
mv /u01/app/Oracle/oradata/MYNEWDB/onlinelog/o1_mf_1_89y70t1b_.log /home/o1_mf_1_89y70t1b_test.log
3.启动数据库,只装载,不打开。
CONNECT / as SYSDBA
STARTUP MOUNT
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