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

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

news 2026/2/9 19:12:48

帮客户检查环境时，发现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

龙虎榜——20250610

上证指数放量收阴线&#xff0c;个股多数下跌&#xff0c;盘中受消息影响大幅波动。 深证指数放量收阴线形成顶分型&#xff0c;指数短线有调整的需求&#xff0c;大概需要一两天。 2025年6月10日龙虎榜行业方向分析 1. 金融科技 代表标的&#xff1a;御银股份、雄帝科技 驱动…...

编程新知 2026/2/8 15:03:06

日语AI面试高效通关秘籍：专业解读与青柚面试智能助攻

在如今就业市场竞争日益激烈的背景下&#xff0c;越来越多的求职者将目光投向了日本及中日双语岗位。但是&#xff0c;一场日语面试往往让许多人感到步履维艰。你是否也曾因为面试官抛出的“刁钻问题”而心生畏惧&#xff1f;面对生疏的日语交流环境&#xff0c;即便提前恶补了…...

编程新知 2026/2/8 4:37:01

stm32G473的flash模式是单bank还是双bank？

今天突然有人stm32G473的flash模式是单bank还是双bank&#xff1f;由于时间太久&#xff0c;我真忘记了。搜搜发现&#xff0c;还真有人和我一样。见下面的链接&#xff1a;https://shequ.stmicroelectronics.cn/forum.php?modviewthread&tid644563 根据STM32G4系列参考手…...

编程新知 2026/2/8 20:41:51

【人工智能】神经网络的优化器optimizer（二）：Adagrad自适应学习率优化器

一.自适应梯度算法Adagrad概述 Adagrad&#xff08;Adaptive Gradient Algorithm&#xff09;是一种自适应学习率的优化算法&#xff0c;由Duchi等人在2011年提出。其核心思想是针对不同参数自动调整学习率&#xff0c;适合处理稀疏数据和不同参数梯度差异较大的场景。Adagrad通…...

编程新知 2026/2/8 14:57:14

基于Uniapp开发HarmonyOS 5.0旅游应用技术实践

一、技术选型背景 1.跨平台优势 Uniapp采用Vue.js框架&#xff0c;支持"一次开发&#xff0c;多端部署"&#xff0c;可同步生成HarmonyOS、iOS、Android等多平台应用。 2.鸿蒙特性融合 HarmonyOS 5.0的分布式能力与原子化服务&#xff0c;为旅游应用带来&#xf…...

编程新知 2026/2/5 20:33:43

基于当前项目通过npm包形式暴露公共组件

1.package.sjon文件配置 其中xh-flowable就是暴露出去的npm包名 2.创建tpyes文件夹&#xff0c;并新增内容 3.创建package文件夹...

编程新知 2026/2/1 21:58:45

如何将联系人从 iPhone 转移到 Android

从 iPhone 换到 Android 手机时&#xff0c;你可能需要保留重要的数据&#xff0c;例如通讯录。好在&#xff0c;将通讯录从 iPhone 转移到 Android 手机非常简单&#xff0c;你可以从本文中学习 6 种可靠的方法&#xff0c;确保随时保持连接&#xff0c;不错过任何信息。 第 1…...

编程新知 2026/1/31 5:09:27

HTML前端开发：JavaScript 常用事件详解

作为前端开发的核心&#xff0c;JavaScript 事件是用户与网页交互的基础。以下是常见事件的详细说明和用法示例&#xff1a; 1. onclick - 点击事件 当元素被单击时触发&#xff08;左键点击&#xff09; button.onclick function() {alert("按钮被点击了&#xff01;&…...

编程新知 2025/11/10 10:45:11

让回归模型不再被异常值“带跑偏“，MSE和Cauchy损失函数在噪声数据环境下的实战对比

在机器学习的回归分析中&#xff0c;损失函数的选择对模型性能具有决定性影响。均方误差&#xff08;MSE&#xff09;作为经典的损失函数&#xff0c;在处理干净数据时表现优异&#xff0c;但在面对包含异常值的噪声数据时&#xff0c;其对大误差的二次惩罚机制往往导致模型参数…...

编程新知 2026/1/28 2:18:46

day36-多路IO复用

一、基本概念 &#xff08;服务器多客户端模型&#xff09; 定义&#xff1a;单线程或单进程同时监测若干个文件描述符是否可以执行IO操作的能力 作用&#xff1a;应用程序通常需要处理来自多条事件流中的事件&#xff0c;比如我现在用的电脑&#xff0c;需要同时处理键盘鼠标…...

编程新知 2026/1/31 7:42:50