| Migration of oracle 10gR2 files from one host to a another [message #283235] |
Mon, 26 November 2007 07:28  |
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 #283360 is a reply to message #283302] |
Mon, 26 November 2007 23:00  |
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 #283415 is a reply to message #283235] |
Tue, 27 November 2007 01:47 |
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 #283458 is a reply to message #283235] |
Tue, 27 November 2007 03:51 |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
