在重做日志文件创建之后。有时候可能需要更改它们的名称或位置

1：查看日志路径
SQL> select group#,member from v$logfile;

GROUP# MEMBER
---------- --------------------------------------------------
3 /u01/app/oracle/oradata/ORA11GR2/redo03.log
2 /u01/app/oracle/oradata/ORA11GR2/redo02.log
1 /u01/app/oracle/oradata/ORA11GR2/redo01.log
4 /u01/app/oracle/oradata/ORA11GR2/redo04.log
4 /u01/app/oracle/oradata/ORA11GR2/redo04-a.log

SQL>

2：关闭数据库
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

3:手动复制源文件到目标位置，甚至可以对复制之后的文件进行重命名
[oracle@zh ORA11GR2]$ mv redo04-a.log /home/oracle/redo04a.log

4：将数据库启到mount状态
SQL> startup mount
ORACLE instance started.

Total System Global Area 830930944 bytes
Fixed Size 2257800 bytes
Variable Size 536874104 bytes
Database Buffers 285212672 bytes
Redo Buffers 6586368 bytes
Database mounted.
SQL>

5:进行修改日志组成员的路径
SQL> alter database rename file '/u01/app/oracle/oradata/ORA11GR2/redo04-a.log' to '/home/oracle/redo04a.log';

Database altered.

SQL>

6：将数据库启到open
SQL> alter database open;

Database altered.

SQL>

7：查看日志路径
SQL> select group#,member from v$logfile;

GROUP# MEMBER
---------- --------------------------------------------------
3 /u01/app/oracle/oradata/ORA11GR2/redo03.log
2 /u01/app/oracle/oradata/ORA11GR2/redo02.log
1 /u01/app/oracle/oradata/ORA11GR2/redo01.log
4 /u01/app/oracle/oradata/ORA11GR2/redo04.log
4 /home/oracle/redo04a.log

SQL>

ITPub博客

更改重做日志的名称或位置

最新文章