Solution to Oracle Log File loss

What should I do if the Oracle log file is lost? The following describes how to deal with Oracle Log File loss.

Due to accidental operations, the third Oracle log file in the log group is lost.
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.

Find 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.

How to modify the oracle user name

How to query Oracle user session information

Measure the test taker's knowledge about the ORACLE user authentication mechanism.

Oracle tablespace statements

Default ORACLE user and password