The third log file in the log group is lost due to accidental operations.
SQL> Conn/As sysdba
Connected.
SQL> startup
The Oracle routine has been started.
Total system global area 85006980 bytes
Fixed size 453252 bytes
Variable Size 58720256 bytes
Database buffers 25165824 bytes
Redo buffers 667648 bytes
The database has been loaded.
ORA-00313: Unable to open a member of log group 3 (thread 1)
ORA-00312: Online log 3 thread 1: 'd:/Oracle/oradata/ora92/redo03.log'
The database cannot be started.
Search for the file: D:/Oracle/oradata/ora92/redo03.log, which does not exist.
The database is not opened at this time:
SQL> select table_name from dict where table_name like '% log % ';
Select table_name from dict where table_name like '% log %'
*
Error is located in row 1st:
ORA-01219: Database not open: Allow queries only in fixed tables/Views
In this case, you need to close the database first.
SQL> shutdown immediate
ORA-01109: the database is not open
The database has been detached.
The Oracle routine has been disabled.
SQL> startup Mount;
The Oracle routine has been started.
Total system global area 85006980 bytes
Fixed size 453252 bytes
Variable Size 58720256 bytes
Database buffers 25165824 bytes
Redo buffers 667648 bytes
The database has been loaded.
SQL> recover database until cancel
Media recovery is completed.
SQL> alter database open resetlogs;
The database has been changed.