oracle修改redologfiles路径

如果可以关闭数据库，可以采用下述步骤。如果不能关闭数据库，只能采用新建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.