实验案例:删除文件系统日志组,保留ASM日志组
说明:
oracle文件系统迁移至ASM,需要删除文件系统的日志组,只保留ASM日志组。若两者均保留,会出现读写日志性能不平衡状态。向ASM中读写日志要远快于向文件系统中读写日志。
操作步骤:
SQL> select * from v$log;
--查看到当前日志组为2,第1、3日志组处于INACTIVE状态,脏块已经写完,可以将这两个日志组删除
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 2 52428800 2 YES INACTIVE
864542 29-MAY-14
2 1 7 52428800 2 NO CURRENT
864576 29-MAY-14
3 1 3 52428800 2 YES INACTIVE
864552 29-MAY-14
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
4 1 4 52428800 1 YES INACTIVE
864565 29-MAY-14
5 1 5 52428800 1 YES INACTIVE
864568 29-MAY-14
6 1 6 52428800 1 YES INACTIVE
864571 29-MAY-14
6 rows selected.
SQL> alter database drop logfile group 1;
Database altered.
SQL> select * from v$log;
说明:
oracle文件系统迁移至ASM,需要删除文件系统的日志组,只保留ASM日志组。若两者均保留,会出现读写日志性能不平衡状态。向ASM中读写日志要远快于向文件系统中读写日志。
操作步骤:
SQL> select * from v$log;
--查看到当前日志组为2,第1、3日志组处于INACTIVE状态,脏块已经写完,可以将这两个日志组删除
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 2 52428800 2 YES INACTIVE
864542 29-MAY-14
2 1 7 52428800 2 NO CURRENT
864576 29-MAY-14
3 1 3 52428800 2 YES INACTIVE
864552 29-MAY-14
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
4 1 4 52428800 1 YES INACTIVE
864565 29-MAY-14
5 1 5 52428800 1 YES INACTIVE
864568 29-MAY-14
6 1 6 52428800 1 YES INACTIVE
864571 29-MAY-14
6 rows selected.
SQL> alter database drop logfile group 1;
Database altered.
SQL> select * from v$log;