1)查看当前日志文件大小
SQL> select *from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
4 1 0 10485760 1 YES UNUSED 0
5 1 0 10485760 1 YES UNUSED 0
6 1 1 10485760 1 NO CURRENT 1594085 16-12月-14
当前日志文件10M
2)添加三组一样大小的日志文件
SQL> alter database add logfile group 1 'E:\oracle\product\10.2.0\oradata\orcl\redo01.log' size 5m;
数据库已更改。
SQL> alter database add logfile group 2 'E:\oracle\product\10.2.0\oradata\orcl\redo02.log' size 5m;
数据库已更改。
SQL> alter database add logfile group 3 'E:\oracle\product\10.2.0\oradata\orcl\redo03.log' size 5m;
数据库已更改。
3)
SQL> select *from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
1 1 0 5242880 1 YES UNUSED 0
2 1 0 5242880 1 YES UNUSED 0
3 1 0 5242880 1 YES UNUSED 0
4 1 0 10485760 1 YES UNUSED 0
5 1 0 10485760 1 YES UNUSED 0
6 1 1 10485760 1 NO CURRENT 1594085 16-12月-14
已选择6行。
4)切换日志文件,删除4-6组日志文件
SQL> alter database drop logfile group 6;
数据库已更改。
SQL> alter system switch logfile;
系统已更改。
SQL> select *from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
1 1 7 5242880 1 YES ACTIVE 1597384 16-12月-14
2 1 8 5242880 1 NO CURRENT 1597396 16-12月-14
3 1 4 5242880 1 YES ACTIVE 1597187 16-12月-14
4 1 5 10485760 1 YES ACTIVE 1597371 16-12月-14
5 1 6 10485760 1 YES ACTIVE 1597379 16-12月-14
发出检查点,使active变为inactive状态
SQL> alter system checkpoint;
系统已更改。
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
1 1 7 5242880 1 YES INACTIVE 1597384 16-12月-14
2 1 8 5242880 1 NO CURRENT 1597396 16-12月-14
3 1 4 5242880 1 YES INACTIVE 1597187 16-12月-14
4 1 5 10485760 1 YES INACTIVE 1597371 16-12月-14
5 1 6 10485760 1 YES INACTIVE 1597379 16-12月-14
SQL> alter database drop logfile group 4;
数据库已更改。
SQL> alter database drop logfile group 5;
数据库已更改。
SQL> select *from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
1 1 7 5242880 1 YES INACTIVE 1597384 16-12月-14
2 1 8 5242880 1 NO CURRENT 1597396 16-12月-14
3 1 4 5242880 1 YES INACTIVE 1597187 16-12月-14
SQL> select *from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
4 1 0 10485760 1 YES UNUSED 0
5 1 0 10485760 1 YES UNUSED 0
6 1 1 10485760 1 NO CURRENT 1594085 16-12月-14
当前日志文件10M
2)添加三组一样大小的日志文件
SQL> alter database add logfile group 1 'E:\oracle\product\10.2.0\oradata\orcl\redo01.log' size 5m;
数据库已更改。
SQL> alter database add logfile group 2 'E:\oracle\product\10.2.0\oradata\orcl\redo02.log' size 5m;
数据库已更改。
SQL> alter database add logfile group 3 'E:\oracle\product\10.2.0\oradata\orcl\redo03.log' size 5m;
数据库已更改。
3)
SQL> select *from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
1 1 0 5242880 1 YES UNUSED 0
2 1 0 5242880 1 YES UNUSED 0
3 1 0 5242880 1 YES UNUSED 0
4 1 0 10485760 1 YES UNUSED 0
5 1 0 10485760 1 YES UNUSED 0
6 1 1 10485760 1 NO CURRENT 1594085 16-12月-14
已选择6行。
4)切换日志文件,删除4-6组日志文件
SQL> alter database drop logfile group 6;
数据库已更改。
SQL> alter system switch logfile;
系统已更改。
SQL> select *from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
1 1 7 5242880 1 YES ACTIVE 1597384 16-12月-14
2 1 8 5242880 1 NO CURRENT 1597396 16-12月-14
3 1 4 5242880 1 YES ACTIVE 1597187 16-12月-14
4 1 5 10485760 1 YES ACTIVE 1597371 16-12月-14
5 1 6 10485760 1 YES ACTIVE 1597379 16-12月-14
发出检查点,使active变为inactive状态
SQL> alter system checkpoint;
系统已更改。
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
1 1 7 5242880 1 YES INACTIVE 1597384 16-12月-14
2 1 8 5242880 1 NO CURRENT 1597396 16-12月-14
3 1 4 5242880 1 YES INACTIVE 1597187 16-12月-14
4 1 5 10485760 1 YES INACTIVE 1597371 16-12月-14
5 1 6 10485760 1 YES INACTIVE 1597379 16-12月-14
SQL> alter database drop logfile group 4;
数据库已更改。
SQL> alter database drop logfile group 5;
数据库已更改。
SQL> select *from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------------
1 1 7 5242880 1 YES INACTIVE 1597384 16-12月-14
2 1 8 5242880 1 NO CURRENT 1597396 16-12月-14
3 1 4 5242880 1 YES INACTIVE 1597187 16-12月-14
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26937943/viewspace-1372677/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26937943/viewspace-1372677/