【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 ，并新增日志组
