Start a database with a missing data file

Last update on July 1, 2009 07:56 AM by jak58
Published by jak58

Start a database with a missing data file






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.
Best answers for « Start a database with a missing data file » in :
HAL.DLL CORRUPT OR MISSING Show HAL.DLL CORRUPT OR MISSING Solution When logging to windows, below error message appears on your screen: HAL.DLL missing or corrupted Windows could not start because the following file is missing or corrupt:...
NTOSKRNL.EXE is missing or corrupt Show
Missing or corrupt files Show
Corrupted or missing files ShowCorrupted or mising files System file checker Sometimes while installing a software or due to a problem on the hard disk , a part of the system file can be damaged. The system or the particular software can refuse to start. System...
Uploading Large Files ShowUploading Large Files You have surely encountered various difficulties for sending files through e-mail due file limitation. You have found the elucidation to your trouble. There are several means to transfer files and data from one...
SKU011.CAB missing ShowSKU011.CAB missing Issue When opening MS Word or MS Excel, you are prompted by the following error message: SKU011.CAB missing No installation Cd available. Solution To solve this problem: Regedit (start menu -> run -> type...
Introduction - Databases ShowWhat is a database? A database (abbreviated DB) is an entity in which data can be stored in a structured manner, with as little redundancy as possible. Different programs and different users must be able to use this data. Therefore, the concept of...
Hardware Interrupts (IRQ) and Conflicts ShowThe Concept of Interrupts Because the processor cannot simultaneously process several pieces of information (it processes one piece of information at a time), a program being run can, thanks to an interrupt request, be momentarily suspended while...
They need your help