Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: 2 databases but 1 oracle home

Re: 2 databases but 1 oracle home

From: Howard J. Rogers <>
Date: Sat, 10 Apr 2004 15:26:27 +1000
Message-ID: <>

On Sat, 10 Apr 2004 01:45:19 GMT, Mark Bole <> wrote:

> Howard J. Rogers wrote:
>> On 8 Apr 2004 13:25:53 -0700, Joel Garry <> wrote:
>>> (yls177) wrote in message
>>> news:<>...
> [...]
>>> IMO, the biggest reason for multiple databases is severely different
>>> backup/restore requirements (which usually encompasses test or
>>> training databases). More recent versions of Oracle lessen the need
>>> for this.
>> Joel, for my benefit, can you elaborate on what aspects/features of
>> which Oracle versions mean the need for separate instances with wildly
>> different backup/recovery requirements is lessened?
>> I was trying to think of some, and couldn't come up with anything
>> plausible, except maybe block media recovery.
>> What did you have in mind?
>> Regards
>> HJR
> [Speaking for myself], the issue is not "Oracle versions", it's the
> ability to backup and restore, just as Joel stated ("test or
> training databases").
> Or, let me try to re-state the issues:
> * multiple ORACLE_HOME's on a given server (for different versions of
> Oracle binaries)
> * multiple databases on a given server (for any number of business
> reasons)
> The two issues are mostly independent -- and using OFA is one easy way
> to make it so. (Of course, each database needs to be at the same patch
> level as the ORACLE_HOME that instantiates it).
> Let's say I have one database in archivelog mode and another in
> noarchivelog mode, both on the same physical server. Clearly the backup
> strategy for each of these databases will be different (and yes, there
> are business reasons why each database has a different backup strategy).
> Or let's say I have two completely different applications, one of which
> is vendor-supplied and requires an obsolete version of Oracle, and the
> other of which is in-house and requires a more main-line version.
> The nice thing is, Oracle supports all these scenarios and others quite
> well.

Good reply, Mark... but I thought Joel had something rather more specific in mind.

Obviously, support for multiple homes is important, but that was there... when? Version 8.0??


Dizwell Informatics:
  -A mine of useful Oracle information-
          -Windows Laptop Rac-
    -Oracle Installations on Linux-
Received on Sat Apr 10 2004 - 00:26:27 CDT

Original text of this message