dataguard环境 add redo logfiles

最新推荐文章于 2024-10-05 14:16:38 发布

csc62888

最新推荐文章于 2024-10-05 14:16:38 发布

阅读量108

点赞数

文章标签：数据库

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/