Home » RDBMS Server » Server Administration » Migration of oracle 10gR2 files from one host to a another (10gR2)  () 1 Vote
Migration of oracle 10gR2 files from one host to a another [message #283235] Mon, 26 November 2007 07:28 Go to next message
anilkumarbvn
Messages: 7
Registered: November 2007
Junior Member
Hi Oracle Guru's,

I am trying to do migration of oracle files from one host to
another. The hardware and OS are same. The Oracle Version is also the same. With new memory requirements i am doing this activity.
I have followed the below steps,

All my datafiles(.dbf) and control files and dump files are under /home1/common/ in Machine1.

/home1/common contain:
control01.ctl control03.ctl redo02.log sysaux01.dbf temp01.dbf users01.dbf control02.ctl redo01.log redo03.log system01.dbf undotbs01.dbf
adump bdump cdump udump

1. I have tar'ed the /home1/common and spfilecommon.ora.
2. Moved to machine 2 and copied the spfilecommon.ora on machine2.
3. Also moved the tarred copies to /home1/common on machine2
4. Restarted the database on machine2.

Is it the proper way of migration. I want the data only to be migrated. So i moved the control files, .dbf files and dump
files. Not sure of my process. Please confirm.

After i have done the above process, i tried connecting to
the database on machine2 after starting emagent. Unfortunately,
i was getting connecting to machine1 though the URL i specified was of Machine2. very confused after seeing this.
Can someone help me???


Thanks In Advance,
Anilkumar BVN

[Updated on: Mon, 26 November 2007 07:37]

Report message to a moderator

Re: Migration of oracle 10gR2 files from one host to a another [message #283302 is a reply to message #283235] Mon, 26 November 2007 11:03 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Your machine name is diiferent??
Make sure your IP and HOSTNAME are same as of previous SERVER.
Re: Migration of oracle 10gR2 files from one host to a another [message #283360 is a reply to message #283302] Mon, 26 November 2007 23:00 Go to previous messageGo to next message
anilkumarbvn
Messages: 7
Registered: November 2007
Junior Member
But i am trying to migrate to different machine which has a
different IP address. Is there any way to migrate this way so that my em works fine

Also, is my migration process correct. I have moved only files mentioned by me. Is that a correct process??
I have read it in one of the links. So i followed it.

Please help me to solve this problem.
Re: Migration of oracle 10gR2 files from one host to a another [message #283362 is a reply to message #283360] Mon, 26 November 2007 23:05 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

1. You have to reconfigure EM repository.
Re: Migration of oracle 10gR2 files from one host to a another [message #283415 is a reply to message #283235] Tue, 27 November 2007 01:47 Go to previous messageGo to next message
anilkumarbvn
Messages: 7
Registered: November 2007
Junior Member
Hi Mohammed,

Thanks for ur help.

As suggested by you, i have looked at em related directories for
my old hostname incase references are causing the problem.
But i couldn't find any such references of my old hostname.

Also, I have moved only the control files, datafiles (.dbf) and
the dump files to the new host machine. I haven't moved any em related files. So is there a need to reconfigure EM.

Does EM pick any data from control files..
Please let me know ur comments
Re: Migration of oracle 10gR2 files from one host to a another [message #283417 is a reply to message #283415] Tue, 27 November 2007 01:55 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

1. EM repository and DB is seprate services.

what method your using to move your database from Host A to Host B.

check below link hope this help
http://dbataj.blogspot.com/2007/03/shiftoracleserverfromonemachinetoanothe.html

When you run EMCA utiltiy to create OEM repository then oracle automatically create all required direcotries for EM repository.

I haven't moved any em related files.

No need to move anything related to EM.

Does EM pick any data from control files..
Nope.

Regards
Taj

PS: first try on test enviourment.
Re: Migration of oracle 10gR2 files from one host to a another [message #283458 is a reply to message #283235] Tue, 27 November 2007 03:51 Go to previous messageGo to next message
anilkumarbvn
Messages: 7
Registered: November 2007
Junior Member
Hi Mohammad,

First let me thank you for your help.
I thank DreamzZ and all member who tried to solve the problem.

So my problem was:
After migration of oracle datafiles (includes control files, database files (.dbf), dump files), when trying to connect to em using the browser URl i am seeing the information of the old Host.

Solution:
As per the suggestion given by Mohammad, i have create the database control repositories.
The command i have used are as follows:

RepManager -connect common -action drop
emca -deconfig dbcontrol db -repos drop -SID common
emca -config dbcontrol db -repos create -SID common

And after this change, i am able to see the information of my
database on the new host.

Thanks everyone.
Anilkumar BVN
Re: Migration of oracle 10gR2 files from one host to a another [message #283465 is a reply to message #283458] Tue, 27 November 2007 04:40 Go to previous messageGo to next message
anilkumarbvn
Messages: 7
Registered: November 2007
Junior Member
Hi Mohammad,

Is it required to Run even the RepManager command or
it is sufficient to execute emca -deconfig/config.

Thanks in Advance,
Anilkumar
Re: Migration of oracle 10gR2 files from one host to a another [message #283501 is a reply to message #283465] Tue, 27 November 2007 05:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

And after this change, i am able to see the information of my
database on the new host.

Yes,

it is sufficient to execute emca -deconfig/config.
Yes
Re: Migration of oracle 10gR2 files from one host to a another [message #283522 is a reply to message #283501] Tue, 27 November 2007 07:16 Go to previous messageGo to next message
anilkumarbvn
Messages: 7
Registered: November 2007
Junior Member
Thank you Very Much Mohammad.
Re: Migration of oracle 10gR2 files from one host to a another [message #283523 is a reply to message #283522] Tue, 27 November 2007 07:18 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Please give us your feedback when you compete.
Re: Migration of oracle 10gR2 files from one host to a another [message #283542 is a reply to message #283523] Tue, 27 November 2007 07:44 Go to previous message
anilkumarbvn
Messages: 7
Registered: November 2007
Junior Member
Hi Mohammad,

Your suggestion actually solved my problem.
Thanks a lot. You are very responsive to the questions
and have been giving continuous support even after i solved the
problem. I would rate you a 200% perfect DBA. Smile

Thanks once again to you.
Previous Topic: script
Next Topic: Comparing data structures
Goto Forum:
  


Current Time: Fri Dec 09 02:24:23 CST 2016

Total time taken to generate the page: 0.14021 seconds