Re: IDEA - put redo logs onto a non-volatile RAM DISK?

From: Hagen Malessa <malessa_at_webit.de>
Date: Mon, 28 May 2001 15:00:32 +0200
Message-ID: <9etic0$2u2c$1@news.space.net>

"Mark Tompkins" <mdtompkins_at_home.com> schrieb im Newsbeitrag news:3B0D3FFE.C252ED93_at_home.com...
> Hi,
>
> Has anyone ever tried this? If so, why is it a bad idea?
>
> thx
>
> Mark
>

How about this :-)

Assume, RAM size is not a problem and you place your hole database (all datafiles) and redo logs to RAM disk. You only allow ARCH process to write archive files to disk storage. On disk storage you have a recent backup of all datafiles. So if the server has trouble you recover the database from storage to RAM using a script in init. If you use a HSM I would call it a HSM+ :)
Okay, I know that it is not usefull for all kinds of database, but in some cases...

Hagen Received on Mon May 28 2001 - 08:00:32 CDT