Start a database with a missing data file

December 2016




In order to start an Oracle database with a misssing data file:
  • First get connected to SQL*DBA or Server Manager and run "shutdown abort"
  • Run startup mount
  • Run the following command to replace the datafile (eg using... /oradata/temp_01.dbf):



Change database datafile: datafile `.../oradata/temp_01.dbf' offline drop;
  • alter database open;
  • drop tablespace TEMP including contents.

Related :

This document entitled « Start a database with a missing data file » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.