title: Oracle tablespace/data file issue - ORA-00376
body: <p>Many months ago while shrinking table spaces I mistakenly deleted a table space with out taking backup. There were many indexes which belonged to tables which are a part of that table space.</p>
  
  <p>I never had any problems while inserting or deleting records from tables which belonged to that specific tablespace. But from yesterday I observed that data isn't inserting into many tables due to indexes on it which are giving me error that unique index violated which belong to that specific table space. </p>
  
  <p>Since this morning, I am receiving this error which is caused by a file which was deleted by me:</p>
  
  <pre><code>ORA-00376: file 663 cannot be read at this time
  ORA-01110: data file 663: '/oradata/db3/pm/pm4h_db_dat_w_150316_02.dbf'"
  </code></pre>
  
  <p>How can I overcome this error? </p>
  
  <p>I also now tried to recover the file which gives me this error:</p>
  
  <pre><code>SQL&gt; recover datafile '/oradata/db3/pm/pm4h_db_dat_w_150316_00.dbf';
  ORA-00283: recovery session canceled due to errors
  ORA-01122: database file 661 failed verification check
  ORA-01110: data file 661: '/oradata/db3/pm/pm4h_db_dat_w_150316_00.dbf'
  ORA-01207: file is more recent than control file - old control file"
  </code></pre>