| RAC to Single Instance [message #480006] |
Wed, 20 October 2010 12:33  |
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 #480020 is a reply to message #480016] |
Wed, 20 October 2010 13:11  |
 |
Mahesh Rajendran
Messages: 10708
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 |
CajunVarst
Messages: 55
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
