Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: archiving an old 8.1.7 db + binaries on dvd - "instant server"?

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

From: Marquez, Chris <>
Date: Thu, 19 May 2005 15:26:14 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E0450BB86@ecogenemld50.Org.Collegeboard.local>

I think you are making this bigger deal than it is, but at the same time missing some serious pitfalls. "Not a big deal"
Just days ago I tared up my 9i Oracle Home that contained Software and Database /o01/app/... & /o01/oradata. I simply un-tar'd it to a like server and done!...I have may database and software again.

"serious pitfalls"
Before *simply* un-tar'ing my Oracle Home Clone, I spent an hour or more making sure that my *like* server had all the OS patches required for my version of Oracle. So this is not simple at all.
More and more Oracle is requiring OS patches and OS changes BEFORE Oracle will install or run on that OS. You have a 100% chance that a new clean OS install will be missing patches needed for your Mobile Oracle Clone. What about just one that applies to all...the list of othere prerequisites goes on.

Chris Marquez
Oracle DBA

-----Original Message-----
From: on behalf of Edgar Chupit Sent: Thu 5/19/2005 5:41 AM
Cc: oracle-l
Subject: Re: archiving an old 8.1.7 db + binaries on dvd - "instant server"?  

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 <> wrote:
> This falls under the general topic of information lifecycle management
> (buzz) with a win32 slant.
> 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?



Received on Thu May 19 2005 - 15:31:26 CDT

Original text of this message