十年网站开发经验 + 多家企业客户 + 靠谱的建站团队
量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决
本篇内容介绍了“数据库中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改单的方法是什么”的内容就介绍到这里了,感谢大家的阅读。如果想了解更多行业相关的知识可以关注创新互联网站,小编将为大家输出更多高质量的实用文章!