Delete redo all logs, database cannot start

In the middle of the night on the itpub saw someone posting, said accidentally deleted all the log redo, resulting in the database can not start, so simulated. As follows:

Os:oracle Linux Server Release 5.7

Db:oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production


[[email protected] yoon]$ ls
Control01.ctl redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf Yoo N01.dbf

[Email protected] yoon]$ RM-RF redo01.log redo02.log redo03.log
[[email protected] yoon]$ ls
Control01.ctl sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf yoon01.dbf

sql> shutdown Immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Sql>

Sql> Startup
ORACLE instance started.

Total System Global area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 956304728 bytes
Database buffers 687865856 bytes
Redo buffers 7118848 bytes
Database mounted.
Ora-03113:end-of-file on communication channel
Process id:3775
Session id:1 Serial Number:5

Sql>



sql> shutdown abort;
ORACLE instance shut down.

Sql> Startup Mount
ORACLE instance started.

Total System Global area 1653518336 bytes
Fixed Size 2228904 bytes
Variable Size 956304728 bytes
Database buffers 687865856 bytes
Redo buffers 7118848 bytes
Database mounted.
Sql>

Sql> Select member from V$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/oracle/oradata/yoon/redo03.log
/u01/oracle/oradata/yoon/redo02.log
/u01/oracle/oradata/yoon/redo01.log

Sql>

Sql> ALTER DATABASE Clear unarchived logfile Group 1;

Database altered.

Sql> ALTER DATABASE Clear unarchived logfile Group 2;

Database altered.

Sql> ALTER DATABASE Clear unarchived logfile Group 3;

Database altered.

sql> ALTER DATABASE open;

Database altered.

Sql>

Sql> select status from V$instance;

STATUS
------------------------------------
OPEN

Sql>

Delete redo all logs, database cannot start