oracle online redo 的日常处理

最新推荐文章于 2021-04-14 17:11:31 发布

数据库人生

最新推荐文章于 2021-04-14 17:11:31 发布

阅读量380

点赞数

分类专栏： # oracle basic knowledge # oracle ha data guard 文章标签： online redo

本文链接：https://blog.csdn.net/ctypyb2002/article/details/100672947

版权

oracle basic knowledge 同时被 2 个专栏收录

60 篇文章

订阅专栏

oracle ha data guard

29 篇文章

订阅专栏

drop logfile group

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
alter database drop logfile group 4;

drop logfile group member

alter database drop logfile member '+DG_FRA/ORCLP/ONLINELOG/group_1.327.1008848551';
alter database drop logfile member '+DG_FRA/ORCLP/ONLINELOG/group_2.328.1008848551';
alter database drop logfile member '+DG_FRA/ORCLP/ONLINELOG/group_3.329.1008848551';
alter database drop logfile member '+DG_FRA/ORCLP/ONLINELOG/group_4.330.1008848551';

add logfile group

alter database add logfile group 1 ('+DG_DATA01','+DG_FRA') size 512M reuse;
alter database add logfile group 2 ('+DG_DATA01','+DG_FRA') size 512M reuse;

alter database add logfile group 3 ('+DG_DATA01','+DG_FRA') size 512M reuse;
alter database add logfile group 4 ('+DG_DATA01','+DG_FRA') size 512M reuse;

alter database add logfile thread 1 group 1 ('+DG_DATA01','+DG_FRA') size 512M reuse;
alter database add logfile thread 1 group 2 ('+DG_DATA01','+DG_FRA') size 512M reuse;

alter database add logfile thread 2 group 3 ('+DG_DATA01','+DG_FRA') size 512M reuse;
alter database add logfile thread 2 group 4 ('+DG_DATA01','+DG_FRA') size 512M reuse;

add logfile group member

alter database add logfile member ('+DG_FRA') reuse TO GROUP 1 ;
alter database add logfile member ('+DG_FRA') reuse TO GROUP 2 ;

alter database add logfile member ('+DG_FRA') reuse TO GROUP 3 ;
alter database add logfile member ('+DG_FRA') reuse TO GROUP 4 ;

参考: