title: How to restore Oracle 10G database from backup
body: <p>I have an Oracle 10G database.
  I ran following script to take the backup of the database.</p>
  
  <pre><code>alter tablespace EMP2010 begin backup;
  host copy G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EMP2010.DBF G:\orabackup\database\
  alter tablespace EMP2010 end backup;
  
  alter tablespace PAYROLL2010 begin backup;
  host copy G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\PAYROLL2010.DBF G:\orabackup\database\
  alter tablespace PAYROLL2010 end backup;
  
  host copy G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO2010_1.LOG G:\orabackup\database\
  host copy G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO2010_2.LOG G:\orabackup\database\
  host copy G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO2010_2.LOG G:\orabackup\database\
  
  alter system switch logfile;
  host sleep 60
  host copy G:/oracle/product/10.2.0/oradata/orcl/arch* G:\orabackup\database\/
  alter database backup controlfile to 'G:\orabackup\database\/controlbackup.bac';
  </code></pre>
  
  <p>The backup generated .dbf, .log and .bac files.
  Now I want to restore the database from the above taken backup files.
  I do not want to use RMAN.</p>
  
  <p>I have come to know that using following command I can restore the .dbf files into tablespace:</p>
  
  <pre><code>imp transport_tablespace=Y tablespace=(Ts Name) 
      file='location of dump file C:\user.dmp'
      datafiles=('location of dbf file')
  </code></pre>
  
  <p>In above imp command, I do not understand which file to supply against "location of .dmp file" as my backup has not generated any .dmp file.</p>
  
  <p>Can anyone please help?</p>