移动Online Redo Log Files的方法

方法1：

1). Shut down the database.

sql>shutdown immediate;

2). Use an operating system command to move the files.

3). Mount the database.

conn /as sysdba

startup mount

4). Execute the ALTER DATABASE RENAME FILE command.

alter database rename file

‘$home/oradata/u01/log2a.rdo’

TO ‘$home/oradata/u02/log1c.rdo’;

5). Open the database.

alter database open;

方法二：

Steps to rename a online redo log file:

1.如果视图正处于active状态
alter system switch logfile;--如果此时这个log正处于active状态的话，可以在视图V$LOG中查看到

2.Use an OS command to move or copy the files.

3.Execute the ALTER database rename FILE command.
  alter database rename file ‘u01/oradata/denver/redo01.log’

   to ‘/u01/oradata/redo01.log’;--注意这里的redo01.log必须存在

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29840459/viewspace-1479705/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29840459/viewspace-1479705/