ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dataguard环境 add redo logfiles

dataguard环境 add redo logfiles

原创 Linux操作系统 作者:zhaohf_1106 时间:2012-05-28 17:11:16 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-10-30

  • 博文量
    44
  • 访问量
    97383