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.
Published by jak58
Latest update on August 15, 2010 at 06:56 AM by jak58.