相关的表:
v$log
v$logfile
v$log_history
添加redo log组命令:
alter database add logfile group 4 '/home/oracle/testdb/logfile/redo05.log' size 50M; ------添加组的时候设定了logfile member的大小之后，再添加logfile member就会创建同样大小的文件.
添加redo log member命令:
alter database add logfile member '/home/oracle/testdb/logfile/redo05_1.log' to group 4;
删除redo log member命令:
alter database drop logfile member '/home/oracle/testdb/logfile/redo05_1.log';
如果一个组中只剩下最后一个member的时候，是不能用上面的那个命令删除的.
删除redo log group的命令:
alter database drop logfile group 4;
修改redo log file 的名称或者位置:
alter database rename logfile '/home/oracle/testdb/logfile/redo05_1.log' to '/home/oracle/testdb/logfile/redo05_2.log';
切换日志文件:
alter system switch logfile;
强制checkpoint:
alter system checkpoint;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23850820/viewspace-1035041/ ，如需转载，请注明出处，否则将追究法律责任。
