alter database add logfile group 4 'xxx' size 500m;
alter database add logfile group 5 'xxx' size 500m;
alter database add logfile group 6 'xxx' size 500m;
select * from v$log;
alter system switch logfile;
alter database drop logfile group 1/2/3;
LOG的status 的状态为active不让删除,alter system checkpoint;
然后回复前3组REDO
alter database add logfile group 1 'xxxx' size 500m reuse;
alter database add logfile group 5 'xxx' size 500m;
alter database add logfile group 6 'xxx' size 500m;
select * from v$log;
alter system switch logfile;
alter database drop logfile group 1/2/3;
LOG的status 的状态为active不让删除,alter system checkpoint;
然后回复前3组REDO
alter database add logfile group 1 'xxxx' size 500m reuse;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23577591/viewspace-691335/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23577591/viewspace-691335/