Restore database from backup without control files

Restore database from backup without control files

1. sqlplus /nolog

2. CONNECT / AS SYSDBA

3. STARTUP NOMOUNT

4.    CREATE CONTROLFILE DATABASE orcl NORESETLOGS NOARCHIVE
   MAXLOGFILES 32
   LOGFILE GROUP 1 '/oradata1/orcl/redo01.log' SIZE 500M
         GROUP 2 '/oradata1/orcl/redo02.log' SIZE 500M
   DATAFILE
    '/oradata1/orcl/system01.dbf',
    '/oradata1/orcl/undotbs01.dbf'
   CHARACTER SET us7ascii;
   

5. ALTER DATABASE MOUNT;

6. RECOVER DATABASE USING BACKUP CONTROLFILE;

7. ALTER DATABASE OPEN;

More About:
Oracle 障害回復 制御ファイル バックアップファイルからの回復
Recover database without control files and redo log files

Oracle database Backup and Recovery FAQ