Start a database with a missing data file

August 2017




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


Published by jak58. Latest update on August 15, 2010 at 06:56 AM by jak58.
This document, titled "Start a database with a missing data file," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).