Re: Is Same instance name possible on same server?

Yes Virginia, you can have two instances with the same name on the same Unix server. We use them to upgrade database versions. The old one remains intact until the users accept the new one. All we change is the listener parameters for the ORACLE_HOME. An that's the trick; the ORACLE_HOMEs have to be different. Although we use homes for different versions, I don't see a reason why you can't install the same rdbms version under two different homes.

You can restore the database to a different host and ultimately end up with it renamed to prod1 without using RMAN by combining a recovery with a rename. Perform an Alternate Host Restore/Recovery and then rename the database by recreating the control file. There are a few articles/tip sheets out there for renaming the database. The alternate host restore/recovery will be specific to your backup mechanism but in a nutshell; restore the hot backup to the alternate host then recover it to whatever point you want. You now have a working database to rename.

Thanks for the opportunity to exercise my mind. Tony Aponte

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 03, 2002 12:05 PM

> Hi
> Can I have same instance name on same unix server?If yes then how?
> Can I restore the database with diffrent name.Suppose I have backup of
prod
> instance on one server.can I create prod1 instance name on diffrent server
> by having same hotbackup data files,archived log files and control files.?
> Thx
> -Seema
>
>
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seema Singh
> INET: oracledbam_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Patty Aponte
  INET: apontep_at_tampabay.rr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).