redo重做日志管理

基本管理

• 切换日志：alter system switch logfile;
• 手工发出检查点：alter sysem checkpoit;
• 增加日志组：alter database add logfile [group n] file-spec 
• 增加日志组成员：alter database add logfile member file-spec to group n
• 删除日志组：alter database drop logfile group n
• 删除日志组成员：alter database drop logfile member file-spec
• 重新初始化日志组或日志组成员：alter database clear logfile {group n|file-spec|(file-spec,file-spec...)}
• 查看当前的日志文件组及成员：select * from v$logfile;  select * from v$log;
• 移动或|和重命名日志组成员文件：alter database rename file file-spec to file-spec