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: domains

Re: domains

From: Bruno Abate <abate_at_netgate.comintur.com.uy>
Date: 1997/01/17
Message-ID: <01bc0434$6432e9c0$a63563ce@bruno>#1/1

Man, the init.ora is not the problem, you just do a "startup pfile=initPROD1.ora"
for one and "startup pfile=initPROD2.ora" for the other. initPROD1.ora and initPROD2.ora are copies differing only in the parameter control_files, which should address the corresponding (and hopefully different) control files of prod (original) and prod (copy). What I think will get you in trouble is an error you will almost surely get when trying to mount the second DB: ORA-<don´t remember>: A database with the same name already mounted. (or something like it, trusting my memory). I got around it by taking the copy to another machine (unimportant) with another installation of the Oracle software (very important), and because the databases exported to sqlnet by your listener.ora file are identified by oracle_sid (same for both) AND oracle_home (which is different in both), they coexist beautifully...
Another means would be issue an "alter database backup controlfile to trace", and get a script which you modify to try to change the database´s global name: create controlfile reuse set dbname anotherprod resetlogs... (only works specifying resetlogs), and as you are there renaming the files in the create controlfile to reflect the copies´ location. I tried it and the fool didn´t cope with my downsized datafiles, so I had to use the first means. Details of the foolish server behaviour when I come back from holidays (2 weeks), so if you would like to reply to me, use e-mail, since I´ll lose many newsgroup´s messages (no computers on vacations) :b

Bruno.

Wachs Rene <Rene.Wachs_at_ezv.admin.ch> wrote in article <32D4DB66.7B07_at_ezv.admin.ch>...

> Theoretically it's possible to define a DB_DOMAIN like this :
> application_name.hostname.organisation
> sales.unix_1.abc
> so it's also possible to have 2 DB's with the same name on the same
> server :
>
> DB_NAME = prod
>
> With the Domain one will be prod.sales.unix_1.abc
> the second will be prod.cust.unix_1.abc
>
> I know, this is a bad concept, but possible. In this case how to name
> the init.ora-File (both can't be called initPROD.ora) and how to startup
> both databases ?
  Received on Fri Jan 17 1997 - 00:00:00 CST

Original text of this message

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