如果可以關(guān)閉數(shù)據(jù)庫(kù)，可以采用下述步驟。如果不能關(guān)閉數(shù)據(jù)庫(kù)，只能采用新建redo log files的方式來(lái)實(shí)現(xiàn)修改該redo 的路徑了。

一、shutdown the database

二、拷貝redo log 文件到新的位置

三、mount? database

四、重命名redo

五、open database

--1 .shutdown the databaseSQL>?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]$ lsredo01.rdo? redo02.rdo? redo03.rdo[oracle@oradb01 ctl]$ lltotal 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 sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 14 11:08:58 2011Copyright (c) 1982, 2011, Oracle.? All rights reserved.Connected to an idle instance.

--3 mount database

SQL>?startup mountORACLE instance started.

Total System Global Area 3273641984 bytesFixed Size????????????????? 2232800 bytesVariable Size???????????? 721423904 bytesDatabase Buffers???????? 2533359616 bytesRedo Buffers?????????????? 16625664 bytesDatabase mounted.

--4 ?重命名redo log filesSQL> 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.

總結(jié)

以上是生活随笔為你收集整理的oracle修改redolog路径,oracle修改redo log files路径的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。