当前位置: 代码迷 >> 综合 >> oracle 11g/10g dataguard dg环境主库增加redo log
  详细解决方案

oracle 11g/10g dataguard dg环境主库增加redo log

热度:47   发布时间:2023-12-20 12:21:06.0

oracle dg环境主库增加redo log size
环境:11g
主库:testa  单点
备库:testb  单点

加日志之前状态:
主备库均为 5组redo log size 100m, 6组standby redo log 100m


--1、主库增加redo
alter database add logfile thread 1 group 21 '/oradata/testa/redo21.log' size 500m;
alter database add logfile thread 1 group 22 '/oradata/testa/redo22.log' size 500m;
alter database add logfile thread 1 group 23 '/oradata/testa/redo23.log' size 500m;
alter database add logfile thread 1 group 24 '/oradata/testa/redo24.log' size 500m;
alter database add logfile thread 1 group 25 '/oradata/testa/redo25.log' size 500m;
alter database add logfile thread 1 group 26 '/oradata/testa/redo26.log' size 500m;

--2、主库增加standby redo
alter database add standby logfile thread 1 group 31 '/oradata/testa/redo31std.log' size 500m;
alter database add standby logfile thread 1 group 32 '/oradata/testa/redo32std.log' size 500m;  
alter database add standby logfile thread 1 group 33 '/oradata/testa/redo33std.log' size 500m;  
alter database add standby logfile thread 1 group 34 '/oradata/testa/redo34std.log' size 500m;  
alter database add standby logfile thread 1 group 35 '/oradata/testa/redo35std.log' size 500m;  
alter database add standby logfile thread 1 group 36 '/oradata/testa/redo36std.log' size 500m;  
alter database add standby logfile thread 1 group 37 '/oradata/testa/redo37std.log' size 500m;  


--3、备库取消日志应用,设置为手动文件管理
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL'; 

--4、备库增加redo
alter database add logfile thread 1 group 21 '/oradata/testb/redo21.log' size 500m;
alter database add logfile thread 1 group 22 '/oradata/testb/redo22.log' size 500m;
alter database add logfile thread 1 group 23 '/oradata/testb/redo23.log' size 500m;
alter database add logfile thread 1 group 24 '/oradata/testb/redo24.log' size 500m;
alter database add logfile thread 1 group 25 '/oradata/testb/redo25.log' size 500m;
alter database add logfile thread 1 group 26 '/oradata/testb/redo26.log' size 500m;

--5、备库增加standby redo
alter database add standby logfile thread 1 group 31 '/oradata/testb/redo31std.log' size 500m;
alter database add standby logfile thread 1 group 32 '/oradata/testb/redo32std.log' size 500m;  
alter database add standby logfile thread 1 group 33 '/oradata/testb/redo33std.log' size 500m;  
alter database add standby logfile thread 1 group 34 '/oradata/testb/redo34std.log' size 500m;  
alter database add standby logfile thread 1 group 35 '/oradata/testb/redo35std.log' size 500m;  
alter database add standby logfile thread 1 group 36 '/oradata/testb/redo36std.log' size 500m;  
alter database add standby logfile thread 1 group 37 '/oradata/testb/redo37std.log' size 500m;  

--6、主库删除老的redo
alter system switch logfile; 可执行多次,只至需要删除的group 状态为inactive 切换logfile是要删除的group没有current或者active状态

selecct * from v$Log;  确认状态为inactive

alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
alter database clear logfile group 4;
alter database clear logfile group 5;
alter database clear logfile group 6;

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
alter database drop logfile group 4;
alter database drop logfile group 5;
alter database drop logfile group 6;

--7、主库删除老的standby redo
selecct * from v$standby_log; 确认要删除的日志状态为非active

alter database drop standby logfile group 7;
alter database drop standby logfile group 8;
alter database drop standby logfile group 9;
alter database drop standby logfile group 10;
alter database drop standby logfile group 11;
alter database drop standby logfile group 12;
alter database drop standby logfile group 13;

--8、备库删除老的redo
select group#,status from v$Log;                                                              
注:如果是current 状态,可在主库进行switch logfile操作;     

alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
alter database clear logfile group 4;
alter database clear logfile group 5;
alter database clear logfile group 6;      

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
alter database drop logfile group 4;
alter database drop logfile group 5;
alter database drop logfile group 6;


--9、备库删除老的standby redo
select * from v$standby_log;   确认要删除的日志状态为非active


alter database drop standby logfile group 7;
alter database drop standby logfile group 8;
alter database drop standby logfile group 9;
alter database drop standby logfile group 10;
alter database drop standby logfile group 11;
alter database drop standby logfile group 12;
alter database drop standby logfile group 13;


--备库设置自动管理文件,打开恢复进程
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO'; 
alter database recover managed standby database using current logfile disconnect from session;
 
 
--测试日志是否正常切换应用
alter system switch logfile;
 

  相关解决方案