Re: Database Files - HELP! HELP! HELP!

Diego,

If you are running your database in ARCHIVELOG mode, and if the datafile was created while the database was running in archivelog mode, and if all the log files since the datafile was created to the present are available, and if your controlfile is current, then you can recover the datafile without a backup. In order to do this, you will have to use the CREATE DATAFILE clause of the ALTER DATABASE command: e.g. ALTER DATABASE CREATE DATAFILE 'oldfilename' AS 'newfilename'. This will create an empty file the same size as the missing file. Following this, you must perform media recovery on the empty file. During media recovery of the empty file, all archived and online redo logs must be available to be applied to the file so that it can be brought back to a transaction consistent state.

Otherwise, if the datafile is part of a nonSYSTEM tablespace, you can drop and recreate the tablespace. Of course, any data objects in the dropped tablespace will necessarily have to be recreated as a result of this (or imported from a recent export).

If you are running your database in NOARCHIVELOG mode, and the datafile belongs to the SYSTEM tablespace, you will have to recreate your database and recreate your application data objects.

hope this helps.

Best regards,
Chuck

Manager, Database Administration
Pointe Technology Group
cwolfe_at_ix.netcom.com

Diego Pafumi wrote:

> I have a terrible problem. Someone here delete one of the dbf, so I
> can's startup the database. I'm using oracle 7.3 under SUN
> What I need to know is if I have to re-install the application (a lot of
> time !!!!!) or if I have another posibility. I don't have the .dbf in
> the backup (great mistake !!!)
> Please help me as soon as you can !!!!
> Thanks a lot !!!
>
> Diego
Received on Fri Nov 13 1998 - 16:47:04 CST