调整Redo log size
1把之前drop的日志文件group1,group2,group3重新使用，同时删除drop group4,group5,group6。
select * from v$log;
col member for a50
select * from v$logfile;
alter database add logfile group 1 ('/ummis/mmisprd/mmisprddata/mmisprd/redo01a.log','/ummis/mmisprd/mmisprddata/mmisprd/redo01b.log') size 52429312 reuse;
alter database add logfile group 2 ('/ummis/mmisprd/mmisprddata/mmisprd/redo02a.log','/ummis/mmisprd/mmisprddata/mmisprd/redo02b.log') size 52429312 reuse;
alter database add logfile group 3 ('/ummis/mmisprd/mmisprddata/mmisprd/redo03a.log','/ummis/mmisprd/mmisprddata/mmisprd/redo03b.log') size 52429312 reuse;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system checkpoint;
select * from v$log;
alter database drop logfile group 4;
alter database drop logfile group 5;
alter database drop logfile group 6;
select * from v$log;
alter database add logfile group 2 ('/ummis/mmisprd/mmisprddata/mmisprd/redo02a.log','/ummis/mmisprd/mmisprddata/mmisprd/redo02b.log') size 52429312 reuse;
alter database add logfile group 3 ('/ummis/mmisprd/mmisprddata/mmisprd/redo03a.log','/ummis/mmisprd/mmisprddata/mmisprd/redo03b.log') size 52429312 reuse;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system checkpoint;
select * from v$log;
alter database drop logfile group 4;
alter database drop logfile group 5;
alter database drop logfile group 6;
select * from v$log;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23757700/viewspace-751505/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle 文档哈
下一篇：
查看awr保留日期
请登录后发表评论
登录
全部评论
