【练习】迁移日志组

迁移日志组必须在数据库mount的状态

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.

1.拷贝

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

2.更新控制文件中redo的信息

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

Database altered.

3.起库

SQL> alter database open;

Database altered.