189 8069 5689
如果可以关闭数据库，可以采用下述步骤。如果不能关闭数据库，只能采用新建redo log files的方式来实现修改该redo 的路径了。
我们提供的服务有：成都网站建设、网站设计、微信公众号开发、网站优化、网站认证、黄山区ssl等。为上千多家企事业单位解决了网站和推广的问题。提供周到的售前咨询和贴心的售后服务，是有科学管理、有技术的黄山区网站制作公司
一、shutdown the database
二、拷贝redo log 文件到新的位置
三、mount database
四、重命名redo
五、open database
--1 .shutdown the database
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
-- 2.拷贝redo log 文件到新的位置
[oracle@oradb01 orcl]$ mv /opt/ora11g/oradata/orcl/redo01.log /opt/ora11g/oradata/orcl/ctl/redo01.rdo
[oracle@oradb01 orcl]$ mv /opt/ora11g/oradata/orcl/redo02.log /opt/ora11g/oradata/orcl/ctl/redo02.rdo
[oracle@oradb01 orcl]$ mv /opt/ora11g/oradata/orcl/redo03.log /opt/ora11g/oradata/orcl/ctl/redo03.rdo
[oracle@oradb01 orcl]$ cd ctl
[oracle@oradb01 ctl]$ ls
redo01.rdo redo02.rdo redo03.rdo
[oracle@oradb01 ctl]$ ll
total 153792
-rw-r----- 1 oracle dba 52429312 Nov 14 10:43 redo01.rdo
-rw-r----- 1 oracle dba 52429312 Nov 14 10:43 redo02.rdo
-rw-r----- 1 oracle dba 52429312 Nov 14 11:00 redo03.rdo
[oracle@oradb01 ctl]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 14 11:08:58 2011
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
--3 mount database
SQL> startup mount
ORACLE instance started.
Total System Global Area 3273641984 bytes
Fixed Size 2232800 bytes
Variable Size 721423904 bytes
Database Buffers 2533359616 bytes
Redo Buffers 16625664 bytes
Database mounted.
--4 重命名redo log files
SQL> ALTER DATABASE RENAME FILE '/opt/ora11g/oradata/orcl/redo01.log' ,'/opt/ora11g/oradata/orcl/redo02.log','/opt/ora11g/oradata/orcl/redo03.log'
2 to '/opt/ora11g/oradata/orcl/ctl/redo01.rdo','/opt/ora11g/oradata/orcl/ctl/redo02.rdo','/opt/ora11g/oradata/orcl/ctl/redo03.rdo'
3 ;
Database altered.
-- 5. open database
SQL> alter database open;
Database altered.