Re: archiving an old 8.1.7 db + binaries on dvd - "instant server"?

  • From: Edgar Chupit <chupit@xxxxxxxxx>
  • To: bdbafh@xxxxxxxxx
  • Date: Thu, 19 May 2005 12:41:01 +0300

This is very interesting topic, because I think most of us would like
to create some db archives that could be available offline.

Some time ago I was experimenting with 9i on windows, by setting data
files attributes to read-only, and trying to open database in readonly
state (alter database open read only), but unfortunately Oracle was
still trying to open temp tablespaces files in read/write mode (this
sound very logical), so my experiments failed and I decided to wait a
bit and switch to another tasks, because besides temp tablespace there
is a plenty of files that Oracle will try to open in read/write mode:
different log files, control file, redo logs, etc.

From another point of view if this kind of configuration will work,
what about licensing issues? How do we license this DVD only instance?
As personal edition?

I think that you might consider keeping a copy of VMWare virtual
machine files on dvd's and open it from VMWare, but this will not
solve readonly issues and you will have to purchase VMWare for all the
PC's you intend to run this database.

I hope that you will share with list if you'll find anything
interesting about this topic.


On 5/19/05, Paul Drake <bdbafh@xxxxxxxxx> wrote:
> This falls under the general topic of information lifecycle management
> (buzz) with a win32 slant.
>=20
> Has anyone mucked with attempting to open an entire database (a small
> one) as read only from DVD with the oracle_home (8.1.7 in this case)
> also on the DVD?

--=20
  Edgar
--
//www.freelists.org/webpage/oracle-l

Other related posts: