oracle实例宕机，虚拟机磁盘精简配置模式，磁盘无法扩展

虚拟机查看磁盘空间均足够，但oracle数据库实例频繁宕机

alert告警:

Mon Sep 30 04:24:37 2024
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ckpt_3268.trc:
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL'
ORA-27072: File I/O error
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL'
ORA-27072: File I/O error
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ckpt_3268.trc:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL'
ORA-27072: File I/O error
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL'
ORA-27072: File I/O error
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 1453) 配额不足，无法完成请求的服务。
Mon Sep 30 04:24:37 2024
System state dump requested by (instance=1, osid=3268 (CKPT)), summary=[abnormal instance termination].
System State dumped to trace file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_diag_3244_20240930042437.trc
CKPT (ospid: 3268): terminating the instance due to error 221
Dumping diagnostic data in directory=[cdmp_20240930042437], requested by (instance=1, osid=3268 (CKPT)), summary=[abnormal instance termination].
Mon Sep 30 04:24:47 2024
Instance terminated by CKPT, pid = 3268

检查从alert日志里看军事文件无法写入导致实例终止，后检查虚拟机磁盘配置为精简模式，磁盘存放的共享存储空间使用率较高。精简模式配置的磁盘是使用多少扩展多少，物理空间快耗尽不能扩展导文件不能写入，最终实例宕机。

原文地址：https://blog.csdn.net/lmxx2020/article/details/142871652

免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！