kill rebuilt index

脚本内容
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;
/

上一篇:CentOS 6.x 搭建:Headless Chrome + ChromeDriver + Selenium基于浏览器的爬虫环境


下一篇:PG config9.4