Re: HELP!!!!!!!!

When Oracle starts an instance, it checks the validity of all data files with respect to the control file. In your case, one of the data file is missing (deleted).

Steps to be followed

Restore the data file from the previous online backup.

If you are running the database on ARCHIVELOG mode, start the database in mount mode.

   startup mount

Take the data file offline by specifiying

  alter database datafile 'filename' offline

  alter database open

recover the datafile by applying the arcived files.

  recover datafile 'file_name'

Once the recovery is complete then issue the following command

  alter database datafile 'filename' online

The successful completion of above steps will restore the database.

If you are having all the archived files, Oracle will recover all the transactions of that data file

If you are not running the database in NOARCHIVE LOG mode, then take the backup of the current database and restore the previous backup and reenter all the transactions since the last backup.

It is always recommended to open a priority 1 TAR with Oracle World wide support for assistance in RECOVERY.

Hope the above procedures will help you

Regards

N.Prabhakar
Socgen Crosby Securities
Singapore Received on Sat Nov 09 1996 - 00:00:00 CET