Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database Won't Start
ShimSoft <shimsoft_at_wport.com> schreef in artikel
<33DC2CDB.4B81_at_wport.com>...
> I lost two datafiles that were in the /tmp directory of a Sun Solaris
> 2.4 system. I did not know at the time that this directory is never
> backed up and is deleted whenever you do a reboot. I did a reboot and
> lost everything I had in that directory. I can't start the database
> because it keeps looking for the missing datafiles and shuts itself down
> when it can't find them. I tried doing a FORCE and RECOVER start but it
> had no effect. I don't have a backup with the missing datafiles. Is
> there a way to start up the database without those datafiles?
>
Hello "ShimSoft",
EasY:
SQLDBA>Startup mount
alter database drop datafile '/tmp/....'
alter database open
Good luck !