【练习】迁移日志组

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  830930944 bytes
Fixed Size                  2257800 bytes
Variable Size             536874104 bytes
Database Buffers          289406976 bytes
Redo Buffers                2392064 bytes
Database mounted.

[oracle@host02 ORA11GR2]$ cp /u01/app/oracle/oradata/ORA11GR2/redo01.log /u01/app/oracle/redo01.log

SQL> alter database rename file ‘/u01/app/oracle/oradata/ORA11GR2/redo01.log‘ to ‘/u01/app/oracle/redo01.log‘;

Database altered.

SQL> alter database open;

Database altered.