rac+单实例dg 在线日志扩展

最新推荐文章于 2021-04-03 21:53:25 发布

原创

最新推荐文章于 2021-04-03 21:53:25 发布 · 572 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

本文详述了在RAC双节点+Data Guard环境下，进行在线日志扩展的具体步骤，包括主备库日志组的调整、同步取消与恢复、日志文件的增删等操作，确保主备库数据同步且符合高可用性要求。

步骤

在rac双节点+DG的环境中，配置的是实时同步，在线日志扩展的步骤：
1.先备库增加standby redo 删除原standby redo
2.然后主库增加redo删除原redo
3.备库增加新redo删除原redo
4.最后主库删除原standby redo，增加standby redo。

注意事项

1.standby log group 要比 logfile group 至少多一组。
2.standby logfile 和 logfile大小尽量一致。
3.standby logfile 和 logfile 操作逻辑基本上一样，都是要等到状态为inactive或者unused才能drop掉
4.log_file_name_convert如果不配置,将导致备库redo 文件不能被删除
关于Dataguard Online redo log 和 Standby redo log

具体步骤

1.查看现有日志组及重做文件大小及路径

主库：

SQL> select group#,thread#,sequence#,bytes/1024/1024 mb,members,archived,status from v$log;

    GROUP#    THREAD#  SEQUENCE#     MB    MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
    11        1      139229    500         2 YES INACTIVE
    12        1      139230    500         2 YES INACTIVE
    13        1      139231    500         2 YES ACTIVE
    14        1      139232    500         2 NO  CURRENT
    15        2      162276    500         2 NO  CURRENT
    16        2      162273    500         2 YES INACTIVE
    17        2      162274    500         2 YES INACTIVE
    18        2      162275    500         2 YES ACTIVE

已选择8行。

SQL> select group#,thread#,sequence#,bytes/1024/1024 mb,archived,status from V$STANDBY_LOG;

    GROUP#    THREAD#  SEQUENCE#     MB ARC STATUS
---------- ---------- ---------- ---------- --- ----------
    21        1           0    500 YES UNASSIGNED
    22        1           0    500 YES UNASSIGNED
    23        1           0    500 YES UNASSIGNED
    24        1           0    500 YES UNASSIGNED
    25        1           0    500 YES UNASSIGNED
    26        2           0    500 YES UNASSIGNED
    27        2           0    500 YES UNASSIGNED
    28        2           0    500 YES UNASSIGNED
    29        2           0    500 YES UNASSIGNED
    30        2           0    500 YES UNASSIGNED

已选择10行。

SQL> select * from v$logfile order by 1;

    GROUP# STATUS  TYPE    MEMBER					      IS_
---------- ------- ------- -------------------------------------------------- ---
	11	   ONLINE  +RACDB_DATA/racdb/onlinelog/group_11.log	      NO
	11	   ONLINE  +FRA/racdb/onlinelog/redo11.log			      NO
	12	   ONLINE  +RACDB_DATA/racdb/onlinelog/group_12.log	      NO
	12	   ONLINE  +FRA/racdb/onlinelog/redo12.log			      NO
	13	   ONLINE  +FRA/racdb/onlinelog/redo13.log			      NO
	13	   ONLINE  +RACDB_DATA/racdb/onlinelog/group_13.log	      NO
	14	   ONLINE  +RACDB_DATA/racdb/onlinelog/group_14.log	      NO
	14	   ONLINE  +FRA/racdb/onlinelog/redo14.log			      NO
	15	   ONLINE  +RACDB_DATA/racdb/onlinelog/group_15.log	      NO
	15	   ONLINE  +FRA/racdb/onlinelog/redo15.log			      NO
	16	   ONLINE  +FRA/racdb/onlinelog/redo16.log			      NO
	16	   ONLINE  +RACDB_DATA/racdb/onlinelog/group_16.log	      NO
	17	   ONLINE  +RACDB_DATA/racdb/onlinelog/group_17.log	      NO
	17	   ONLINE  +FRA/racdb/onlinelog/redo17.log			      NO
	18	   ONLINE  +RACDB_DATA/racdb/onlinelog/group_18.log	      NO
	18	   ONLINE  +FRA/racdb/onlinelog/redo18.log			      NO
	21	   STANDBY +RACDB_DATA/racdb/onlinelog/group_21.log	      NO
	21	   STANDBY +FRA/racdb/onlinelog/redo21.log			      NO
	22	   STANDBY +FRA/racdb/onlinelog/redo22.log			      NO
	22	   STANDBY +RACDB_DATA/racdb/onlinelog/group_22.log	      NO
	23	   STANDBY +FRA/racdb/onlinelog/redo23.log			      NO
	23	   STANDBY +RACDB_DATA/racdb/onlinelog/group_23.log	      NO
	24	   STANDBY +FRA/racdb/onlinelog/redo24.log			      NO
	24	   STANDBY +RACDB_DATA/racdb/onlinelog/group_24.log	      NO
	25	   STANDBY +FRA/racdb/onlinelog/redo25.log			      NO
	25	   STANDBY +RACDB_DATA/racdb/onlinelog/group_25.log	      NO
	26	   STANDBY +FRA/racdb/onlinelog/redo26.log			      NO
	26	   STANDBY +RACDB_DATA/racdb/onlinelog/group_26.log	      NO
	27	   STANDBY +FRA/racdb/onlinelog/redo27.log			      NO
	27	   STANDBY +RACDB_DATA/racdb/onlinelog/group_27.log	      NO
	28	   STANDBY +FRA/racdb/onlinelog/redo28.log			      NO
	28	   STANDBY +RACDB_DATA/racdb/onlinelog/group_28.log	      NO
	29	   STANDBY +FRA/racdb/onlinelog/redo29.log			      NO
	29	   STANDBY +RACDB_DATA/racdb/onlinelog/group_29.log	      NO
	30	   STANDBY +FRA/racdb/onlinelog/redo30.log			      NO
	30	   STANDBY +RACDB_DATA/racdb/onlinelog/group_30.log	      NO

已选择36行。

备库：

SQL> select group#,thread#,sequence#,bytes/1024/1024 mb,members,archived,status from v$log;

    GROUP#    THREAD#  SEQUENCE#     MB    MEMBERS ARC   STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
    14        1      139232    300         2 YES 		CLEARING
    15        1      138942    300         2 YES        CLEARING
    16        1      138943    300         2 YES        CLEARING
    17        1      138944    300         2 YES        CLEARING
    18        2      162275    300         2 YES        CLEARING
    19        2      162054    300         2 YES        CLEARING
    20        2      162055    300         2 YES        CLEARING
    21        2      162052    300         2 YES        CLEARING

已选择8行。

SQL> select group#,thread#,sequence#,bytes/1024/1024 mb,archived,status from V$STANDBY_LOG;

    GROUP#    THREAD#  SEQUENCE#     MB ARC STATUS
---------- ---------- ---------- ---------- --- ----------
     2        1           0    300 NO    UNASSIGNED
     3        1           0    300 NO    UNASSIGNED
     4        1           0    300 NO    UNASSIGNED
     5        1           0    300 NO    UNASSIGNED
     6        2           0    300 NO    UNASSIGNED
     7        2           0    300 NO    UNASSIGNED
     8        2           0    300 NO    UNASSIGNED
     9        2           0    300 NO    UNASSIGNED
    10        2           0    300 NO    UNASSIGNED
    22        2           0    300 NO    UNASSIGNED
    23        2           0    300 NO    UNASSIGNED
    24        2           0    300 NO    UNASSIGNED
    25        2           0    300 NO    UNASSIGNED
    26        2           0    300 NO    UNASSIGNED

已选择14行。