DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding;
        b=NbwgFLQ6pAM0t7ZrSyMyMzZPuPzUxZ7wS9SGJEetMpAgGRpgGzMI0O+2P9gsrA4lHXWT1kimTTmJC6yRYsqIsBgVwTFaXAoSVqK9uVGvXPlNJSZaEa/eXp/JBOF5GWNbRz8+QKD6msJ+w9twznTZ0LidD/Uj5WnXlSUL9aVuMdk=
Message-ID: <473EE6D7.4040503@gmail.com>
Date: Sat, 17 Nov 2007 08:04:23 -0500
From: fmhabash <fmhabash@gmail.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
To: Finn Jorgensen <finn.oracledba@gmail.com>
CC: oracle-l <oracle-l@freelists.org>
Subject: Re: DR Exercise: Restoring a rac/hacmp oracle home to a non-rac non-clustered
 host.
References: <473E20D0.5020502@gmail.com> <74f79c6b0711161841h15c13b1bs94a866c315a3026d@mail.gmail.com>
In-Reply-To: <74f79c6b0711161841h15c13b1bs94a866c315a3026d@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: fmhabash@gmail.com

Yes. When you install oracle on a hacmp'd aix node, the OUI will detect 
it and install/link the kernen with the RAC option. In my situation, I 
do have HCAMP running now and the db is s 2 instance cluster. Now, the 
catch is for any db running on this node (even if not RAC), you must 
have hacmp running to start any database. If not, you will have the 
infamous error

ORACLE instance started. 
Total System Global Area 2520746368 bytes 
Fixed Size                   743808 bytes 
Variable Size            2483027968 bytes 
Database Buffers           33554432 bytes 
Redo Buffers                3420160 bytes 
ORA-32700: error occurred in DIAG Group Service 

For DR, if I restore the same $ORACLE_HOME I have now, db will not start since we are not planning to have HACMP restored and running. Therefore, 
My only option is to use a non-rac linked home. The question is what is the best way to do this. These are my options ...

- restore the $ORACLE_HOME on the DR node and relink with the rac_off option.
- find an existing non-rac home and use it to clone to the DR node.
- prepare a silent install script to install a brand new $ORACLE_HOME without rac option.

I would like to exercise the first option. But, so far I did not see that it worked for those who tried it from my research.

Any ideas will be welcomed. 

Thank you


--
http://www.freelists.org/webpage/oracle-l