当前位置： 首页 > news >正文

坏块处理 ORA-01578: ORACLE data block corrupted (file # 3, block # 152588)

news 2025/6/8 12:10:06

帮客户检查环境时，发现sysaux表空间的数据文件有坏块，8月25日发生的，备份保留3个月，直接恢复处理。

rman备份log报错如下

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/14/2024 02:31:29
ORA-19566: exceeded limit of 0 corrupt blocks for file /data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf

Recovery Manager complete.

查看alert_orcl.log日志报错如下

2024-08-25T21:08:19.404068+08:00
ARC3 (PID:2213402): Archived Log entry 4886 added for T-1.S-4891 ID 0x3724ce74 LAD:1
2024-08-25T21:31:19.231170+08:00
KILL SESSION for sid=(1867, 64225):
  Reason = profile limit idle_time
  Mode = KILL SOFT -/-/NO_REPLAY
  Requestor = PMON (orapid = 2, ospid = 2213246, inst = 1)
  Owner = Process: USER (orapid = 525, ospid = 2355342)
  Result = ORA-0
2024-08-25T22:10:22.273914+08:00
Hex dump of (file 3, block 152588) in trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_j000_575427.trc

Corrupt block relative dba: 0x00c2540c (file 3, block 152588)
Fractured block found during multiblock buffer read
Data in bad block:
 type: 6 format: 2 rdba: 0x00c2540c
 last change scn: 0x0000.0000.1a9d4078 seq: 0x1 flg: 0x06
 spare3: 0x0
 consistency value in tail: 0x656c7564
 check value in block header: 0xdcc0
 computed block checksum: 0xf829

Reading datafile '/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf' for corrupt data at rdba: 0x00c2540c (file 3, block 152588)
Reread (file 3, block 152588) found same corrupt data (no logical check)
Hex dump of (file 3, block 152589) in trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_j000_575427.trc

Corrupt block relative dba: 0x00c2540d (file 3, block 152589)
Bad header found during multiblock buffer read
Data in bad block:
 type: 1 format: 2 rdba: 0x00165d58
 last change scn: 0x0000.80a4.0000130c seq: 0x62 flg: 0x47
 spare3: 0x672d
 consistency value in tail: 0x00012a58
 check value in block header: 0x3272
 computed block checksum: 0x0

Reading datafile '/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf' for corrupt data at rdba: 0x00c2540d (file 3, block 152589)
2024-08-25T22:10:22.282345+08:00
Corrupt Block Found
2024-08-25T22:10:22.282400+08:00
Reread (file 3, block 152589) found same corrupt data (no logical check)
         TIME STAMP (GMT) = 08/25/2024 22:10:21
         CONT = 0, TSN = 1, TSNAME = SYSAUX
         RFN = 3, BLK = 152588, RDBA = 12735500
         OBJN = 8706, OBJD = 8706, OBJECT = WRI$_ADV_OBJECTS, SUBOBJECT =
         SEGMENT OWNER = SYS, SEGMENT TYPE = Table Segment
2024-08-25T22:10:22.286419+08:00
Corrupt Block Found
         TIME STAMP (GMT) = 08/25/2024 22:10:21
         CONT = 0, TSN = 1, TSNAME = SYSAUX
         RFN = 3, BLK = 152589, RDBA = 12735501
         OBJN = 8706, OBJD = 8706, OBJECT = WRI$_ADV_OBJECTS, SUBOBJECT =
         SEGMENT OWNER = SYS, SEGMENT TYPE = Table Segment
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_j000_575427.trc  (incident=296740):
ORA-01578: ORACLE data block corrupted (file # 3, block # 152588)
ORA-01110: data file 3: '/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf'
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_296740/orcl_j000_575427_i296740.trc
2024-08-25T22:10:30.325869+08:00
*****************************************************************
An internal routine has requested a dump of selected redo.
This usually happens following a specific internal error, when
analysis of the redo logs will help Oracle Support with the
diagnosis.
It is recommended that you retain all the redo logs generated (by
all the instances) during the past 12 hours, in case additional
redo dumps are required to help with the diagnosis.
*****************************************************************
2024-08-25T22:10:34.631225+08:00
Hex dump of (file 3, block 152588) in trace file /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_296740/orcl_mz00_575442_i296740_a.trc

Corrupt block relative dba: 0x00c2540c (file 3, block 152588)
Fractured block found during validation
Data in bad block:
 type: 6 format: 2 rdba: 0x00c2540c
 last change scn: 0x0000.0000.1a9d4078 seq: 0x1 flg: 0x06
 spare3: 0x0
 consistency value in tail: 0x656c7564
 check value in block header: 0xdcc0
 computed block checksum: 0xf829

Reread of blocknum=152588, file=/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf. found same corrupt data
Reread of blocknum=152588, file=/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf. found same corrupt data
Reread of blocknum=152588, file=/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf. found same corrupt data
Reread of blocknum=152588, file=/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf. found same corrupt data
Reread of blocknum=152588, file=/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf. found same corrupt data
Hex dump of (file 3, block 152589) in trace file /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_296740/orcl_mz00_575442_i296740_a.trc

Corrupt block relative dba: 0x00c2540d (file 3, block 152589)
Bad header found during validation
Data in bad block:
 type: 1 format: 2 rdba: 0x00165d58
 last change scn: 0x0000.80a4.0000130c seq: 0x62 flg: 0x47
 spare3: 0x672d
 consistency value in tail: 0x00012a58
 check value in block header: 0x3272
 computed block checksum: 0x0

Reread of blocknum=152589, file=/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf. found same corrupt data
Reread of blocknum=152589, file=/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf. found same corrupt data
Reread of blocknum=152589, file=/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf. found same corrupt data
Reread of blocknum=152589, file=/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf. found same corrupt data
Reread of blocknum=152589, file=/data/ORCL/datafile/o1_mf_sysaux_l1r6o7xr_.dbf. found same corrupt data
2024-08-26T00:05:41.474833+08:00
TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P16634 (5351) VALUES LESS THAN (TO_DATE(' 2024-08-26 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2024-08-26T02:00:00.119203+08:00
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
2024-08-26T02:30:05.025770+08:00
ALTER SYSTEM ARCHIVE LOG


SYS@orcl> select * from v$database_block_corruption;

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO     CON_ID
---------- ---------- ---------- ------------------ --------- ----------
         3     152588          1                  0 FRACTURED          0
         3     152589          1                  0 CORRUPT               0


RMAN> blockrecover datafile 3 block 152588,152589 ;

Starting recover at 23-OCT-24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3698 device type=DISK

channel ORA_DISK_1: restoring block(s)
channel ORA_DISK_1: specifying block(s) to restore from backup set
restoring blocks of datafile 00003
channel ORA_DISK_1: reading from backup piece /bak/rman/FULLBAK_ORCL_20240817_1172_1
channel ORA_DISK_1: piece handle=/bak/rman/FULLBAK_ORCL_20240817_1172_1 tag=TAG20240817T023005
channel ORA_DISK_1: restored block(s) from backup piece 1
channel ORA_DISK_1: block restore complete, elapsed time: 00:15:15

starting media recovery

archived log for thread 1 with sequence 5191 is already on disk as file /archlog/orcl/1_5191_1132248310.dbf
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4854
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4855
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240817_1174_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240817_1174_1 tag=TAG20240817T034954
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:56
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4856
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4857
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4858
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4859
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240818_1177_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240818_1177_1 tag=TAG20240818T023007
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:35
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4860
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4861
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4862
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4863
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240819_1179_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240819_1179_1 tag=TAG20240819T023007
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:15
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4864
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4865
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4866
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4867
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4868
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240820_1181_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240820_1181_1 tag=TAG20240820T023006
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:45
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4869
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4870
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4871
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4872
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4873
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240821_1183_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240821_1183_1 tag=TAG20240821T023006
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:36
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4874
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4875
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4876
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4877
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4878
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240822_1185_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240822_1185_1 tag=TAG20240822T023006
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:55
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4879
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4880
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4881
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4882
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240823_1188_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240823_1188_1 tag=TAG20240823T023007
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:06
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4883
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4884
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4885
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4886
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4887
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4888
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4889
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240825_1203_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240825_1203_1 tag=TAG20240825T023006
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:05:35
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4890
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4891
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4892
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4893
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240826_1212_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240826_1212_1 tag=TAG20240826T023007
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:45
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4894
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4895
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4896
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4897
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4898
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240827_1217_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240827_1217_1 tag=TAG20240827T023006
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:55
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4899
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4900
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4901
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4902
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240828_1222_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240828_1222_1 tag=TAG20240828T023006
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:45
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4903
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4904
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4905
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4906
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4907
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4908
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240829_1227_1
 channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240829_1227_1 tag=TAG20240829T023007
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:05
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4909
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4910
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4911
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4912
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4913
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240830_1232_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240830_1232_1 tag=TAG20240830T023006
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:05
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4914
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4915
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4916
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4917
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4918
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4919
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240901_1248_1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:07:05
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4920
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4921
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4922
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4923
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4924
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4925
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240901_1249_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240901_1249_1 tag=TAG20240901T023007
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4926
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4927
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4928
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4929
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240902_1258_1
channel ORA_DISK_1: piece handle=/bak/rman/ARCHBAK_ORCL_20240902_1258_1 tag=TAG20240902T023018
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:05
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4930
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4931
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4932
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4933
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4934
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4935
channel ORA_DISK_1: reading from backup piece /bak/rman/ARCHBAK_ORCL_20240903_1263_1
。。。。。。。。。。。。
。。。。。。。。。。。。
。。。。。。。。。。。。
channel ORA DISK 1:restore complete, elapsed time: 00:00:55
media recovery complete, elapsed time: 00:04:51
Finished recoverat 24-0CT-24

SYS@orcl> select * from v$database_block_corruption;

no rows selected

SYS@orcl>

相关文章：

坏块处理 ORA-01578: ORACLE data block corrupted (file # 3, block # 152588)

帮客户检查环境时，发现sysaux表空间的数据文件有坏块，8月25日发生的，备份保留3个月，直接恢复处理。 rman备份log报错如下 RMAN-00571: RMAN-00569: ERROR MESSAGE STACK FOLLOWS RMAN-00571: RMAN-03009: failure of backu…...

编程日记 2024/11/2 19:49:44

像`npm i`作为`npm install`的简写一样，使用`pdm i`作为`pdm install`的简写

只需安装插件pdm-plugin-i即可： pdm plugin add pdm-plugin-i 然后就可以愉快地pdm i了，例如： git clone https://github.com/waketzheng/fast-dev-cli cd fast-dev-cli python -m pip install --user pipx pipx install pdm pdm plugin a…...

编程日记 2024/11/2 19:47:42

DNS域名解析服务器--RHCE

1.DNS简介 DNS （ Domain Name System ）是互联网上的一项服务，它作为将域名和 IP 地址相互映射的一个分布式 数据库，能够使人更方便的访问互联网 DNS 系统使用的是网络的查询，那么自然需要有监听的 port 。 DNS 使用的是…...

编程日记 2024/11/2 19:46:41

数据库物化视图的工作原理与Java实现

引言 物化视图（Materialized View）是数据库中一种特殊的对象，它存储了查询结果的物理副本，使得复杂查询的结果可以快速地被访问。本文将详细介绍物化视图的工作原理、技术策略，并提供Java代码示例。 1. 物化视图的基…...

编程日记 2024/11/2 19:44:38

炫酷的登录框!(附源码)

大家想看什么前端效果请留言 预览效果 源码 <!DOCTYPE html> <html lang"zh"> <head><meta charset"UTF-8"><meta name"viewport" content"widthdevice-width, initial-scale1.0"><title>登录页…...

编程日记 2024/11/2 19:42:35

使用Python实现智能生态系统监测与保护的深度学习模型

随着人类活动的增加，生态系统受到的威胁也在不断加剧。为了更好地保护我们的生态环境，智能生态系统监测与保护成为了一项重要的任务。通过深度学习技术，我们可以实现生态系统的自动化监测与管理，从而及时发现和应对环境变化。本文将详细介绍如何使用Python构建一个深度学习…...

编程日记 2024/11/2 19:41:35

Rust 力扣 - 54. 螺旋矩阵

文章目录 题目描述题解思路题解代码题目链接 题目描述 题解思路 我们只需要一圈一圈的从外向内遍历矩阵&#xff0c;每一圈遍历顺序为上边、右边、下边、左边 我们需要注意的是如果上边与下边重合或者是右边与左边重合&#xff0c;我们只需要遍历上边、右边即可 题解代码 i…...

编程日记 2024/11/2 19:40:33

Flutter 简述(1)

Flutter 简述 简述 Flutter是Google开源的应用框架&#xff0c;只要一套代码兼顾Android、iOS、Web、Windows、macOS和Linux六个平台&#xff0c;它的设计思路可以说更加先进&#xff0c;不像ReactNative每个组件都需要有对应的原生组件实现&#xff0c;而是通过skia或者其他…...

编程日记 2024/11/2 19:39:32

BGP实验--BGP路由反射器

AR1、AR2上的Loopback 1接口分别为10.1.1.1/24、10.2.2.2/24&#xff0c;用于模拟用户网段 所有设备均使用Loopback 0地址为BGP Router ID&#xff0c;AR1与AR2、AR2与AR3、AR3与AR4、AR4与AR2之间基于直连接口建立IBGP对等体关系&#xff0c;其中AR1为AR2的路由反射器客户端&a…...

编程日记 2024/11/2 19:38:30

域渗透-域环境部署

01-域渗透部署 一、工作组和域 1、为什么需要域 在早期Windows主机都是属于工作组网络&#xff0c;单独的个体&#xff0c;在企业环境中&#xff0c;针对于工作组网络的计算机要达到统一管理相当麻烦&#xff0c;为实现将一个企业中所有的用户和计算机进行集中管理&#xff…...

编程日记 2024/11/2 19:36:26

【Oracle】空格单字符通配符查询匹配失败

问题 在进行模糊查询的时候&#xff0c;通过全局任意字符串匹配出含有两个字刘姓的人&#xff0c;但是通过刘_不能匹配出结果。 解决 检查后发现&#xff0c;姓名中包含空格 SELECT * FROM student WHERE TRIM(sname) LIKE 刘_;第一种解决方案就是查询的时候进行去空格处理&a…...

编程日记 2024/11/2 19:34:23

uniapp实现中间平滑凸起tabbar

uniapp实现中间平滑凸起tabbar 背景实现思路代码实现尾巴 背景 在移动端开发中&#xff0c;tabar是一个使用频率很高的组件&#xff0c;几乎是每个APP都会用到。今天给大家分享一个中间平滑凸起的tabbar组件&#xff0c;有需要的可以做下参考。先上图镇楼&#xff1a; 实现思…...

编程日记 2024/11/2 19:31:20

【视频】OpenCV：识别颜色、绘制轮廓

1、安装OpenCV库 sudo apt install libopencv-dev2、链接库 将 OpenCV 头文件路径和库添加到CMake中，在 CMakeLists.txt 中添加 1）查找库 find_package(OpenCV REQUIRED) 或者 find_package(OpenCV REQUIRED core imgproc highgui) 2）添加头文件路径 include_directories…...

编程日记 2024/11/2 19:30:19

C++_STL_xx_番外01_关于STL的总结(常见容器的总结；关联式容器分类及特点；二叉树、二叉搜索树、AVL树(平衡二叉搜索树)、B树、红黑树)

文章目录 1. 常用容器总结2. 关联式容器分类3. 二叉树、二叉搜索树、AVL树、B树、红黑树 1. 常用容器总结 针对常用容器的一些总结&#xff1a; 2. 关联式容器分类 关联式容器分为两大类&#xff1a; 基于红黑树的set和map&#xff1b;基于hash表的unorder_set和unorder_ma…...

编程日记 2024/11/2 19:27:15

xlrd.biffh.XLRDError: Excel xlsx file； not supported

文章目录 一、问题报错二、报错原因三、解决思路四、解决方法 一、问题报错 在处理Excel文件时&#xff0c;特别是当我们使用Python的xlrd库来读取.xlsx格式的文件&#xff0c;偶尔会遇到这样一个错误&#xff1a;“xlrd.biffh.XLRDError: Excel xlsx file; not supported”。…...

编程日记 2024/11/2 19:26:14

ENNSP中ACL的实验配置

ACL&#xff1a;访问控制列表 1访问控制----在路由器的入或者出的接口上&#xff0c;匹配流量&#xff0c;之后产生动作---允许或拒绝 2.定义感兴趣流量-----帮助其他软件抓流量 访问控制的匹配规则&#xff1a; 拓扑图如下 基础配置 基础配置弄好后&#xff0c;随便p…...

编程日记 2024/11/2 19:23:11

数字后端零基础入门系列 | Innovus零基础LAB学习Day8

###LAB15 Detail Routing for Signal Integrity, Timing, Power and Design for Yield 这个章节虽然标题有点长&#xff0c;但不要被它吓到&#xff0c;其实这个章节就是Innovus工具的绕线Routing。只不过这个阶段做Route不是仅仅是把所有的逻辑连接&#xff0c;用实际的金属层…...

编程日记 2024/11/2 19:20:08

【AI开源项目】FastGPT- 快速部署FastGPT以及使用知识库的两种方式！

文章目录 一、FastGPT大模型介绍1. 开发团队2. 发展史3. 基本概念 二、FastGPT与其他大模型的对比三、使用 Docker Compose 快速部署 FastGPT1、安装 Docker 和 Docker Compose&#xff08;1&#xff09;. 安装 Docker&#xff08;2&#xff09;. 安装 Docker Compose&#xff…...

编程日记 2024/11/2 19:19:06

信息学科平台系统开发：Spring Boot实用指南

3系统分析 3.1可行性分析 通过对本基于保密信息学科平台系统实行的目的初步调查和分析&#xff0c;提出可行性方案并对其一一进行论证。我们在这里主要从技术可行性、经济可行性、操作可行性等方面进行分析。 3.1.1技术可行性 本基于保密信息学科平台系统采用Spring Boot框架&a…...

编程日记 2024/11/2 19:17:05

笔记本电脑买i7还是i9？i7和i9处理器区别详细介绍

i7和i9处理器都是英特尔&#xff08;Intel&#xff09;公司生产的高性能处理器&#xff0c;但它们有一些显著的区别。为了帮助你做出明智的选择&#xff0c;下面我们详细介绍一下i7和i9处理器的区别&#xff0c;以及如何根据你的需求来选择合适的处理器。 一、i7处理器的特点…...

编程日记 2024/11/2 19:14:02

Model Context Protocol (MCP) 是一个前沿框架

微软发布了 Model Context Protocol (MCP) 课程&#xff1a;mcp-for-beginners。 Model Context Protocol (MCP) 是一个前沿框架&#xff0c;涵盖 C#、Java、JavaScript、TypeScript 和 Python 等主流编程语言&#xff0c;规范 AI 模型与客户端应用之间的交互。 MCP 课程结构 …...

编程新知 2025/6/8 12:10:06

【基础算法】枚举（普通枚举、二进制枚举）

文章目录 一、普通枚举1. 铺地毯(1) 解题思路(2) 代码实现 2. 回文日期(1) 解题思路思路一&#xff1a;暴力枚举思路二&#xff1a;枚举年份思路三&#xff1a;枚举月日 (2) 代码实现 3. 扫雷(2) 解题思路(2) 代码实现 二、二进制枚举1. 子集(1) 解题思路(2) 代码实现 2. 费解的…...

编程新知 2025/6/8 11:53:04

网络通讯知识——通讯分层介绍，gRPC，RabbitMQ分层

网络通讯分层 网络通讯分层是为了将复杂的网络通信问题分解为多个独立、可管理的层次&#xff0c;每个层次专注于特定功能。目前主流的分层模型包括OSI七层模型和TCP/IP四层&#xff08;或五层&#xff09;模型&#xff0c;以下是详细解析&#xff1a; 一、OSI七层模型&#…...

编程新知 2025/6/8 10:41:51

以智能管理为基础，楼宇自控打造建筑碳中和新路径

在全球气候变化的严峻形势下&#xff0c;“碳中和”已成为各国发展的重要战略目标。建筑行业作为能源消耗与碳排放的“大户”&#xff0c;其运行阶段的能耗占全社会总能耗近40%&#xff0c;碳排放占比与之相当&#xff0c;实现建筑碳中和迫在眉睫。传统建筑管理模式下&#xff…...

编程新知 2025/6/8 7:40:58

巴西医疗巨头尤迈Kafka数据泄露事件的全过程分析与AI安防策略分析

一、事件背景与主体信息 涉事主体：Unimed，全球最大医疗合作社，巴西医疗行业龙头企业，拥有约1500万客户。技术背景：泄露源于其未保护的Kafka实例（开源实时数据传输平台），用于客户与聊天机器人“Sara”及医生的实时通信。二、时间线梳理 时间节点关键事件描述2025年3月24…...

编程新知 2025/6/8 5:37:22

任务调度器-关于中心化调度 vs 去中心化调度的核心区别

1. 定义与架构模型 维度中心化调度去中心化调度核心角色存在一个中央调度器&#xff08;如XXL-JOB的调度中心&#xff09;&#xff0c;统一管理任务分配、状态监控和故障处理。无中心节点&#xff0c;调度逻辑分散在多个节点&#xff0c;通过共识算法&#xff08;如选举机制&a…...

编程新知 2025/6/8 5:09:46

Druid连接池实现自定义数据库密码加解密功能详解

Druid连接池实现自定义数据库密码加解密功能详解 在企业级应用开发中&#xff0c;数据库密码的明文存储是一个显著的安全隐患。Druid作为阿里巴巴开源的高性能数据库连接池组件&#xff0c;提供了灵活的密码加密与解密功能&#xff0c;允许开发者通过自定义逻辑实现数据库密码…...

编程新知 2025/6/7 22:44:49

强化学习基础概念图文版笔记

&#x1f4d8; 强化学习基础概念图文版笔记 1️⃣ 基本框架&#xff1a;Agent 与 Environment &#x1f9e0; 核心角色&#xff1a; Agent&#xff08;智能体&#xff09;&#xff1a;做出决策的“大脑”&#xff0c;根据当前状态选择动作。Environment&#xff08;环境&…...

编程新知 2025/6/7 22:41:34

告别数据泥沼，拥抱智能中枢：King’s四位一体重塑科研生产力

在现代科研的战场上&#xff0c;数据堪称科研人员手中的“弹药”。然而&#xff0c;许多实验室却深陷数据管理的泥沼&#xff1a;硬盘里堆满了不同年份的实验记录&#xff0c;U盘里塞着各种格式的谱图&#xff0c;Excel表格里还留着手动计算的痕迹……&#xff0c;当科研人员想…...

编程新知 2025/6/7 16:21:18

HarmonyOS Next 弹窗系列教程（4）

HarmonyOS Next 弹窗系列教程&#xff08;4&#xff09; 介绍 本章主要介绍和用户点击关联更加密切的菜单控制&#xff08;Menu&#xff09; 和 气泡提示&#xff08;Popup&#xff09; 它们出现显示弹窗出现的位置都是在用户点击屏幕的位置相关 菜单控制&#xff08;Menu&…...

编程新知 2025/6/7 15:26:48