How to convert RAC database to single Instance Database

From: Q A I S E R <qrasheed_at_gmail.com>
Date: Mon, 30 Aug 2004 18:31:44 -0500
Message-ID: <4d4db22004083016315bdb1a00@mail.gmail.com>

• 9.2.0.5 64bit
• RAC
• Solaris 8
• VERITAS DBE?AC 3.5

Does anybody on the list has any experience converting a RAC database to a single instance Database in Cluster File System configuration?

I was able to find a Doc. on metalink with step by step instructions on "How to convert a single instance Database to RAC", but not the other way round. So, I raised a TAR for this. The analyst's response from Oracle is "We cannot convert a RAC database into a Single instance database, that is the reason why you didnt find any steps. It is not supported".

It does not makes any sense that you cannot convert from RAC to non-RAC environment, unless Oracle does not want their customers to go away from RAC !. I would think that you could set cluster_database=false, and bring up the database in single instance. Get rid of the extra threads and undo tablespaces. Has anybody on the list done something like that?  

Qaiser

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Aug 30 2004 - 18:27:19 CDT