0

I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer enter image description here

Now I am planning to have machine 3 which will consolidate both Oracle instances on one new node

enter image description here

Question is what is best way to do this ?

I surfed & found that oracle SQL Developer can help check this Link

Does this will work ?? Or I have to fallow RMAN cloning option ?

What is best suitable way for doing this ?

  • I wouldn't use our Database Copy for this - that's more for ad hoc copies. If you want to migrate/consolidate entire instances, there are much more efficient ways. – thatjeffsmith Apr 1 '15 at 13:07
  • expdp and impdp are probably a lot more efficient than using SQL Developer for this. If you can create a DBLink you don't even need intermediate files for that – a_horse_with_no_name Apr 1 '15 at 13:07
  • Yep!! I am thinking exdp & impdp too. I am exploring all possible ways as db is not live & I am just running tests. @a_horse_with_no_name : I used DB links for vertical & horizontal fragmentation, who it can help in migrations ? – Ashish Apr 1 '15 at 18:32
0

why do you need windows at all? you even do not need sql developer.

  • shutdown the source database
  • scp datafiles(.dbf .ctl)
  • scp files in ORACLE_HOME/dbs (like initSID.ora, spfileSID.ora, and also password file)
  • you should also create dirs for diagnostic_dest (where alert.log is placed)
  • amend /etc/oratab
  • set the right SID
  • start the database

PS: this assumes that the Oracle version (including fixpack) is exactly the same.

  • Let me try this!!, Any URL where i can get this [I am linux developer, little DBA migration skills] – Ashish Apr 1 '15 at 13:11
  • I was even thinking of DataPump – Ashish Apr 1 '15 at 13:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.