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;
/

目录
相关文章
End Sub 和 Exit Sub 的区别
End Sub 和 Exit Sub 的区别
148 0
End Sub 和 Exit Sub 的区别
脚本文件stop和status与start类似,这里不再描述。
脚本文件stop和status与start类似,这里不再描述。
54 0
|
PHP
php中echo,print,print_r,var_dump 的区别
php中echo,print,print_r,var_dump 的区别
60 0
PHP:echo,print,print_r,var_dump区别
PHP:echo,print,print_r,var_dump区别
639 0
PHP:echo,print,print_r,var_dump区别
|
关系型数据库 MySQL
pt-kill
pt-kill 是属于percona-toolkit中的一个工具,作用是kill mysql的连接,pt-kill连接mysql,通过show processlist获得查询. 参数: --kill #kill mysql的连接 --busy-time=m   #匹配运行时...
1063 0