oracle数据库集群管理-REDO管理

select  * from v$Logfile;

select * from v$Log where thread#=1

alter database add logfile group 1 '+redo' size 3G;

alter database add logfile group 2 '+redo' size 3G;   ---登录orcl1实例，则只处理orcl1实例thread 1 的redo日志

select * from v$Log where thread#=2

alter database drop logfile  group 3;

alter database drop logfile  group 4;

alter database add logfile instance 'orcl2'  group 3  '+redo' size 3G;

alter database add logfile instance 'orcl2'  group 4  '+redo' size 3G;  orcl1处理实例2线程的日志

alter system archive log current;

alter system archive log instance 'orcl2' current;

alter system checkpoint ;

alter system checkpoint global;