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

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


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博客 ” ，链接：http://blog.itpub.net/31399171/viewspace-2132458/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31399171/viewspace-2132458/