LOST ALL Controlfile and Redolog Files

Database : 10gr1
OS : Windows
Archive log : ENABLE


Note: All controlfile and Redo log file LOST due to system crash without BACKUP.
Database Initially Closed when LOST ALL CONTROLFILES AND REDOLOG FILES.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes

SQL> CREATE CONTROLFILE REUSE DATABASE "ORA101" RESETLOGS ARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 271
7 LOGFILE
8 GROUP 1 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\REDO01.LOG' SIZE 10M,
9 GROUP 2 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\REDO02.LOG' SIZE 10M,
10 GROUP 3 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\REDO03.LOG' SIZE 10M
11 -- STANDBY LOGFILE
12 DATAFILE
13 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\SYSTEM01.DBF' size 440m,
14 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\UNDOTBS01.DBF' size 25m,
15 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\SYSAUX01.DBF' size 220m,
16 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\USERS01.DBF' size 5m,
17 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORA101\EXAMPLE01.DBF' size 150m
18 CHARACTER SET WE8MSWIN1252
19 /

Control file created.

SQL> alter database open resetlogs;

Database altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 0
Next log sequence to archive 1
Current log sequence 1

Note : you should use RESETLOGS in create controlfile statments.