redo 管理语句

一、查看redo信息

col member for a60
SELECT L.THREAD#,
       L.GROUP#,
       L.BYTES / 1024 / 1024 SIZE_M,
       L.STATUS,
       LF.MEMBER,
       L.MEMBERS,
       LF.STATUS
  FROM V$LOG L
 INNER JOIN V$LOGFILE LF
    ON L.GROUP# = LF.GROUP#
 ORDER BY L.THREAD#, L.GROUP#;

  
二、相关操作

1. 增加日志组
   

   alter database add logfile thread 1 group 6 '/oradata/ORCL/redo06.log' SIZE 50M;

2. 删除日志组
   

   alter database drop logfile group 6;

3. 增加member
   

   alter database add logfile member '/oradata/ORCL/redo06b.log' to group 6;

4. 删除member
   

   alter database drop logfile member '/oradata/ORCL/redo06b.log';

5. 切日志
   

   alter system switch logfile;
   alter system archive log current;

6. 日志文件改名
   

   Alter database rename file ‘…old’ to ‘…new’;

7. 如果某个文件出了问题，清空redo
   

   Alter database clear logfile group 9;