数据库操作--redo

 

 

 

查看redo的节点、大小、组数

set linesize 150;

set pagesize 50;

column MB format a5;

column STATUS format a12;

column MEMBER format a70;

select l.GROUP#,l.THREAD#,l.BYTES/1024/1024||'MB' MB,l.STATUS, lf.TYPE,lf.MEMBER from v$log l,v$logfile lf where l.GROUP#=lf.GROUP#;

 

切换redo

SYS@ocp> alter system switch logfile;

System altered.

 

切换归档

SYS@ocp> alter system archive log current;

System altered.