oracle修改redo log files路径
如果可以关闭数据库，可以采用下述步骤。如果不能关闭数据库，只能采用新建redo log files的方式来实现修改该redo 的路径了。一、shutdown the database
二、拷贝redo log 文件到新的位置
三、mountdatabase
四、重命名redo
五、open database
--1 .shutdown the database
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
-- 2.拷贝redo log 文件到新的位置
$ mv /opt/ora11g/oradata/orcl/redo01.log /opt/ora11g/oradata/orcl/ctl/redo01.rdo
$mv /opt/ora11g/oradata/orcl/redo02.log /opt/ora11g/oradata/orcl/ctl/redo02.rdo
$ mv /opt/ora11g/oradata/orcl/redo03.log /opt/ora11g/oradata/orcl/ctl/redo03.rdo
$ cd ctl
$ ls
redo01.rdoredo02.rdoredo03.rdo
$ 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
$ sqlplus / as sysdba
SQL*Plus:> Copyright (c) 1982, 2011, Oracle.All rights reserved.
Connected to an> --3 mount database
SQL> startup mount
ORACLE instance started.
Total System Global Area 3273641984 bytes
Fixed>
Variable> Database Buffers 2533359616 bytes
Redo Buffers 16625664 bytes
Database mounted.
--4重命名redo log files
SQL>> 2to '/opt/ora11g/oradata/orcl/ctl/redo01.rdo','/opt/ora11g/oradata/orcl/ctl/redo02.rdo','/opt/ora11g/oradata/orcl/ctl/redo03.rdo'
3;
Database> -- 5. opendatabase
SQL>>
Database>
页:
[1]