Home » Server Options » RAC & Failsafe » RAC to Single Instance (Oracle 11g(11.2.0.1.0) ,Linux)
RAC to Single Instance [message #480006] Wed, 20 October 2010 12:33 Go to next message
kvignes1
Messages: 33
Registered: September 2007
Member

2 Database.
TP1 Database - Oracle RAC 11g (2 Node)
TP2 database - Single Instance

Is it possible to migrate from RAC to Non-RAC(Single Instance)?

Our requirement is, 3 Oracle Schemas@TP1(having DW data) we need to move it to TP2 Database.

Is there a good way of doing it.

Let me know if you need any more information.
Re: RAC to Single Instance [message #480009 is a reply to message #480006] Wed, 20 October 2010 12:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Exact methods depend on Volume of data.
If small, you can just export and import.
I have used RMAN to duplicate a RAC instance to single instance.
Nothing special here.
The schemas had their own tablespaces and used the RMAN SKIP Tablespace option.
Re: RAC to Single Instance [message #480016 is a reply to message #480009] Wed, 20 October 2010 13:06 Go to previous messageGo to next message
kvignes1
Messages: 33
Registered: September 2007
Member

Schema- C - 78 GB
Schema- E - 117 GB
Schema- P - 47 GB

These are my schema sizes. Is it still Possible to move from RAC to Non-RAC with the above Schema size. Is it over or under size?

Re: RAC to Single Instance [message #480020 is a reply to message #480016] Wed, 20 October 2010 13:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Over or Under is upto your resources.
It will take quite a while to export and import.
Look into RMAN skip tablespace options and create a new TP2 database.
If you know RMAN, above option is simple and it works.
Some people find exp/expdp much more easier. Upto you and your resources.
If TP2 database already exists, exp/expdp is the option to go for.

[Updated on: Wed, 20 October 2010 13:25]

Report message to a moderator

Re: RAC to Single Instance [message #480031 is a reply to message #480020] Wed, 20 October 2010 13:52 Go to previous message
CajunVarst
Messages: 54
Registered: April 2010
Location: Washington, D.C.
Member
If you have Oracle support, take a look at Metalink document 415579.1. This document details using RMAN to restore from RAC to a single node. If you are comfortable with RMAN and know the physical structure of the database, it is rather straightforward.
Previous Topic: 11GR2 RAC TAF,FCF
Next Topic: listener_networks parameter and Grid Infrastructure
Goto Forum:
  


Current Time: Mon Nov 24 15:52:28 CST 2014

Total time taken to generate the page: 0.08981 seconds