记一次oralce处理Checkpoint not complete

最新推荐文章于 2021-04-12 21:04:29 发布

qq1105273619

最新推荐文章于 2021-04-12 21:04:29 发布

阅读量105

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/qq1105273619/article/details/102894615

版权

oracle 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

select member from v$logfile;

select group#,sequence#,bytes,members,status from v$log;

##增加成员组
alter database add logfile group 4 ('/home/oracle/data/oracle/oradata/orcl/redo04.log') size 100m reuse;
alter database add logfile group 5 ('/home/oracle/data/oracle/oradata/orcl/redo05.log') size 100m reuse;
alter database add logfile group 6 ('/home/oracle/data/oracle/oradata/orcl/redo06.log') size 100m reuse;

select group#,sequence#,bytes,members,status from v$log;

##删除之前的组，并删除对应repo文件
alter database drop logfile group 1;
! rm /home/oracle/data/oracle/oradata/orcl/redo01.log

alter database drop logfile group 2;
! rm /home/oracle/data/oracle/oradata/orcl/redo02.log

alter database drop logfile group 3;
! rm /home/oracle/data/oracle/oradata/orcl/redo03.log


alter system switch logfile;
alter system checkpoint;

alter database add logfile group 1 ('/home/oracle/data/oracle/oradata/orcl/redo01.log') size 100m reuse;
alter database add logfile group 2 ('/home/oracle/data/oracle/oradata/orcl/redo02.log') size 100m reuse;
alter database add logfile group 3 ('/home/oracle/data/oracle/oradata/orcl/redo03.log') size 100m reuse;

select * from v$log;
select member from v$logfile;