|
|
IOTN :: Field Book :: Tibero 
|
|
interal dd update failed!! [ patch 필요 ]
|
|
최길호
[LIST]
|
2020-12-20 09:45:54, 조회 : 69,859 |
2020/12/20 01:57:40.753 [DDL][0] 228 interal dd update failed!! :
-- SELECT mv.* FROM SYS._DD_MVIEW mv, SYS._DD_OBJ obj WHERE mv.OBJ_ID=obj.OBJ_ID AND BITAND(obj.FLAGS,128)=0 AND mv.HASH_1=:val AND mv.STATUS=0
2020/12/20 01:57:40.935 [DDL][0] 228 interal dd update failed!! :
-- UPDATE _DD_USER SET LCOUNT = 0 WHERE USER_ID = 56;
2020/12/20 01:57:40.939 [DDL][0] 230 interal dd update failed!! :
-- UPDATE _DD_USER SET LCOUNT = 0 WHERE USER_ID = 56;
2020/12/20 01:57:41.861 [DDL][0] 228 interal dd update failed!! :
-- UPDATE _PROFILE_USER SET LOGIN_DATE = SYSDATE WHERE USER_ID = 56;
2020/12/20 01:57:42.099 [DDL][0] 231 interal dd update failed!! :
-- UPDATE _PROFILE_USER SET LOGIN_DATE = SYSDATE WHERE USER_ID = 56;
2020/12/20 01:57:45.659 [DDL][0] 228 interal dd update failed!! :
-- UPDATE _DD_USER SET LCOUNT = 0 WHERE USER_ID = 56;
2020/12/20 01:58:44.062 [CLL][0] 53 LOGFILE SWITCHED. LF#1(seqno=254402, blocks=204799 next=0002.b578413d)
2020/12/20 01:58:46.735 [CLA][0] 54 LOG GROUP 1 (lsn=254402) ARCHIVED. (/data2/tbdata/arclog/log-t0-r0-s254402.arc)
2020/12/20 01:59:53.646 [DDL][0] 265 interal dd update failed!! :
-- SELECT mv.* FROM SYS._DD_MVIEW mv, SYS._DD_OBJ obj WHERE mv.OBJ_ID=obj.OBJ_ID AND BITAND(obj.FLAGS,128)=0 AND mv.HASH_1=:val AND mv.STATUS=0
2020/12/20 01:59:53.648 [DDL][0] 264 interal dd update failed!! :
-- SELECT mv.* FROM SYS._DD_MVIEW mv, SYS._DD_OBJ obj WHERE mv.OBJ_ID=obj.OBJ_ID AND BITAND(obj.FLAGS,128)=0 AND mv.HASH_1=:val AND mv.STATUS=0
2020/12/20 01:59:53.664 [DDL][0] 228 interal dd update failed!! :
-- SELECT mv.* FROM SYS._DD_MVIEW mv, SYS._DD_OBJ obj WHERE mv.OBJ_ID=obj.OBJ_ID AND BITAND(obj.FLAGS,128)=0 AND mv.HASH_1=:val AND mv.STATUS=0
2020/12/20 01:59:53.783 [DDL][0] 246 interal dd update failed!! :
-- SELECT mv.* FROM SYS._DD_MVIEW mv, SYS._DD_OBJ obj WHERE mv.OBJ_ID=obj.OBJ_ID AND BITAND(obj.FLAGS,128)=0 AND mv.HASH_1=:val AND mv.STATUS=0
...
2020/12/20 02:30:45.636 [DDL][0] 488 interal dd update failed!! :
-- UPDATE _DD_USER SET LCOUNT = 0 WHERE USER_ID = 56;
2020/12/20 02:31:36.330 [TDI][0] 558 auto coalesce error: sgmt_id=197591 ec=-3002
2020/12/20 02:38:45.696 [DDL][0] 529 interal dd update failed!! :
-- UPDATE _DD_USER SET LCOUNT = 0 WHERE USER_ID = 53;
2020/12/20 02:38:49.578 [DDL][0] 161 interal dd update failed!! :
-- SELECT mv.* FROM SYS._DD_MVIEW mv, SYS._DD_OBJ obj WHERE mv.OBJ_ID=obj.OBJ_ID AND BITAND(obj.FLAGS,128)=0 AND mv.HASH_2=:val AND mv.STATUS=0
2020/12/20 02:38:50.973 [DDL][0] 539 interal dd update failed!! :
-- SELECT mv.* FROM SYS._DD_MVIEW mv, SYS._DD_OBJ obj WHERE mv.OBJ_ID=obj.OBJ_ID AND BITAND(obj.FLAGS,128)=0 AND mv.HASH_2=:val AND mv.STATUS=0
2020/12/20 02:38:50.973 [DDL][0] 539 interal dd update failed!! :
-- SELECT * FROM _DD_USER WHERE USER_ID = 56
2020/12/20 02:39:28.712 [FRM][0] 0 tibero server shut down.
2020/12/20 04:04:19.040 [FRM][0] 0 MTHR(tbsvr) is ready : tid(0), ospid(7277)
2020/12/20 04:04:19.941 [CLC][0] 1 checking whether section(4) can use direct dfid
2020/12/20 04:04:19.941 [CLC][0] 1 checking whether section(5) can use direct dfid
2020/12/20 04:04:20.874 [FRM][0] 1
********************************************************
* Critical Warning : Raise svmode failed. The reason is
* TBR-1024 : Database needs media recovery: file needs end backup(/data1/tbdata/system001.tdf).
* Current server mode is MOUNT.
********************************************************
2020/12/20 04:04:20.992 [FRM][0] 1
--------------------------------------------------------------------------
Tibero 5 started up. protocol version 2.3
MTHR(tbsvr) is ready. proc_idx(tid) :0, ospid :7277
CTHR(tbsvr_WT001) is ready. proc_idx(tid) :1, ospid :7278
CTHR(tbsvr_WT002) is ready. proc_idx(tid) :2, ospid :7279
SQL> alter database recover automatic database;
Database altered.
SQL> exit
tbdown
tbboot
|
18.232.179.37
|
|
|
|
Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
|
|
|
09/27