Re: 2 databases but 1 oracle home

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 10 Apr 2004 01:45:19 GMT
Message-ID: <PkIdc.20466$XI6.10312@newssvr27.news.prodigy.com>

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.

--Mark Bole Received on Fri Apr 09 2004 - 20:45:19 CDT