Home » RDBMS Server » Backup & Recovery » Moving Oracle DB from one server to another (different versions) (Oracle 10.2.0.3 to Oracle 10.2.0.4)
Moving Oracle DB from one server to another (different versions) [message #435723] Thu, 17 December 2009 10:36 Go to next message
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 #435729 is a reply to message #435723] Thu, 17 December 2009 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you get this I doubt it was a cold backup or you mixed your backup files.

Regards
Michel
Re: Moving Oracle DB from one server to another (different versions) [message #435731 is a reply to message #435723] Thu, 17 December 2009 11:03 Go to previous messageGo to next message
Ricky_1362002
Messages: 111
Registered: February 2009
Senior Member
Thank you Michel for the reply.

I got what you meant.

The folder in which the datafiles exist, has many system datafiles, but the names are different, like the systemTEST01.dbf, systemTESTING01.dbf, and i know which one is the correct one, so can delete the other datafiles and then try the "startup upgrade" ????
Re: Moving Oracle DB from one server to another (different versions) [message #435733 is a reply to message #435723] Thu, 17 December 2009 11:19 Go to previous messageGo to next message
Ricky_1362002
Messages: 111
Registered: February 2009
Senior Member
Or is there any other way make this work, like recreating controlfile, please suggest..

Thanks,
Munna
Re: Moving Oracle DB from one server to another (different versions) [message #435734 is a reply to message #435731] Thu, 17 December 2009 11:20 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
I did a cold backup of datafiles,controlfiles,tempfiles, redologs, spfile and orapw file from serverA to serverB


share with us your cold backup step

- Babu
Re: Moving Oracle DB from one server to another (different versions) [message #435735 is a reply to message #435723] Thu, 17 December 2009 11:23 Go to previous messageGo to next message
Ricky_1362002
Messages: 111
Registered: February 2009
Senior Member
Hey Babu,
There were no particular steps i followed, i just shutdown the DB on serverA, and did a normal copy (using scp) to the target server. And then restarted the old DB on serverA.


-Thank you,
Munna

[Updated on: Thu, 17 December 2009 11:40]

Report message to a moderator

Re: Moving Oracle DB from one server to another (different versions) [message #435736 is a reply to message #435735] Thu, 17 December 2009 12:01 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you shutdown the database with normal or immediate or with another option?

Regards
Michel
Re: Moving Oracle DB from one server to another (different versions) [message #435741 is a reply to message #435723] Thu, 17 December 2009 12:14 Go to previous messageGo to next message
Ricky_1362002
Messages: 111
Registered: February 2009
Senior Member
I did a "Shutdown immediate", on the source server, then copied all the files.
Re: Moving Oracle DB from one server to another (different versions) [message #435742 is a reply to message #435741] Thu, 17 December 2009 12:32 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry but I think you missed something, it is NOT possible that a real cold backup can't be started without any recovery.
The message clearly show an inconsistent (and then not cold) backup.
Are you sure you take the control file from the backup and not another one?

Regards
Michel
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 Go to previous messageGo to next message
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 #435745 is a reply to message #435744] Thu, 17 December 2009 12:45 Go to previous messageGo to next message
BlackSwan
Messages: 24903
Registered: January 2009
Senior Member
>Please help me guys....need your valuable suggestion/advice.
I agree with Michel.
I've been there & done that hundreds of times.

If you are seriously concerned about the software version mismatch,
then that is easily solved.

Install a V10.2.0.3 software tree also on target system.
After copying the files from source to target, then open DB using V10.2.0.3 version.
After it opens, do SHUTDOWN IMMEDIATE.
Then change ORACLE_HOME to be V10.2.0.4 & invoke dbua
Re: Moving Oracle DB from one server to another (different versions) [message #435746 is a reply to message #435723] Thu, 17 December 2009 13:02 Go to previous messageGo to next message
Ricky_1362002
Messages: 111
Registered: February 2009
Senior Member
Thank you BlackSwan for your reply.

So, do you think that software mismatch has nothing to do with it?
Re: Moving Oracle DB from one server to another (different versions) [message #435747 is a reply to message #435746] Thu, 17 December 2009 13:11 Go to previous messageGo to next message
BlackSwan
Messages: 24903
Registered: January 2009
Senior Member
>So, do you think that software mismatch has nothing to do with it?
I believe Oracle's error codes/messages.
I do not think the error was thrown simply because the files originated as part of V10.2.0.3 DB.

By definition V10.2.0.4 has to be able to open V10.2.0.3 files as part of the upgrade procedure.

But again, don't take our word on this, test for yourself.
If after the posted error, you did nothing else, then you can install V10.2.0.3 & try to open the copied files.
I expect the same error to occur using V10.2.0.3 software.

I am curious.
How many, which SIDs exist on source system?
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 Go to previous messageGo to next message
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 #435750 is a reply to message #435748] Thu, 17 December 2009 13:38 Go to previous messageGo to next message
BlackSwan
Messages: 24903
Registered: January 2009
Senior Member
>Hope i answered your question.
I suspect that the collection of copied files was incorrect.

As we both know & realize the following:
SHUTDOWN IMMEDIATE
scp .....
STARTUP

The files/DB does not know or care they now reside on a different system.
If the collection of files were complete & correct, the DB would open.

Base upon reality of the error message, I can only conclude the collection of files on the target system were not complete & correct.
Re: Moving Oracle DB from one server to another (different versions) [message #435753 is a reply to message #435750] Thu, 17 December 2009 14:39 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
The folder in which the datafiles exist, has many system datafiles, but the names are different, like the systemTEST01.dbf, systemTESTING01.dbf, and i know which one is the correct one, so can delete the other datafiles and then try the "startup upgrade" ????


I think some mistake done here. Hope your database still available in server A. Request you to take backup again from server A.

Transfer all the backup to Server B (Hope your structure also same)

Note:

1. As per your previous update do not delete any mismatch files before or after backup.
2. Repeat same steps with new backup & upload alert log from server A & B

- Babu
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #435756 is a reply to message #435754] Thu, 17 December 2009 15:13 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Forgot to tell you guys something......

I bet there are many other things you forgot to tell us.
I give up, how can you expect we help if you don't tell us the truth.
So you didn't make a cold backup and/or you didn't copy the correct files. THIS IS THE TRUTH.
Whatever you can say against that is wrong whatever you think it is.

Regards
Michel
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 Go to previous messageGo to next message
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 #435762 is a reply to message #435759] Thu, 17 December 2009 16:58 Go to previous messageGo to next message
BlackSwan
Messages: 24903
Registered: January 2009
Senior Member
Install a V10.2.0.3 software tree also on target system.
After copying the files from source to target, then open DB using V10.2.0.3 version.
After it opens, do SHUTDOWN IMMEDIATE.
Then change ORACLE_HOME to be V10.2.0.4 & invoke dbua
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 Go to previous messageGo to next message
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 #435767 is a reply to message #435766] Thu, 17 December 2009 17:25 Go to previous messageGo to next message
BlackSwan
Messages: 24903
Registered: January 2009
Senior Member
>Did you mean installing 10.2.0.3 at a different location???
Yes, create a different directory to be ORACLE_HOME for V10.2.0.3
This will allow you to open the DB after the file transfer & validate it really is a clone of the source system.
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 Go to previous messageGo to next message
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
Re: Moving Oracle DB from one server to another (different versions) [message #436468 is a reply to message #435768] Wed, 23 December 2009 13:26 Go to previous message
stonevishcool
Messages: 29
Registered: June 2008
Location: Mumbai
Junior Member
[quote To do the cold backup, i need to shutdown the DB on serverA.
[/quote]


Before taking cold backup make sure file path is correct by using below command.

SELECT NAME FROM V$DATAFILE
UNION ALL
SELECT MEMBER FROM V$LOGFILE
UNION ALL
SELECT NAME FROM V$CONTROLFILE;


Regards,
Vish
Previous Topic: Recover sysaux datafile?
Next Topic: RMAN - Clone database
Goto Forum:
  


Current Time: Sat Sep 24 16:21:31 CDT 2016

Total time taken to generate the page: 0.10013 seconds