Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Some plonker typed rm temp.dbf AAARRGGHHH!
If you have archive logging enabled, the easiest way would be to
restore the lost file from a backup, and then recover using the
archived redo logs.
David
welfers_at_my-dejanews.com wrote:
>A colleague decided to clear some space from a filesystem and deleted a dbf
>file. Not surprisingly oracle is bleating about it. How do I fix it?
>Fortunately the dbf was for temp tables and as far as I can make out nothing
>was using it anyway. I tried to drop the tablespace but oracle complained
>that it could not find the datafiles. I know how to create and drop
>tablespaces etc but I would have thought the first job would be to tell
>oracle that the temporary tablespace no longer exists before adding it again.
>Before you ask the answer is "no we don't have any backups or archive logs or
>exports." :(( Not my fault honest I did not know the machine existed until
>yesterday when I heard about the problem. It is my job to fix it so any help
>would be appreciated. Thanks in advance.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
David Greensmith :-)
(david_at_green1.demon.co.uk)
Received on Sun Jul 26 1998 - 10:17:17 CDT