RAC删除添加redolog日志组成员

最新推荐文章于 2024-07-07 17:12:26 发布

lk_db

最新推荐文章于 2024-07-07 17:12:26 发布

阅读量4.2k

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/lk_db/article/details/78468056

版权

Oracle 专栏收录该内容

120 篇文章 5 订阅

订阅专栏

SQL> select * from gv$logfile;

INST_ID GROUP# STATUS TYPE MEMBER IS_
---------- ---------- ---------- ------- -------------------------------------------------- ---
1 1 ONLINE +DATA/orcl/onlinelog/group_1.270.959095063 NO
1 1 ONLINE +FRA/orcl/onlinelog/group_1.261.959095065 NO
1 2 ONLINE +DATA/orcl/onlinelog/group_2.269.959095069 NO
1 2 ONLINE +FRA/orcl/onlinelog/group_2.260.959095071 NO
1 3 ONLINE +DATA/orcl/onlinelog/group_3.273.957784959 NO
1 3 ONLINE +FRA/orcl/onlinelog/group_3.262.957784963 NO
1 4 ONLINE +DATA/orcl/onlinelog/group_4.274.957784965 NO
1 4 ONLINE +FRA/orcl/onlinelog/group_4.263.957784969 NO
2 1 ONLINE +DATA/orcl/onlinelog/group_1.270.959095063 NO
2 1 ONLINE +FRA/orcl/onlinelog/group_1.261.959095065 NO
2 2 ONLINE +DATA/orcl/onlinelog/group_2.269.959095069 NO

INST_ID GROUP# STATUS TYPE MEMBER IS_
---------- ---------- ---------- ------- -------------------------------------------------- ---
2 2 ONLINE +FRA/orcl/onlinelog/group_2.260.959095071 NO
2 3 ONLINE +DATA/orcl/onlinelog/group_3.273.957784959 NO
2 3 ONLINE +FRA/orcl/onlinelog/group_3.262.957784963 NO
2 4 ONLINE +DATA/orcl/onlinelog/group_4.274.957784965 NO
2 4 ONLINE +FRA/orcl/onlinelog/group_4.263.957784969 NO

16 rows selected.

SQL> alter database drop logfile member '+FRA/orcl/onlinelog/group_4.263.957784969';

Database altered.

SQL> select * from gv$logfile;

INST_ID GROUP# STATUS TYPE MEMBER IS_
---------- ---------- ---------- ------- -------------------------------------------------- ---
2 1 ONLINE +DATA/orcl/onlinelog/group_1.270.959095063 NO
2 1 ONLINE +FRA/orcl/onlinelog/group_1.261.959095065 NO
2 2 ONLINE +DATA/orcl/onlinelog/group_2.269.959095069 NO
2 2 ONLINE +FRA/orcl/onlinelog/group_2.260.959095071 NO
2 3 ONLINE +DATA/orcl/onlinelog/group_3.273.957784959 NO
2 3 ONLINE +FRA/orcl/onlinelog/group_3.262.957784963 NO
2 4 ONLINE +DATA/orcl/onlinelog/group_4.274.957784965 NO
1 1 ONLINE +DATA/orcl/onlinelog/group_1.270.959095063 NO
1 1 ONLINE +FRA/orcl/onlinelog/group_1.261.959095065 NO
1 2 ONLINE +DATA/orcl/onlinelog/group_2.269.959095069 NO
1 2 ONLINE +FRA/orcl/onlinelog/group_2.260.959095071 NO

INST_ID GROUP# STATUS TYPE MEMBER IS_
---------- ---------- ---------- ------- -------------------------------------------------- ---
1 3 ONLINE +DATA/orcl/onlinelog/group_3.273.957784959 NO
1 3 ONLINE +FRA/orcl/onlinelog/group_3.262.957784963 NO
1 4 ONLINE +DATA/orcl/onlinelog/group_4.274.957784965 NO

14 rows selected.

SQL> alter database add logfile member '+FRA/' to group 4;

Database altered.

SQL> select * from gv$logfile;

INST_ID GROUP# STATUS TYPE MEMBER IS_
---------- ---------- ---------- ------- -------------------------------------------------- ---
2 1 ONLINE +DATA/orcl/onlinelog/group_1.270.959095063 NO
2 1 ONLINE +FRA/orcl/onlinelog/group_1.261.959095065 NO
2 2 ONLINE +DATA/orcl/onlinelog/group_2.269.959095069 NO
2 2 ONLINE +FRA/orcl/onlinelog/group_2.260.959095071 NO
2 3 ONLINE +DATA/orcl/onlinelog/group_3.273.957784959 NO
2 3 ONLINE +FRA/orcl/onlinelog/group_3.262.957784963 NO
2 4 ONLINE +DATA/orcl/onlinelog/group_4.274.957784965 NO
2 4 INVALID ONLINE +FRA/orcl/onlinelog/group_4.263.959437245 NO
1 1 ONLINE +DATA/orcl/onlinelog/group_1.270.959095063 NO
1 1 ONLINE +FRA/orcl/onlinelog/group_1.261.959095065 NO
1 2 ONLINE +DATA/orcl/onlinelog/group_2.269.959095069 NO

INST_ID GROUP# STATUS TYPE MEMBER IS_
---------- ---------- ---------- ------- -------------------------------------------------- ---
1 2 ONLINE +FRA/orcl/onlinelog/group_2.260.959095071 NO
1 3 ONLINE +DATA/orcl/onlinelog/group_3.273.957784959 NO
1 3 ONLINE +FRA/orcl/onlinelog/group_3.262.957784963 NO
1 4 ONLINE +DATA/orcl/onlinelog/group_4.274.957784965 NO
1 4 INVALID ONLINE +FRA/orcl/onlinelog/group_4.263.959437245 NO

16 rows selected.

SQL>