【Oracle故障】DG新增数据文件,导致数据库宕机
Oracle11.2.0.4 DG的环境
Thu Nov 04 09:53:25 2021
alter database datafile '/u01/oradata/zedb/data_medexep01.dbf' resize 20G
Thu Nov 04 09:53:51 2021
System state dump requested by (instance=1, osid=13264 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/zedb/zedb/trace/zedb_diag_13274_20211104095351.trc
Thu Nov 04 09:53:52 2021
PMON (ospid: 13264): terminating the instance due to error 471
Dumping diagnostic data in directory=[cdmp_20211104095351], requested by (instance=1, osid=13264 (PMON)), summary=[abnormal instance termination].
Termination issued to instance processes. Waiting for the processes to exit
Instance terminated by PMON, pid = 13264
ORACLE Instance zedb - Cannot allocate log, archival required
Thread 1 cannot allocate new log, sequence 3508
All online logs need archiving
Examine archive trace files for archiving errors
Current log# 2 seq# 3507 mem# 0: /u01/oradata/zedb/redo02a.log
Current log# 2 seq# 3507 mem# 1: /u01/oradata/zedb/redo02.log
Thu Nov 04 09:56:33 2021
online redolog配置
SQL> select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024 M,status from v$log;
GROUP# THREAD# SEQUENCE# M STATUS
---------- ---------- ---------- ---------- ------------------------------------------------
1 1 3508 200 CURRENT
2 1 3507 200 INACTIVE
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVE
---------- --------------------- --------------------- ------------------------------------------------------------ ---------
1 ONLINE /u01/oradata/zedb/redo01a.log NO
1 ONLINE /u01/oradata/zedb/redo01b.log NO
2 ONLINE /u01/oradata/zedb/redo02a.log NO
2 ONLINE /u01/oradata/zedb/redo02.log NO
3 STANDBY /u01/oradata/zedb/std_redo03a.log NO
3 STANDBY /u01/oradata/zedb/std_redo03b.log NO
4 STANDBY /u01/oradata/zedb/std_redo04a.log NO
4 STANDBY /u01/oradata/zedb/std_redo04b.log NO
5 STANDBY /u01/oradata/zedb/std_redo05a.log NO
5 STANDBY /u01/oradata/zedb/std_redo05b.log NO
10 rows selected.
分别将online redolog 和standby redolog 增大到500M ,并新增日志组
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· SQL Server 2025 AI相关能力初探
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南