Re: Convert 2-node RAC to single instance
From: Dan Norris <dannorris_at_dannorris.com>
Date: Wed, 04 Feb 2009 07:59:56 -0800
Message-ID: <4989BB7C.2080106_at_dannorris.com>
I'd probably follow this process to ensure there's an easy fall back:
1. Shutdown 2nd instance
2. set cluster_database=false
3. Run application for long enough period to declare the database performance acceptable on a single node (maybe a week, month, or quarter depending on your business rules to declare "success")
4. Drop extra thread of redo and extra undo tablespace
5. relink binaries to disable RAC
6. Possibly remove database and listener from Clusterware configuration (using srvctl)
7. Possibly consider using your second node for a failover cluster for this new single-instance database you have configured (see http://www.oracle.com/technology/products/database/clusterware/pdf/SI_DB_Failover_11g.pdf)
Good catch on the relink--I forgot about that step.
Dan
bao jiejie wrote:
Date: Wed, 04 Feb 2009 07:59:56 -0800
Message-ID: <4989BB7C.2080106_at_dannorris.com>
I'd probably follow this process to ensure there's an easy fall back:
1. Shutdown 2nd instance
2. set cluster_database=false
3. Run application for long enough period to declare the database performance acceptable on a single node (maybe a week, month, or quarter depending on your business rules to declare "success")
4. Drop extra thread of redo and extra undo tablespace
5. relink binaries to disable RAC
6. Possibly remove database and listener from Clusterware configuration (using srvctl)
7. Possibly consider using your second node for a failover cluster for this new single-instance database you have configured (see http://www.oracle.com/technology/products/database/clusterware/pdf/SI_DB_Failover_11g.pdf)
Good catch on the relink--I forgot about that step.
Dan
bao jiejie wrote:
Dan,-- http://www.freelists.org/webpage/oracle-l Received on Wed Feb 04 2009 - 09:59:56 CST
"There must be a fall back to the original RAC DB if performance suffers."
If we changed backup to single node, is that easy to handle this requirement?
Just change the cluster_database parameter and add undo and redo logs to the second node?
And ... Do we need relink oracle binary to off the rac option?
like make -f ins_rdbms.mk rac on/off ??
On Sun, Feb 1, 2009 at 6:02 PM, LS Cheng <exriscer_at_gmail.com> wrote:
No, that is a 10g feature so bad luck....
--
LSC
On Sat, Jan 31, 2009 at 10:37 PM, Tony Sequeira <tony_at_sequeira.org.uk> wrote:
Guillermo Alan Bort wrote:Is this available at the database level in 9iR2?
> Consider using RMAN's switch to copy capability to minimize downtime
> Alan Bort
> Oracle Certified Associate
>
--
S. Anthony Sequeira
++
I dote on his very absence.
-- William Shakespeare, "The Merchant of Venice"
++
--
("'-''-/").___..--''"'-._
'7_ 7 ) '_. ( ).'-.__.')
(_Y_.) ._ ) '._ '. ''-..-'
_.'--'_..-_/ /--'_.' ,'
(il),-'' (li),' ((!.-'
Best regards，
Yours sincerely House
baojiejie_at_gmail.com