Re: 2 databases but 1 oracle home

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>...
>> possible to have 2 databases but only 1 oracle_home (means only 1 set
>> of oracle binaries)? the datafiles, arch, control will be diferent of
>> course
>
> The other answers are correct as far as they go. The next step is to
> ask if you are running more than one instance. If so, you also have
> to adjust system settings to account for multiple instances. Details
> vary by platform and version, you should remember to post such
> information with your question.
>
> The other obvious question is why you want to do this. If you need to
> save the space of the binaries, you might have, um, "administration
> issues." If you need to run a test instance with exactly the same
> binaries, then it may be appropriate. If you need to test new things
> like Oracle upgrades, it is obviously inappropriate. If you are doing
> it because you have two applications, you may need to review the
> differences between the way Oracle defines a database and the way
> other software does. Some apps call a database what Oracle calls a
> schema.
>
> 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

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -A mine of useful Oracle information-
          -Windows Laptop Rac-
    -Oracle Installations on Linux-
===========================================