dataguard环境 add redo logfiles

最新推荐文章于 2025-11-30 19:25:58 发布

转载最新推荐文章于 2025-11-30 19:25:58 发布 · 151 阅读

文章标签：

#数据库

本文介绍如何通过增加新的Redo Log文件组来扩大Oracle数据库的Redo Log容量，并提供了具体的操作步骤。此外，还介绍了如何清除及删除旧的Redo Log文件组，以及在Standby环境中同步这些操作的方法。

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;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10173379/viewspace-731309/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10173379/viewspace-731309/