首页    技术博客    PHP教程    数据库技术    前端开发   HTML5    Nginx    php论坛
新用户注册 | 会员登录
加入会员，解锁专属内容
取消
热门标签 | HotTags
当前位置:  开发笔记 > 编程语言 > 正文

oraclerevoveryora01110,OracleAdg备库ORA10458ORA01196ORA01110:ORA10458故障处理

作者：阳光-沙滩男人 | 来源：互联网 | 2024-09-29 14:13
一环境：主库：Oracle双节点RAC19.6C(Linux)备库：Oracle双节点RAC19.6C(Linux)二详细报错࿱

一 环境&＃xff1a;

主库&＃xff1a;Oracle 双节点RAC 19.6C(Linux)

备库&＃xff1a;Oracle 双节点RAC 19.6C(Linux)

二 详细报错&＃xff1a;

Errors with log &＃43;ORA19CB_ARCH/ORA19CB/ARCHIVELOG/2021_02_07/thread_1_seq_809.315.1063907805

2021-02-16T11:07:34.513934&＃43;08:00

Standby Crash Recovery aborted due to error 16016.

2021-02-16T11:07:34.621378&＃43;08:00

Errors in file /oracle/app/oracle/diag/rdbms/ora19cb/ora19cb1/trace/ora19cb1_ora_9831.trc:

ORA-16016: archived log for thread 2 sequence# 809 unavailable

2021-02-16T11:07:37.026592&＃43;08:00

Recovery interrupted!

Some recovered datafiles maybe left media fuzzy

Media recovery may continue but open resetlogs may fail

stopping change tracking

2021-02-16T11:07:38.154299&＃43;08:00

Completed Standby Crash Recovery.

2021-02-16T11:07:44.616632&＃43;08:00

Errors in file /oracle/app/oracle/diag/rdbms/ora19cb/ora19cb1/trace/ora19cb1_ora_9831.trc:

ORA-10458: standby database requires recovery

ORA-01196: file 1 is inconsistent due to a failed media recovery session

ORA-01110: data file 1: &＃39;&＃43;ORA19CB_DATA/ORA19CB/DATAFILE/system.262.1046531145&＃39;

ORA-10458 signalled during: ALTER DATABASE OPEN /* db agent *//* {1:27996:2} */...

2021-02-16T11:07:47.129461&＃43;08:00

故障原因&＃xff1a;

由于测试环境主机频繁重启&＃xff0c;导致数据不一致(猜测)

处理方法&＃xff1a;

分析原因后&＃xff0c;找了好多处理思路&＃xff0c;都是建议重新duplicate&＃xff0c;但Oracle ADG 归档丢失后备库无法应用的场景下有一种处理方法&＃xff0c;我们通过此思路继续一步一步处理&＃xff0c;首先在备库查询当前的SCN 然后在主库基于SCN 进行备份数据和控制文件&＃xff0c;在备库进行恢复&＃xff0c;处理报错&＃xff1a;

1)主库通过Broker 停止日志传输和日志应用&＃xff1a;

edit database &＃39;ora19cb&＃39; set STATE&＃61;&＃39;APPLY-OFF&＃39; ;

edit database &＃39;ora19c&＃39; set STATE&＃61;&＃39;TRANSPORT-OFF&＃39; ;

2)备库确认SCN&＃xff1a;

SELECT CURRENT_SCN FROM V$DATABASE;

select min(checkpoint_change#) from v$datafile_header

3)主库备份&＃xff1a;

BACKUP INCREMENTAL FROM SCN 3162298 DATABASE FORMAT &＃39;/tmp/ForStandby_%U&＃39; tag &＃39;FORSTANDBY&＃39;;

BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT &＃39;/tmp/ForStandbyCTRL.bck&＃39;;

4) 备库恢复&＃xff1a;

RMAN> SHUTDOWN IMMEDIATE ;

RMAN> STARTUP NOMOUNT;

RMAN> RESTORE STANDBY CONTROLFILE FROM &＃39;/tmp/ForStandbyCTRL.bck&＃39;;

RMAN> ALTER DATABASE MOUNT;

RMAN> RESTORE STANDBY CONTROLFILE FROM &＃39;/oracle/software/ForStandbyCTRL.bck&＃39;;

Starting restore at 2021-02-20 16:04:15

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID&＃61;65 instance&＃61;ora19cb1 device type&＃61;DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:02

output file name&＃61;&＃43;ORA19CB_DATA/ORA19CB/CONTROLFILE/current.265.1046531113

Finished restore at 2021-02-20 16:04:17

RMAN> ALTER DATABASE MOUNT;

released channel: ORA_DISK_1

Statement processed

RMAN> list incarnation;

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       1       ORA19C   1068822584       PARENT  1          2019-04-17 00:55:59

2       2       ORA19C   1068822584       CURRENT 1920977    2019-08-07 00:42:40

此时后台会有大量的文件rename 告警&＃xff1a;

*****************************************

WARNING: The converted filename &＃39;&＃43;ORA19CB_DATA/ora19c/aaf3729430b47162e0531e38a8c01874/datafile/ts_swing.294.1046413467&＃39;

is an ASM fully qualified filename.

Changing the filename to &＃39;&＃43;ORA19CB_DATA/MUST_RENAME_THIS_DATAFILE_20.4294967295.4294967295&＃39;.

Please rename it accordingly.

*****************************************

2020-07-23T15:05:44.180520&＃43;08:00

*****************************************

WARNING: The converted filename &＃39;&＃43;ORA19CB_DATA/ora19c/datafile/system.258.1015634281&＃39;

is an ASM fully qualified filename.

Changing the filename to &＃39;&＃43;ORA19CB_DATA/MUST_RENAME_THIS_DATAFILE_1.4294967295.4294967295&＃39;.

Please rename it accordingly.

*****************************************

继续

RMAN> SWITCH DATABASE TO COPY;

RMAN> SWITCH DATABASE TO COPY;

datafile 1 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/DATAFILE/system.262.1046531145"

datafile 3 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/DATAFILE/sysaux.261.1046531261"

datafile 4 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/DATAFILE/undotbs1.260.1046531357"

datafile 5 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/8F8000E513704E63E0531E38A8C0B3E8/DATAFILE/system.259.1046531373"

datafile 6 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/8F8000E513704E63E0531E38A8C0B3E8/DATAFILE/sysaux.257.1046531389"

datafile 7 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/DATAFILE/users.271.1046531405"

datafile 8 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/8F8000E513704E63E0531E38A8C0B3E8/DATAFILE/undotbs1.270.1046531407"

datafile 9 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/DATAFILE/undotbs2.269.1046531417"

datafile 24 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/B359E4EB6F914FF6E0531E38A8C0072D/DATAFILE/system.284.1063557913"

datafile 25 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/B359E4EB6F914FF6E0531E38A8C0072D/DATAFILE/sysaux.263.1063557935"

datafile 26 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/B359E4EB6F914FF6E0531E38A8C0072D/DATAFILE/undotbs1.285.1063557951"

datafile 27 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/B359E4EB6F944FF6E0531E38A8C0072D/DATAFILE/system.286.1063557971"

datafile 28 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/B359E4EB6F944FF6E0531E38A8C0072D/DATAFILE/sysaux.272.1063557981"

datafile 29 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/B359E4EB6F944FF6E0531E38A8C0072D/DATAFILE/undotbs1.288.1063557993"

datafile 30 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/B359E4EB6F914FF6E0531E38A8C0072D/DATAFILE/undo_2.289.1063557997"

datafile 31 switched to datafile copy "&＃43;ORA19CB_DATA/ORA19CB/B359E4EB6F944FF6E0531E38A8C0072D/DATAFILE/undo_2.290.1063558003

如果有报错可以使用 switch datafile file# to copy;

5) 处理报错

数据库open 后台还有大量的 WARNING&＃xff0c;主要是redo 的路径和temp。我通过adg 备库调好redo 的方法把redo 和temp 替换了&＃xff1a;

SQL> alter database recover  managed  standby database cancel;

Database altered.

SQL> alter system set standby_file_management&＃61;manual;

System altered.

SQL> alter database open;

Database altered.

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

SQL> alter database drop logfile group 4;

Database altered.

SQL>

SQL>

SQL>

SQL> alter database add logfile thread 1 group 2 (&＃39;&＃43;ORA19CB_DATA&＃39;) size 209715200;

alter database add logfile thread 2 group 3 (&＃39;&＃43;ORA19CB_DATA&＃39;) size 209715200;

alter database add logfile thread 2 group 4 (&＃39;&＃43;ORA19CB_DATA&＃39;) size 209715200;

Database altered.

SQL>

Database altered.

SQL>

Database altered.

SQL> select name from v$tempfile;

NAME

----------------------------------------------------------------------------------------------------------------

&＃43;ORA19CB_DATA/ORA19CB/TEMPFILE/temp.304.1065025445

&＃43;ORA19CB_DATA/ORA19CB/8F8000E513704E63E0531E38A8C0B3E8/TEMPFILE/temp.305.1065025455

&＃43;ORA19CB_DATA/MUST_RENAME_THIS_TEMPFILE_3.4294967295.4294967295

&＃43;ORA19CB_DATA/MUST_RENAME_THIS_TEMPFILE_4.4294967295.4294967295

SQL>  alter tablespace temp add  tempfile &＃39;&＃43;ORA19CB_DATA&＃39; size 50M;

Tablespace altered.

SQL> alter tablespace temp drop tempfile 3;

Tablespace altered.

SQL> conn / as sysdba

Connected.

SQL> show pdbs;

CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED                       READ ONLY  NO

3 PDBTS1                         READ ONLY  NO

4 PDBTS2                         READ ONLY  NO

SQL> alter session set container&＃61;&PDBNAME ;

Enter value for pdbname: PDBTS2

old   1: alter session set container&＃61;&PDBNAME

new   1: alter session set container&＃61;PDBTS2

Session altered.

SQL> alter tablespace temp add  tempfile &＃39;&＃43;ORA19CB_DATA&＃39; size 50M;

Tablespace altered.

SQL> alter tablespace temp drop tempfile 4;

Tablespace altered.

SQL> select name from v$tempfile;

NAME

--------------------------------------------------------------------------------

&＃43;ORA19CB_DATA/ORA19CB/B359E4EB6F944FF6E0531E38A8C0072D/TEMPFILE/temp.309.1065026937

6) 至此数据恢复完成&＃xff0c;继续ADG 关系恢复&＃xff1a;

备库&＃xff1a;

SQL> alter system set standby_file_management&＃61;auto;

System altered.

主库&＃xff1a;

edit database &＃39;ora19cb&＃39; set STATE&＃61;&＃39;APPLY-ON&＃39; ;

edit database &＃39;ora19c&＃39; set STATE&＃61;&＃39;TRANSPORT-ON&＃39; ;

oracle&＃64;ora19c1:[/home/oracle]$dgmgrl /

DGMGRL for Linux: Release 19.0.0.0.0 - Production on Sat Feb 20 16:15:14 2021

Version 19.7.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.

Connected to "ora19c"

Connected as SYSDG.

DGMGRL> edit database &＃39;ora19cb&＃39; set STATE&＃61;&＃39;APPLY-ON&＃39; ;

Succeeded.

DGMGRL> show database verbose ora19cb;

Database - ora19cb

Role:               PHYSICAL STANDBY

Intended State:     APPLY-ON

Transport Lag:      (unknown)

Apply Lag:          (unknown)

Average Apply Rate: (unknown)

Active Apply Rate:  (unknown)

Maximum Apply Rate: (unknown)

Real Time Query:    OFF

Instance(s):

ora19cb1 (apply instance)

ora19cb2

Properties:

DGConnectIdentifier             &＃61; &＃39;yydbb_s&＃39;

ObserverConnectIdentifier       &＃61; &＃39;&＃39;

FastStartFailoverTarget         &＃61; &＃39;&＃39;

PreferredObserverHosts          &＃61; &＃39;&＃39;

LogShipping                     &＃61; &＃39;ON&＃39;

RedoRoutes                      &＃61; &＃39;&＃39;

LogXptMode                      &＃61; &＃39;ASYNC&＃39;

DelayMins                       &＃61; &＃39;0&＃39;

Binding                         &＃61; &＃39;OPTIONAL&＃39;

MaxFailure                      &＃61; &＃39;0&＃39;

ReopenSecs                      &＃61; &＃39;300&＃39;

NetTimeout                      &＃61; &＃39;30&＃39;

RedoCompression                 &＃61; &＃39;DISABLE&＃39;

PreferredApplyInstance          &＃61; &＃39;&＃39;

ApplyInstanceTimeout            &＃61; &＃39;0&＃39;

ApplyLagThreshold               &＃61; &＃39;30&＃39;

TransportLagThreshold           &＃61; &＃39;30&＃39;

TransportDisconnectedThreshold  &＃61; &＃39;30&＃39;

ApplyParallel                   &＃61; &＃39;AUTO&＃39;

ApplyInstances                  &＃61; &＃39;0&＃39;

StandbyFileManagement           &＃61; &＃39;&＃39;

ArchiveLagTarget                &＃61; &＃39;0&＃39;

LogArchiveMaxProcesses          &＃61; &＃39;0&＃39;

LogArchiveMinSucceedDest        &＃61; &＃39;0&＃39;

DataGuardSyncLatency            &＃61; &＃39;0&＃39;

LogArchiveTrace                 &＃61; &＃39;0&＃39;

LogArchiveFormat                &＃61; &＃39;&＃39;

DbFileNameConvert               &＃61; &＃39;&＃39;

LogFileNameConvert              &＃61; &＃39;&＃39;

ArchiveLocation                 &＃61; &＃39;&＃39;

AlternateLocation               &＃61; &＃39;&＃39;

StandbyArchiveLocation          &＃61; &＃39;&＃39;

StandbyAlternateLocation        &＃61; &＃39;&＃39;

InconsistentProperties          &＃61; &＃39;(monitor)&＃39;

InconsistentLogXptProps         &＃61; &＃39;(monitor)&＃39;

LogXptStatus                    &＃61; &＃39;(monitor)&＃39;

SendQEntries                    &＃61; &＃39;(monitor)&＃39;

RecvQEntries                    &＃61; &＃39;(monitor)&＃39;

HostName(*)

StaticConnectIdentifier(*)

TopWaitEvents(*)

SidName(*)

(*) - Please check specific instance for the property value

Log file locations(*):

(*) - Check specific instance for log file locations.

Database Status:

SUCCESS

DGMGRL>  show database verbose ora19c;

Database - ora19c

Role:               PRIMARY

Intended State:     TRANSPORT-OFF

Instance(s):

ora19c1

Error: ORA-16739: redo transport service for member "ora19cb" is running

ora19c2

Error: ORA-16739: redo transport service for member "ora19cb" is running

Properties:

DGConnectIdentifier             &＃61; &＃39;yydb_p&＃39;

ObserverConnectIdentifier       &＃61; &＃39;&＃39;

FastStartFailoverTarget         &＃61; &＃39;&＃39;

PreferredObserverHosts          &＃61; &＃39;&＃39;

LogShipping                     &＃61; &＃39;ON&＃39;

RedoRoutes                      &＃61; &＃39;&＃39;

LogXptMode                      &＃61; &＃39;ASYNC&＃39;

DelayMins                       &＃61; &＃39;0&＃39;

Binding                         &＃61; &＃39;optional&＃39;

MaxFailure                      &＃61; &＃39;0&＃39;

ReopenSecs                      &＃61; &＃39;300&＃39;

NetTimeout                      &＃61; &＃39;30&＃39;

RedoCompression                 &＃61; &＃39;DISABLE&＃39;

PreferredApplyInstance          &＃61; &＃39;&＃39;

ApplyInstanceTimeout            &＃61; &＃39;0&＃39;

ApplyLagThreshold               &＃61; &＃39;30&＃39;

TransportLagThreshold           &＃61; &＃39;30&＃39;

TransportDisconnectedThreshold  &＃61; &＃39;30&＃39;

ApplyParallel                   &＃61; &＃39;AUTO&＃39;

ApplyInstances                  &＃61; &＃39;0&＃39;

StandbyFileManagement           &＃61; &＃39;&＃39;

ArchiveLagTarget                &＃61; &＃39;0&＃39;

LogArchiveMaxProcesses          &＃61; &＃39;0&＃39;

LogArchiveMinSucceedDest        &＃61; &＃39;0&＃39;

DataGuardSyncLatency            &＃61; &＃39;0&＃39;

LogArchiveTrace                 &＃61; &＃39;0&＃39;

LogArchiveFormat                &＃61; &＃39;&＃39;

DbFileNameConvert               &＃61; &＃39;&＃39;

LogFileNameConvert              &＃61; &＃39;&＃39;

ArchiveLocation                 &＃61; &＃39;&＃39;

AlternateLocation               &＃61; &＃39;&＃39;

StandbyArchiveLocation          &＃61; &＃39;&＃39;

StandbyAlternateLocation        &＃61; &＃39;&＃39;

InconsistentProperties          &＃61; &＃39;(monitor)&＃39;

InconsistentLogXptProps         &＃61; &＃39;(monitor)&＃39;

LogXptStatus                    &＃61; &＃39;(monitor)&＃39;

SendQEntries                    &＃61; &＃39;(monitor)&＃39;

RecvQEntries                    &＃61; &＃39;(monitor)&＃39;

HostName(*)

StaticConnectIdentifier(*)

TopWaitEvents(*)

SidName(*)

(*) - Please check specific instance for the property value

Log file locations(*):

(*) - Check specific instance for log file locations.

Database Status:

ERROR

DGMGRL> edit database &＃39;ora19c&＃39; set STATE&＃61;&＃39;TRANSPORT-ON&＃39; ;

Succeeded.

DGMGRL> show database verbose ora19c;

Database - ora19c

Role:               PRIMARY

Intended State:     TRANSPORT-ON

Instance(s):

ora19c1

ora19c2

Properties:

DGConnectIdentifier             &＃61; &＃39;yydb_p&＃39;

ObserverConnectIdentifier       &＃61; &＃39;&＃39;

FastStartFailoverTarget         &＃61; &＃39;&＃39;

PreferredObserverHosts          &＃61; &＃39;&＃39;

LogShipping                     &＃61; &＃39;ON&＃39;

RedoRoutes                      &＃61; &＃39;&＃39;

LogXptMode                      &＃61; &＃39;ASYNC&＃39;

DelayMins                       &＃61; &＃39;0&＃39;

Binding                         &＃61; &＃39;optional&＃39;

MaxFailure                      &＃61; &＃39;0&＃39;

ReopenSecs                      &＃61; &＃39;300&＃39;

NetTimeout                      &＃61; &＃39;30&＃39;

RedoCompression                 &＃61; &＃39;DISABLE&＃39;

PreferredApplyInstance          &＃61; &＃39;&＃39;

ApplyInstanceTimeout            &＃61; &＃39;0&＃39;

ApplyLagThreshold               &＃61; &＃39;30&＃39;

TransportLagThreshold           &＃61; &＃39;30&＃39;

TransportDisconnectedThreshold  &＃61; &＃39;30&＃39;

ApplyParallel                   &＃61; &＃39;AUTO&＃39;

ApplyInstances                  &＃61; &＃39;0&＃39;

StandbyFileManagement           &＃61; &＃39;&＃39;

ArchiveLagTarget                &＃61; &＃39;0&＃39;

LogArchiveMaxProcesses          &＃61; &＃39;0&＃39;

LogArchiveMinSucceedDest        &＃61; &＃39;0&＃39;

DataGuardSyncLatency            &＃61; &＃39;0&＃39;

LogArchiveTrace                 &＃61; &＃39;0&＃39;

LogArchiveFormat                &＃61; &＃39;&＃39;

DbFileNameConvert               &＃61; &＃39;&＃39;

LogFileNameConvert              &＃61; &＃39;&＃39;

ArchiveLocation                 &＃61; &＃39;&＃39;

AlternateLocation               &＃61; &＃39;&＃39;

StandbyArchiveLocation          &＃61; &＃39;&＃39;

StandbyAlternateLocation        &＃61; &＃39;&＃39;

InconsistentProperties          &＃61; &＃39;(monitor)&＃39;

InconsistentLogXptProps         &＃61; &＃39;(monitor)&＃39;

LogXptStatus                    &＃61; &＃39;(monitor)&＃39;

SendQEntries                    &＃61; &＃39;(monitor)&＃39;

RecvQEntries                    &＃61; &＃39;(monitor)&＃39;

HostName(*)

StaticConnectIdentifier(*)

TopWaitEvents(*)

SidName(*)

(*) - Please check specific instance for the property value

Log file locations(*):

(*) - Check specific instance for log file locations.

Database Status:

SUCCESS

7) 重启备库集群&＃xff0c;查看数据库正常传输应用&＃xff0c;至此问题解决&＃xff01;



推荐阅读
  • uri

    IC卡操作功能实现

    本文介绍了如何通过C#语言调用动态链接库（DLL）中的函数来实现IC卡的基本操作，包括初始化设备、设置密码模式、获取设备状态等，并详细展示了将TextBox中的数据写入IC卡的具体实现方法。 ... [详细]
  • go

    设置Shadowsocks公共代理的关键步骤

    本文详细介绍了如何正确设置Shadowsocks公共代理，包括调整超时设置、检查系统限制、防止滥用及遵守DMCA法规等关键步骤。 ... [详细]
  • go

    Qt中信号与槽机制对比传统回调函数的优势

    在Qt框架中，信号与槽机制是一种独特的组件间通信方式。本文探讨了这一机制相较于传统的C风格回调函数所具有的优势，并分析了其潜在的不足之处。 ... [详细]
  • go

    UE4 中的距离场技术详解

    本文将深入探讨 Unreal Engine 4 (UE4) 中的距离场技术，包括其原理、实现细节以及在渲染中的应用。距离场技术在现代游戏引擎中用于提高光照和阴影的效果，尤其是在处理复杂几何形状时。文章将结合具体代码示例，帮助读者更好地理解和应用这一技术。 ... [详细]
  • uri

    2019-2020学年 20174325 叶竞蔚 《网络对抗技术》实验六：Metasploit基础应用

    2019-2020学年 20174325 叶竞蔚 《网络对抗技术》实验六：Metasploit基础应用
    本实验旨在掌握Metasploit框架的基本应用方法，重点学习三种常见的攻击方式及其实施思路。实验内容包括一次主动攻击（如MS08-067）、一次针对浏览器的攻击（如MS11-050）以及一次针对客户端的攻击（如Adobe漏洞利用）。此外，还包括成功应用一个辅助模块。 ... [详细]
  • go

    教你从写一个迷你koarouter到阅读koarouter源码

    本打算教一步步实现koa-router，因为要解释的太多了，所以先简化成mini版本，从实现部分功能到阅读源码，希望能让你好理解一些。希望你之前有读过koa源码，没有的话，给你链接 ... [详细]
  • main

    Frequent Mismatch During Terraform Apply

    Encountering frequent mismatches during Terraform apply operations, particularly with resource attributes. ... [详细]
  • uri

    App Store 加速审核通道

    申请地址：https://developer.apple.com/appstore/contact/?topic=expedite 常见申请理由：1. 我们即将发布新产品，这是一个媒体活动，我们无法承担任何风险，因此在多个方面努力提升应用质量。 ... [详细]
  • go

    设计无SQL死锁的编码模式 - Achieving SQL Deadlock-Free Design

    在运行于MS SQL Server 2005的.NET 2.0 Web应用中，我偶尔会遇到令人头疼的SQL死锁问题。过去，我们主要通过调整查询来解决这些问题，但这既耗时又不可靠。我希望能找到一种确定性的查询模式，确保从设计上彻底避免SQL死锁。 ... [详细]
  • main

    MySQL 源代码解析：二进制日志崩溃恢复机制深入探讨

    本文详细解析了 MySQL 5.7.20 版本中二进制日志（binlog）崩溃恢复机制的工作流程。假设使用 InnoDB 存储引擎，并且启用了 `sync_binlog=1` 配置，文章深入探讨了在系统崩溃后如何通过 binlog 进行数据恢复，确保数据的一致性和完整性。 ... [详细]
  • main

    Oracle数据库中的分页查询实现

    本文详细介绍了如何在Oracle数据库中使用SQL进行分页查询，通过嵌套查询和ROWNUM函数的应用，实现数据的高效分页展示。 ... [详细]
  • window

    C# 中创建和执行存储过程的方法

    C# 中创建和执行存储过程的方法
    本文详细介绍了如何使用 C# 创建和调用 SQL Server 存储过程，包括连接数据库、定义命令类型、设置参数等步骤。 ... [详细]
  • default

    U3d 属性面板自定义扩展（多态数组）

    原文地址：https:blog.csdn.netqq_35361471articledetails84715491原文地址：https:blog.cs ... [详细]
  • jsp

    Qt框架下的Fiddler网络数据包捕获与分析技术

    在最近的项目中，我们广泛使用了Qt框架的网络库，过程中遇到了一些挑战和问题。本文旨在记录这些经验和解决方案，以便日后参考。鉴于我们的客户端GUI完全基于Qt开发，我们期望利用其强大的网络功能进行Fiddler网络数据包的捕获与分析，以提升开发效率和应用性能。 ... [详细]
  • 数组

    揭秘腾讯云CynosDB计算层设计优化背后的不为人知的故事与技术细节

    揭秘腾讯云CynosDB计算层设计优化背后的不为人知的故事与技术细节
    揭秘腾讯云CynosDB计算层设计优化背后的不为人知的故事与技术细节 ... [详细]
author-avatar
阳光-沙滩男人
这个家伙很懒，什么也没留下！
Tags | 热门标签
RankList | 热门文章
PHP1.CN | 中国最专业的PHP中文社区 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved | 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有