数据库中rac改单的方法是什么

本篇内容介绍了"数据库中rac改单的方法是什么"的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

rac改单实例

15:34:21 sys@kk>select * from v$log;    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE          MEMBERS ARC STATUS               FIRST_CHANGE# FIRST_TIME     NEXT_CHANGE# NEXT_TIME---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ -------------------         1     1           1063 1073741824       512           1 YES INACTIVE                  4.3077E+11 2019-12-26 13:11:48   4.3077E+11 2019-12-26 13:49:57         2     1           1064 1073741824       512           1 YES INACTIVE                  4.3077E+11 2019-12-26 13:49:57   4.3077E+11 2019-12-26 14:27:54         3     1           1065 1073741824       512           1 YES INACTIVE                  4.3077E+11 2019-12-26 14:27:54   4.3077E+11 2019-12-26 15:02:15         4     1           1066 1073741824       512           1 YES INACTIVE                  4.3077E+11 2019-12-26 15:02:15   4.3077E+11 2019-12-26 15:02:16         5     1           1067 1073741824       512           1 NO  CURRENT              4.3077E+11 2019-12-26 15:02:16   2.8147E+14         6     1           1059 1073741824       512           1 YES INACTIVE                  4.3076E+11 2019-12-26 10:38:45   4.3076E+11 2019-12-26 11:16:48         7     1           1060 1073741824       512           1 YES INACTIVE                  4.3076E+11 2019-12-26 11:16:48   4.3077E+11 2019-12-26 11:55:03         8     1           1061 1073741824       512           1 YES INACTIVE                  4.3077E+11 2019-12-26 11:55:03   4.3077E+11 2019-12-26 12:33:24        11          1           1062 1073741824       512           1 YES INACTIVE                  4.3077E+11 2019-12-26 12:33:24   4.3077E+11 2019-12-26 13:11:48        12          2              0 1073741824        512           1 YES UNUSED                     0                                 0        14          2              0 1073741824        512           1 YES UNUSED                     0                                 0        17          3              0 1073741824        512           1 YES UNUSED                     0                                 0        18          3              0 1073741824        512           1 YES UNUSED                     0                                 0Elapsed: 00:00:00.0115:03:23 sys@kk>alter database drop logfile group 12;alter database drop logfile group 12*ERROR at line 1:ORA-01623: log 12 is current log for instance kk2 (thread 2) - cannot dropORA-00312: online log 12 thread 2: '/data1/KK/onlinelog/o1_mf_12_gxzp37z3_.log'

alter database disable thread 2;

15:34:25 sys@kk>alter database drop logfile group 12;

Database altered.

"数据库中rac改单的方法是什么"的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注网站，小编将为大家输出更多高质量的实用文章！