Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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 <hjr_at_dizwell.com>
Date: Sat, 10 Apr 2004 15:26:27 +1000
Message-ID: <opr576qdfh3d8uqx@news.optusnet.com.au>


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

> Howard J. Rogers wrote:
>
>> On 8 Apr 2004 13:25:53 -0700, Joel Garry <joel-garry_at_home.com> wrote:
>>
>>> yls177_at_hotmail.com (yls177) wrote in message
>>> news:<c06e4d68.0404080649.670cf0e8_at_posting.google.com>...
>>>
> [...]
>>> 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??

Regards
HJR

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -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

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US