测试环境：

数据库版本： 19.3.0.0.0 no-cdb

session1- 构造数据

create user test123 identified by oracle;

grant dba to test123;

SQL> conn test123/oracle

Connected.

SQL> create table t as select * from dba_objects;

Table created.

SQL> insert into t select * from t;

75040 rows created.

SQL> /

150080 rows created.

SQL> /

300160 rows created.

SQL> /

600320 rows created.

SQL> /

1200640 rows created.

session2- 破坏环境

[ora11g@primary ~]$ cd /ora11g/app/ora11g/

[ora11g@primary ora11g]$ ps -ef|grep pmon

ora11g     2177      1  0 10:45 ?        00:00:00 ora_pmon_ora11g

ora11g     4545   2776  0 11:21 pts/1    00:00:00 grep --color=auto pmon

[ora11g@primary ora11g]$ kill -9 2177

[ora11g@primary ora11g]$ ls -rtl redo0*

-rw-r----- 1 ora11g oinstall 52429312 Feb  8 10:48 redo01.log

-rw-r----- 1 ora11g oinstall 52429312 Feb  8 10:48 redo02.log

-rw-r----- 1 ora11g oinstall 52429312 Feb  8 11:21 redo03.log

[ora11g@primary ora11g]$ 

[ora11g@primary ora11g]$ rm -rf redo0*

[ora11g@primary ora11g]$ ls -rtl redo0*

ls: cannot access redo0*: No such file or directory

session3- 复现问题

SQL> startup

ORACLE instance started.

Total System Global Area 1946154480 bytes

Fixed Size                  8898032 bytes

Variable Size            1543503872 bytes

Database Buffers          385875968 bytes

Redo Buffers                7876608 bytes

Database mounted.

ORA-00313: open failed for members of log group 3 of thread 1

ORA-00312: online log 3 thread 1: '/ora11g/app/ora11g/redo03.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 7

SQL> recover database until cancel;

ORA-00279: change 2437332 generated at 02/08/2022 10:48:38 needed for thread 1

ORA-00289: suggestion :

/ora11g/soft/ORA11G/archivelog/2022_02_08/o1_mf_1_9_%u_.arc

ORA-00280: change 2437332 for thread 1 is in sequence #9

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/ora11g/app/ora11g/system01.dbf'

ORA-01112: media recovery not started

SQL> alter database open resetlogs;       

alter database open resetlogs

*

ERROR at line 1:

ORA-00603: ORACLE server session terminated by fatal error

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [],

[], [], [], [], [], [], []

Process ID: 4771

Session ID: 3121 Serial number: 2817