primary加大redolog size:
方法：新增500M的 logfile,drop 以前的logfile

alter database add logfile group 5 ('/oradata/mon/redo05.log') size 500M;
alter database add logfile group 6 ('/oradata/mon/redo06.log') size 500M;
alter database add logfile group 7 ('/oradata/mon/redo07.log') size 500M;
alter database add logfile group 8 ('/oradata/mon/redo08.log') size 500M;

 

select group#, sequence#,archived,status from v$log;
当redolog已被archived,且状态为inactive，可以删除redo logfile

ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 3;

****************************************
standby端也需要同步redo logfile信息：
步骤如下：
alter database recover managed standby database cancel;
alter system set STANDBY_FILE_MANAGEMENT =manual;
alter database add logfile group 5 ('/oradata/mon/redo05.log') size 500M;
alter database add logfile group 6 ('/oradata/mon/redo06.log') size 500M;
alter database add logfile group 7 ('/oradata/mon/redo07.log') size 500M;
alter database add logfile group 8 ('/oradata/mon/redo08.log') size 500M;

确认standby端：log_file_name_convert已设置
SQL>  select group#, sequence#, bytes/power(1024,2),archived,status from v$log;

SQL> alter database clear logfile group 1;
SQL> ALTER DATABASE DROP LOGFILE GROUP 1;

alter database clear logfile group 2;
ALTER DATABASE DROP LOGFILE GROUP 2;

alter database clear logfile group 3；
ALTER DATABASE DROP LOGFILE GROUP 3;

alter system set standby_file_management=auto scope=both;
alter database recover managed standby database disconnect from session;