kill rebuilt index

简介: 脚本内容cnsz081302:cch > more cch_rebuild_index01.s*::::::::::::::cch_rebuild_index01.sh::::::::::::::cd $HOME/wcsqlplus /nolog @$HOME/wc/cch_rebuild_index01.

脚本内容
cnsz081302:cch > more cch_rebuild_index01.s*
::::::::::::::
cch_rebuild_index01.sh
::::::::::::::
cd $HOME/wc
sqlplus /nolog @$HOME/wc/cch_rebuild_index01.sql
::::::::::::::
cch_rebuild_index01.sql
::::::::::::::
conn / as sysdba
spool cch_rebuild_index01.log
set timing on
set time on
set echo on
alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 rebuild online parallel 8;
alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 noparallel;
spool off
exit
 
日志信息:
cnsz081302:cch > more nohup.out
 
SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 21 21:23:15 2018
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 
Connected.
21:23:15 sys@cch>alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 rebuild online parallel 8;
alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 rebuild online parallel 8
*
ERROR at line 1:
ORA-08104: this index object 837231 is being online built or rebuilt
 
 
Elapsed: 00:00:00.03
21:23:15 sys@cch>alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 noparallel;
alter index cchlogtmp.IDX_MAIN_INFO_T_SYSID_SMS_3 noparallel
*
ERROR at line 1:
ORA-08104: this index object 837231 is being online built or rebuilt
 
 
Elapsed: 00:00:00.01
21:23:15 sys@cch>spool off
21:23:15 sys@cch>exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
 
官方解释:
cnsz081302:cch > oerr ora 08104
08104, 00000, "this index object %s is being online built or rebuilt"
// *Cause:  the index is being created or rebuild or waited for recovering
//          from the online (re)build
// *Action: wait the online index build or recovery to complete
cnsz081302:cch >
 
 
清理方法:
declare
isClean boolean;
object_id binary_integer;
wait_for_lock binary_integer;
begin
object_id:=837231;
wait_for_lock:=null;
isClean := sys.dbms_repair.online_index_clean();
commit;
end;
/

目录
相关文章
|
7月前
|
Linux
Linux指令|more|less|head|tail|管道|sort|wc|uniq
Linux指令|more|less|head|tail|管道|sort|wc|uniq
|
JavaScript API 数据库
node.js报错 Cannot enqueue Query after invoking quit.
今天进行连接数据库的时候,遇到这个错误,于是染念就开始debug time了。 首先,我们需要了解一下node.js里的回调函数 Node.js 异步编程的直接体现就是回调。 异步编程依托于回调来实现,但不能说使用了回调后程序就异步化了。
152 0
node子进程(Child Process)获取硬盘分区
node子进程(Child Process)获取硬盘分区
66 0
|
安全 Java 应用服务中间件
Kill - 9 or 15 解析
一提到“Kill”命令,大家是不是很兴奋,潜意识觉得自己大展宏图之刻即将到来,仿佛自己就是那个黑暗的夜空下拿着长剑的武士,站在高高的山崖顶层,xx一切。。。别,醒醒吧,孩子(大侠)!大家在停止Java进程时(当然,不仅仅是Java,其他应用也同样适用,本文主要针对Java程序进行解析),有没有想过为什么要用kill -9呢?这样操作对吗?
143 0
|
关系型数据库 MySQL
pt-kill
pt-kill 是属于percona-toolkit中的一个工具,作用是kill mysql的连接,pt-kill连接mysql,通过show processlist获得查询. 参数: --kill #kill mysql的连接 --busy-time=m   #匹配运行时...
1063 0
|
Oracle 关系型数据库 Linux
oom_kill_process造成数据库挂起并出现found dead shared server
这篇博客是上一篇博客Oracle shutdown immediate遭遇ORA-24324 ORA-24323 ORA-01089的延伸(数据库挂起hang时,才去重启的),其实这是我们海外一工厂的遇到的案例,把内容拆开是因为这个case分开讲述显得主题明确一些。
1309 0
|
算法 关系型数据库 SQL

热门文章

最新文章