`
itspace
  • 浏览: 978632 次
  • 性别: Icon_minigender_1
  • 来自: 杭州
社区版块
存档分类
最新评论

记一次存储扩容数据库启动恢复

OracleAIXIBMthread 
阅读更多
客户电话告之，数据库存储要扩容，扩容之后需要将部分数据文件迁移到新存储上，迁移之前顺便把数据库巡检做了。先简单介绍一下客户数据库环境。AIX版本为5304，A、B数据库HA互备，由于B主机有部分存储多余，考虑到最近A数据库磁盘较为繁忙，使用经常达到100%，于是建议将B主机多余存储划分至A主机作为pdisk1，然后将pdisk1加入到A主机datavg中，在datavg上pdisk1上建立文件系统/oradata2，等以上步骤就绪之后，晚上抽空做一下数据迁移。了解客户的需求之后，心想小事一桩。悠哉悠哉从杭州坐大巴去宁波，中途还买了本书，打发时间。谁料一到客户现场，告之，A数据库启动不了。心里咯噔一下，这下又有活干了。
观察alert日志显示，由于存储不可读写，分别由ckpt和pmon尝试将数据库实例宕掉。最终由pmon进程将实例宕掉。
引用
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_ckpt_331808.trc:
ORA-00202: controlfile: '/zzrkdata/zzrk/control01.ctl'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 1
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_lgwr_958654.trc:
ORA-00345: redo log write error block 181236 count 4
ORA-00312: online log 4 thread 1: '/zzrkdata/zzrk/redo04.log'
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: -1
Additional information: 2048
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_arc1_581840.trc:
ORA-00202: controlfile: '/zzrkdata/zzrk/control01.ctl'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 1
Thu Mar 25 13:12:45 2010
KCF: write/open error block=0x42372 online=1
     file=13 /zzrkdata/zzrk/ZZRK2004_IDX_02.dbf
     error=27063 txt: 'IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: -1
Additional information: 16384'
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_ckpt_331808.trc:
ORA-00204: error in reading (block 1, # blocks 1) of controlfile
ORA-00202: controlfile: '/zzrkdata/zzrk/control01.ctl'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 1
Thu Mar 25 13:12:45 2010
CKPT: terminating instance due to error 204
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_991450.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4169856.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_lgwr_958654.trc:
ORA-00340: IO error processing online log 4 of thread 1
ORA-00345: redo log write error block 181236 count 4
ORA-00312: online log 4 thread 1: '/zzrkdata/zzrk/redo04.log'
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: -1
Additional information: 2048
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_dbw0_466966.trc:
ORA-00600: internal error code, arguments: [ksfdgfnm1], [0x7000000FE571118], [], [], [], [], [], []
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_2683076.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_arc1_581840.trc:
ORA-00204: error in reading (block 1, # blocks 1) of controlfile
ORA-00202: controlfile: '/zzrkdata/zzrk/control01.ctl'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 1
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_arc1_581840.trc:
ORA-00204: error in reading (block 1, # blocks 1) of controlfile
ORA-00202: controlfile: '/zzrkdata/zzrk/control01.ctl'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 1
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3711100.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_2912488.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:45 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4268134.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:46 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3768444.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:46 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3645480.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:46 2010
System state dump is made for local instance
Thu Mar 25 13:12:46 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3338340.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-01115: IO error reading block from file 18 (block # 323615)
ORA-01110: data file 18: '/zzrkdata/zzrk/ZZRK2004_IDX_03.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 323614
Thu Mar 25 13:12:46 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3264658.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:46 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_lmd0_458862.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:46 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_2945276.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:47 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_lmon_487452.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:47 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3940452.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:47 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4464878.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:47 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4169856.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:47 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_pmon_929890.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:48 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3711100.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:48 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3768444.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:48 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3686494.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:48 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4661270.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:49 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4563142.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:49 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3465310.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:50 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_2900032.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:50 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3678250.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:51 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3088542.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:51 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3817474.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:52 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3432540.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:53 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4317288.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-01115: IO error reading block from file 28 (block # 89898)
ORA-01110: data file 28: '/zzrkdata/zzrk/ZZRK2004_QTXX_05.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 89897
Thu Mar 25 13:12:53 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3997780.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:53 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3334256.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-01115: IO error reading block from file 14 (block # 159530)
ORA-01110: data file 14: '/zzrkdata/zzrk/ZZRK2004_QTXX_02.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 159529
Thu Mar 25 13:12:54 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3903662.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:54 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3817474.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:54 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4059174.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:55 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3797076.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:55 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4526242.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:56 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_2687186.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:56 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4493398.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:57 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4178066.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:57 2010
Trace dumping is performing id=[cdmp_20100325131246]
Thu Mar 25 13:12:57 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3629252.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:59 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4579364.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:12:59 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3252266.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:00 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_2969624.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:00 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3084314.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:00 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3629252.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:02 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3592410.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:02 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3170412.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:02 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3575816.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:02 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3084314.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:03 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4292672.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:04 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3985602.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:04 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3723476.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:04 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3592410.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:04 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_999510.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:05 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_2936836.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:06 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4251652.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:06 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4632702.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:06 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_999510.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:06 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_3723476.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
Thu Mar 25 13:13:07 2010
Errors in file /oracle/app/admin/zzrk/bdump/zzrk_dbw0_466966.trc:
ORA-00600: internal error code, arguments: [ksfdgfnm1], [0x7000000FE571118], [], [], [], [], [], []
Thu Mar 25 13:13:09 2010
Errors in file /oracle/app/admin/zzrk/udump/zzrk_ora_4632702.trc:
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
ORA-00204: error in reading (block , # blocks ) of controlfile
引用
Thu Mar 25 13:13:57 2010
PMON: terminating instance due to error 204
Instance terminated by PMON, pid = 929890

尝试将数据库mount，alert日志报错：
引用
Thu Mar 25 14:04:34 2010
ORA-00204: error in reading (block 1, # blocks 1) of controlfile
ORA-00202: controlfile: '/zzrkdata/zzrk/control01.ctl'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
Additional information: 1


可是奇观的是控制文件和数据文件可以在操作系统中看到
引用
$ ls -l control02.ctl
-rw-rw-rw- 1 ora10g oinstall 41172992 Mar 25 14:05 control02.ctl

进一步用od -x命令查看controlfile,只能查看到部分信息，至此可以确定由于存储问题导致数据库无法识别控制文件，数据文件。
引用
$ od -x control02.ctl
0000000

经确定是由于存储链路挂接错误，导致存储出现问题。
0
顶
0
踩
分享到：
| Oracle hang 之sqlplus -prelim使用方法
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    db2裸设备扩容表空间

    在DB2数据库管理系统中，裸设备是一种特殊的数据存储方式，它绕过了操作系统文件系统，直接将数据存储在磁盘的物理块上，以提高I/O性能。本篇文章将详细介绍如何在AIX操作系统上对DB2的裸设备进行扩容，以及涉及的表...

    oracle11g节点扩容或删除

    #### 核心知识点：Oracle11g数据库节点的扩容与删除流程 **一、环境搭建与预备工作** 在进行Oracle11g数据库节点的扩容或删除之前，确保环境搭建正确是至关重要的。这包括操作系统的选择、软件版本的确认以及必要...

    MYCAT数据扩容+数据迁移

    - **数据分布**: MYCAT的扩容指的是改变节点的数据分布而非简单的增加存储容量。 - **路由规则一致性**: 确保拆分表迁移数据前后的路由规则保持一致。 - **分片字段一致性**: 分片字段在迁移前后也应保持一致。 - **...

    DS3400扩容实施方案

    这一步骤是为了避免在扩容过程中对正在运行的应用程序或数据库造成影响。 **关闭步骤**： 1. **停止应用程序**：确保所有运行在服务器上的应用程序和服务都已停止。 2. **备份数据**：如上所述，确保所有重要数据...

    Oracle环境下的数据库备份与恢复策略.pdf

    恢复策略通常涉及多个步骤，包括识别恢复目标、选择合适的恢复点、还原数据文件和重做日志、启动数据库至特定状态等。RMAN提供了强大的恢复功能，包括完整数据库恢复、部分数据库恢复和表空间恢复等。 总的来说，...

    ORACLE体系结构-数据库篇.pptx

    在这篇文章中，我们将探讨ORACLE数据库体系结构的数据库篇，涵盖了数据库健康检查、控制文件管理、在线日志文件管理、数据文件管理、磁盘扩容等多个主题。下面是我们将要讨论的知识点。 数据库健康检查 在项目经理...

    跨数据中心的数据库双活及灾备建设经验分享

    通过横向扩展技术，民生银行可以根据业务需求灵活调整资源分配，实现动态扩容。具体来说，可以通过增加更多的成员服务器(member)来分散负载，保证系统的高可用性和高性能。 综上所述，民生银行通过实施数据库双活...

    数据库运维管理规范 数据库运维(02).docx

    - **磁盘空间**: 监控磁盘空间使用情况，及时释放空间或申请扩容。 - **日志审查**: 查看告警文件和其他日志文件，发现异常及时处理。 - **性能监控**: 监控CPU、内存和I/O状态。 - **备份监控**: 检查备份日志...

    Oracle数据库常见维护问题手册-精典

    #### 数据库表空间扩容及迁移 **向表空间增加一个不自动扩展的数据文件** 可以使用以下命令来增加一个新的数据文件到现有表空间： ```sql ALTER TABLESPACE users ADD DATAFILE '/path/to/newdatafile.dbf' SIZE ...

    数据库服务和技术架构演进.pdf

    另一个痛点是数据库扩容问题，传统方式可能需要几小时甚至更长时间，而业务高峰往往无法等待。计算存储分离的新模式，如通过秒级扩容的Storage Nodes，使得数据库可以快速扩展，避免了业务高峰期的延迟。这种新模式...

    腾讯云原生自研数据库内核深度优化最佳实践.pdf

    - **TDSQL-C架构**：该架构设计解决了传统数据库架构的问题，如磁盘容量限制、扩容影响业务、分布式事务复杂性等。TDSQL-C采用云存储，提供理论上无限的存储容量，支持多副本保证可靠性，实现持续备份和归档功能。 ...

    T100 系统日常维护管理档

    综上所述，T100系统的日常维护涵盖了多个方面，包括但不限于系统启动与停止、常用指令的应用、查看系统记录、备份与恢复、用户管理和表空间扩容等。通过合理规划和实施这些维护措施，可以确保T100系统的稳定性和高效...

    DB2 日常维护指南，第 1 部分

    DB2是IBM公司开发的一种关系型数据库管理系统（RDBMS），它广泛应用于企业的数据存储与处理。DB2数据库的日常维护是确保数据库稳定运行、保障数据安全和提高性能的关键。《DB2日常维护指南，第1部分》主要针对数据库...

    HairOracle数据库运维手册.docx

    - **建立与扩充diskgroup**：创建新的diskgroup，并对其进行扩容。 - **mount与unmount的命令**：对diskgroup执行挂载和卸载操作。 - **删除diskgroup**：从ASM实例中移除diskgroup。 - **增加DISK的total_mb**...

    SAP系统增加表空间手册

    - 建议在非高峰时段执行表空间扩容操作，以减少对业务的影响。 3. **操作人员：** - 只有经过授权且具备相应技术能力的DBA（数据库管理员）才能执行此类操作。 #### 四、操作步骤 下面详细介绍具体的表空间增加...

    Oracle数据库日常维护手册.pdf

    - 初始化参数是Oracle数据库启动时设置的一组配置选项。 - 需要关注的参数包括但不限于`memory_max_target`、`sga_target`、`processes`等，这些参数对数据库性能有着直接影响。 ##### 4.2 检查数据库连接情况 - ...

    OceanBase数据库技术架构介绍.pptx

    OceanBase 架构（四）业务的挑战：如何在业务高峰平滑扩容，高峰后如何缩容，甚至对业务无感知；如何去 O，如何保证风险可控地去 O；如何解决多活和异地容灾；如何备份分布式数据库，如何恢复到一个全局一致的时间点...

    基于ssm英语学习交流平台微信小程序源码数据库文档.zip

    - 部署到服务器，如使用Docker容器化部署，实现快速扩容和故障恢复。 9. **版本控制**： - 使用Git进行版本控制，便于团队协作，记录代码变更历史。 这个项目综合运用了多种现代Web开发技术，对于学习和掌握Java...

Magicbox
Global site tag (gtag.js) - Google Analytics