| Moving Oracle DB from one server to another (different versions) [message #435723] |
Thu, 17 December 2009 10:36  |
Ricky_1362002
Messages: 111
Registered: February 2009
|
Senior Member |
|
|
We have Oracle 10.2.0.3 on serverA.
And Oracle 10.2.0.4 on serverB (recently updated)
Both the servers have same OS (HP-UX B.11.31 ia64) and Same directory structure.
We have many databases on serverA, but right now, we decided on moving one of the test DB from serverA to serverB.
What i tried doing is.....
i did a cold backup of datafiles,controlfiles,tempfiles, redologs, spfile and orapw file from serverA to serverB, added the SID (want the same SID on serverB) to the /etc/oratab file,
then trying to start the database using "startup upgrade" option
but i get these errors.....
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 2059880 bytes
Variable Size 218104216 bytes
Database Buffers 612368384 bytes
Redo Buffers 6328320 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/opt/apps/oradata/TEST/systemTEST01.dbf'
Can anyone please help me or suggest me the steps to do....
i am struck here....please help
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Moving Oracle DB from one server to another (different versions) [message #435744 is a reply to message #435723] |
Thu, 17 December 2009 12:38  |
Ricky_1362002
Messages: 111
Registered: February 2009
|
Senior Member |
|
|
Michel,
I am very much sure that i copied all the files from the same source DB, after it was shutdown. Basically, all the datafiles, controlfiles,redologs are in the same folder TEST and i copied the entire folder to the target machine (using scp).
I think its not able to startup because of the difference in the versions, the source is 10.2.0.3 and the destination is 10.2.0.4, i really dont know what to do now.
Or suggest me if i can do anything right from the scratch.
Please help me guys....need your valuable suggestion/advice.
Thank you,
Munna
|
|
|
|
|
|
|
|
|
|
| Re: Moving Oracle DB from one server to another (different versions) [message #435748 is a reply to message #435723] |
Thu, 17 December 2009 13:26 |
Ricky_1362002
Messages: 111
Registered: February 2009
|
Senior Member |
|
|
>I am curious.
How many, which SIDs exist on source system?
Basically, the source server has many DBs, but each one has its own folder, similarly this TEST DB has a folder named TEST, under which we have all the datafiles,controlfiles, redologs, previously the datafiles had the name like TESTING01.dbf etc, but when we clone using the Enterprise Manager from another DB called TEST (this is different), we replaced the dbfs as TEST01.dbf etc.
Hope i answered your question.
Thanks,
Munna
|
|
|
|
|
|
|
|
| Re: Moving Oracle DB from one server to another (different versions) [message #435754 is a reply to message #435723] |
Thu, 17 December 2009 14:46 |
Ricky_1362002
Messages: 111
Registered: February 2009
|
Senior Member |
|
|
Ok guys, i will check with the backups again, and this time will try to take the cold backups carefully and then try starting the DB.
Forgot to tell you guys something......
As soon as i copied the files, i did this:
SQL>startup;
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL>recover database using backup controlfile;
(prompted for location: give the full location of redolog1)
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/opt/apps/oradata/TEST/redoTEST01.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
This made me think of the different versions.
Any comments???
|
|
|
|
| Re: Moving Oracle DB from one server to another (different versions) [message #435755 is a reply to message #435723] |
Thu, 17 December 2009 14:49 |
Ricky_1362002
Messages: 111
Registered: February 2009
|
Senior Member |
|
|
Babu,
Even though the folder had many system dbfs I copied the entire folder, as we know that the DB would only consider those dbfs mentioned in the controlfile but anyways I will take the backups again when i get the chance.
Yes, the DB on serverA is fine, and the stucture is also the same.
But please tell me the steps to do after i take the backups.
Should i also do the backup of controlfile using "Alter database backup controlfile to trace as '/.../...(path)'
please give me the steps.
Thank you,
Munna
[Updated on: Thu, 17 December 2009 14:52] Report message to a moderator |
|
|
|
|
|
| Re: Moving Oracle DB from one server to another (different versions) [message #435759 is a reply to message #435723] |
Thu, 17 December 2009 16:03 |
Ricky_1362002
Messages: 111
Registered: February 2009
|
Senior Member |
|
|
I am sorry Michel, but i am not hiding anything from you guys, moreover, why do i have to hide anything....
What i wanted to let you guys know is that The reason for me to think of different versions is because as soon as i copied all the files to the new server, i tried to start the DB using this:
SQL>startup;
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL>recover database using backup controlfile;
(prompted for location: give the full location of redolog1)
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/opt/apps/oradata/TEST/redoTEST01.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
I DID take a cold backup very carefully.
And i truly DO NOT hide anything, and i know that hiding things can and will make problems much severe.
May be i will delete all the files and do the cold backup as soon as i get a chance, but someone please give me the steps after taking the cold backup.
Thank you,
Munna
|
|
|
|
|
|
| Re: Moving Oracle DB from one server to another (different versions) [message #435766 is a reply to message #435723] |
Thu, 17 December 2009 17:14 |
Ricky_1362002
Messages: 111
Registered: February 2009
|
Senior Member |
|
|
BlackSwan,
Thank you for the reply.
The target system already has 10.2.0.4 on it, installing 10.2.0.3 again on it would make it complicated to me.
We are about to update the source system from 10.2.0.3 to 10.2.0.4, and then may be it will be easier for the replication.
Installing 10.2.0.3 again would make it complicated, atleast for me.
But still, if i would do that, how would i?
Did you mean installing 10.2.0.3 at a different location???
|
|
|
|
|
|
| Re: Moving Oracle DB from one server to another (different versions) [message #435768 is a reply to message #435723] |
Thu, 17 December 2009 17:34 |
Ricky_1362002
Messages: 111
Registered: February 2009
|
Senior Member |
|
|
Ok BlackSwan,
I will try that, and post here if something is wrong or even if it succeeds.
Right now, the other DBA already deleted all the files which i copied from serverA.
To do the cold backup, i need to shutdown the DB on serverA but there is some testing going on right now, so cannot do that. Will do as and when i get the chance to.
Thanks much.
-Munna
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
