Re: Database Won't Start
Date: 1997/07/30
Message-ID: <01bc9d24$805ea100$8182f1c3_at_worldonline>#1/1
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 !
Roelof Schierbeek, DBA
The Hague, Holland
email: bytelife_at_worldonline.nl http://www.worldonline.nl/~bytelife Received on Wed Jul 30 1997 - 00:00:00 CEST