Re: Database Won't Start

Thanks to Byron Pearce and Gary Assassin, I got my database up and running again. Here is what they had me do. I signed on as oracle user and did the following:

1. connect internal
2. alter database mount;
3. alter database datafile 'the_datafile_name' offline;
4. alter database open;

I then dropped the tablespace that was causing the problem. Fortunately this tablespace contained just archived data so can be recovered from a previous backup.
Thanks to all of you that responded to my cry for help. Be warned not to create any datafiles in the /tmp directory of a Sun Solaris system.

ShimSoft <shimsoft_at_wport.com> wrote in article <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?
>
Received on Mon Jul 28 1997 - 00:00:00 CEST