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 ( 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.