Oracle 重做日志成员重名命及迁移

1、先查看日志成员信息
05:07:37 SQL> select group#,member from v$logfile order by 1;
GROUP# MEMBER
---------- --------------------------------------------------
1 /u01/app/oracle/oradata/lx02/redo01a.log
1 /disk1/lx02/oradata/redo01b.log
2 /disk1/lx02/oradata/redo02b.log
2 /u01/app/oracle/oradata/lx02/redo02a.log
3 /disk1/lx02/oradata/redo03b.log
3 /u01/app/oracle/oradata/lx02/redo03a.log
6 rows selected.
05:07:43 SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
05:08:01 SQL> !

2、复制日志成员
[oracle@oracle ~]$ cp /u01/app/oracle/oradata/lx02/redo01a.log /disk2/lx02/oradata/
[oracle@oracle ~]$ cp /u01/app/oracle/oradata/lx02/redo02a.log /disk2/lx02/oradata
[oracle@oracle ~]$ cp /u01/app/oracle/oradata/lx02/redo03a.log /disk2/lx02/oradata
[oracle@oracle ~]$ !sql
sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 2 05:08:35 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
05:08:35 SQL> startup mount
ORACLE instance started.
Total System Global Area  251658240 bytes
Fixed Size                  1218820 bytes
Variable Size             125830908 bytes
Database Buffers          121634816 bytes
Redo Buffers                2973696 bytes
Database mounted.
05:08:43 SQL> col member for a50
05:08:49 SQL> select group# ,member from v$logfile order by 1;
GROUP# MEMBER
---------- --------------------------------------------------
1 /u01/app/oracle/oradata/lx02/redo01a.log
1 /disk1/lx02/oradata/redo01b.log
2 /disk1/lx02/oradata/redo02b.log
2 /u01/app/oracle/oradata/lx02/redo02a.log
3 /disk1/lx02/oradata/redo03b.log
3 /u01/app/oracle/oradata/lx02/redo03a.log
6 rows selected.

3、将日志文件重命名
05:08:58 SQL> alter database rename file
05:09:05   2  '/u01/app/oracle/oradata/lx02/redo01a.log' to '/disk2/lx02/oradata/redo01a.log';
Database altered.
05:09:22 SQL> alter database rename file
05:09:26   2  '/u01/app/oracle/oradata/lx02/redo02a.log' to '/disk2/lx02/oradata/redo02a.log';
Database altered.
05:09:34 SQL> alter database rename file
05:09:35   2  '/u01/app/oracle/oradata/lx02/redo03a.log' to '/disk2/lx02/oradata/redo03a.log';
Database altered.
05:09:42 SQL> select group# ,member from v$logfile order by 1;
GROUP# MEMBER
---------- --------------------------------------------------
1 /disk2/lx02/oradata/redo01a.log
1 /disk1/lx02/oradata/redo01b.log
2 /disk1/lx02/oradata/redo02b.log
2 /disk2/lx02/oradata/redo02a.log
3 /disk1/lx02/oradata/redo03b.log
3 /disk2/lx02/oradata/redo03a.log
6 rows selected.
05:09:53 SQL> alter database open;
Database altered.
05:10:01 SQL> select group# ,member from v$logfile order by 1;
GROUP# MEMBER
---------- --------------------------------------------------
1 /disk2/lx02/oradata/redo01a.log
1 /disk1/lx02/oradata/redo01b.log
2 /disk1/lx02/oradata/redo02b.log
2 /disk2/lx02/oradata/redo02a.log
3 /disk1/lx02/oradata/redo03b.log
3 /disk2/lx02/oradata/redo03a.log
6 rows selected.
05:10:06 SQL> select * from v$log;
GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1          1          9   10485760          2 NO  INACTIVE                384007 02-AUG-11
3          1          8   10485760          2 NO  INACTIVE                384005 02-AUG-11
2          1         10   10485760          2 NO  CURRENT                 385481 02-AUG-11