Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temp01.dbf deleted. Is recovery possible?
I hate to reply to me, but the 3rd line should read "alter database open"
-- Syltrem OpenVMS 7.3-1 + Oracle 8.1.7.4 http://pages.infinit.net/syltrem (OpenVMS related web site, en français) ---zulu is not in my email address--- "Syltrem" <syltremzulu_at_videotron.ca> a écrit dans le message de news:8M%Db.7145$G1.33226_at_tor-nn1.netcom.ca...Received on Wed Dec 17 2003 - 10:56:50 CST
> startup mount
> alter database create datafile 'temp01.dbf' as 'temp01.dbf'
> alter database mount;
>
> I think that's what it is, from memory.
>
> Or else you can always do
> startup mount
> alter database datafile 'temp01.dbf' offline drop;
> alter database open
>
> and repair afterward (recreate a new temp)
>
>
> --
> Syltrem
>
> OpenVMS 7.3-1 + Oracle 8.1.7.4
> http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
> ---zulu is not in my email address---
> "gserdijn" <gserdijn_at_koper-it.nl> a écrit dans le message de
> news:d7e2b32f.0312170815.5feffc39_at_posting.google.com...
> > System: Windows 98
> > DB: Personal Oracle 8.1.6
> >
> > A customer deleted temp01.dbf. He has no backups available. Now the
> > database cannot start up.
> >
> > Is it possible to fix this problem?
> >
> > Please advise.
> >
> > Gerry
>
>