Re: Help: Datafile toasted; how do you get Oracle running again?

From: Sybrand Bakker <Sybrand.Bakker_at_Bentley.nl>
Date: 1995/09/20
Message-ID: <43oee5$7ls_at_sun630.bentley.com>#1/1


Matt,

General solution, which will also help in a production database with important data:
Run the database in archivelog mode ALWAYS. Backup the offline archivelog files to a medium like tape.
Make backups of the database (cold, with database shutted down or hot, with database running) regularly.
When you run into trouble like this, simply restore the file from a backup. Open the database by means of sql*dba, and type 'recover datafile <filename>' (if it didn't already force you to do so). Restore your archivelogs and apply them to your database. This procedure is 99.9 percent failsafe and is described in great detail in the Oracle manuals. For port-specific info you should consult the recovery.doc in the rdbmsxx\admin directory.
In your specific case you might consider the reply of Paul Baumgartel, as you probably didn't run in archivelog mode.

Hope this helps

Sybrand Bakker
Senior IS Analyst
Bentley Systems Europe
Polaris Avenue 33
2132 JH Hoofddorp
The Netherlands

#include <std_dclaimer.h> Received on Wed Sep 20 1995 - 00:00:00 CEST

Original text of this message