Knackeback wrote:
> During a large update the redolog-files filled up my oracle partition
> completely.
> The database came to a standstill.
> I rebooted my machine but was still not able to start the database.
> Now I did a big big mistake - I removed the redolog files to get
> temporary space (my idea was to shrink datafiles after the database
> would
> be online again).
> The database now complains exactly about the missing redolog files.
> Is there a way to make the database fit for work without recreate it ?
Yes. Look up carefully what "alter database open resetlogs" means,
when to use it, its implications, what you lose and then do it.
And put your redologs on a different disks. I know, it's always a fight with
the HW admin but one that should be fought.
Lots of Greetings!
Volker
--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
Applications"
Received on Thu Jul 17 2003 - 06:02:21 CDT
