本篇内容介绍了“数据库中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 0
Elapsed: 00:00:00.01
15: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 drop
ORA-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改单的方法是什么”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注创新互联网站，小编将为大家输出更多高质量的实用文章！
分享文章：数据库中rac改单的方法是什么
文章源于：
http://cdkjz.cn/article/gdsgio.html
