Oracle 变更redo log文件位置

更改Oracle数据库的Redo log文件位置，可以按照以下步骤操作。

1.查询当前Redo log文件信息

select * from v$log;
select * from v$logfile;

通过查询结果可知Redo log文件放在/oradata/redofile 目录下。

2.拷贝redo log文件到新的位置/Data/redolog

$cd /oradata/redofile
$cp redo01.log /Data/redolog/
$ cp redo02.log /Data/redolog/
$ cp redo03.log /Data/redolog/
$ cp redo05.log /Data/redolog/
$ cp redo06.log /Data/redolog/
$ cp redo07.log /Data/redolog/

注意：这里因为查询到 redo04.log 的STATUS 值为CURRENT，所以先不处理，待STATUS为INACTIVE时再处理。

3.重命名redo log member
使用ALTER DATABASE命令更改Redo log文件的位置：

SQL> ALTER DATABASE RENAME FILE '/oradata/redofile/redo01.log' TO '/Data/redolog/redo01.log';Database altered.SQL> ALTER DATABASE RENAME FILE '/oradata/redofile/redo02.log' TO '/Data/redolog/redo02.log';Database altered.SQL> ALTER DATABASE RENAME FILE '/oradata/redofile/redo03.log' TO '/Data/redolog/redo03.log';Database altered.SQL> ALTER DATABASE RENAME FILE '/oradata/redofile/redo05.log' TO '/Data/redolog/redo05.log';Database altered.SQL> ALTER DATABASE RENAME FILE '/oradata/redofile/redo06.log' TO '/Data/redolog/redo06.log';Database altered.SQL> ALTER DATABASE RENAME FILE '/oradata/redofile/redo07.log' TO '/Data/redolog/redo07.log';Database altered.

4.待edo04.log 的STATUS 变成INACTIVE时处理

$cd /oradata/redofile
$cp redo04.log /Data/redolog/

SQL> ALTER DATABASE RENAME FILE '/oradata/redofile/redo04.log' TO '/Data/redolog/redo04.log';Database altered.

5.查询当前Redo log文件信息

select * from v$log;
select * from v$logfile;

通过查询结果可知Redo log文件已迁移至/Data/redolog 目录下。