Home » Infrastructure » Windows » Transfer
Transfer [message #238564] Fri, 18 May 2007 09:34 Go to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi,

There is a new built windows 2003 server , I have to install oracle & transfer the database files from the old server and startup the database. For that I have to transfer all the files between the 2 remote windows servers. I tried winscp drag & drop to transfer the files from the old server to the new server using the remote connection. I am not able to do it. Is there any other way I could use to transfer the files???

Thanks very much!

Report message to a moderator

Re: Transfer [message #238577 is a reply to message #238564] Fri, 18 May 2007 10:55 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
FTP?

Report message to a moderator

Re: Transfer [message #239104 is a reply to message #238564] Mon, 21 May 2007 08:56 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi,

Ftp is taking tooo long to transfer...

I just mapped the drives and transferred..

I have another question.. After starting up the database in the new server, the users want me to rename the old database in the old server to a different database name. To rename the database name, will it be fine if I just change the db name in the init file and start the database? Do I have to recreate the control file?? Database version is 9.2.0.5

Thanks all.

Report message to a moderator

Re: Transfer [message #239117 is a reply to message #239104] Mon, 21 May 2007 09:12 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Hi,

For rename database you have to USE DBNEWID utility instead of recreate controlfile (manually)

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96652/ch14.htm#1004735

For example(based on Oracle10g)

http://dbataj.blogspot.com/2007/04/changing-only-database-name.html
Regards
Taj

PS: Before doing anything if it is PRODUCTION DATABASE please take RECOVERABLE DATABASE BACKUP.

[Updated on: Mon, 21 May 2007 09:17]

Report message to a moderator

Re: Transfer [message #239118 is a reply to message #239104] Mon, 21 May 2007 09:15 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member
You could have a look at the DBNEWID Utility. I have never used it thou.
Read the documenation from Oracle as well , before you try it out.

Slow ftp ? It's has nothing to do with the ftp.. more likely your network speed/configuration

Report message to a moderator

Re: Transfer [message #239136 is a reply to message #238564] Mon, 21 May 2007 09:48 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Thanks Taj & Tahpush for the links.. Inorder to rename the database name, is it necessary to change the dbid as well??

Thanks.

Report message to a moderator

Re: Transfer [message #239137 is a reply to message #239136] Mon, 21 May 2007 09:50 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Hi,
is it necessary to change the dbid as well??
It is depends on you.

When you clone database on some machine that time you have to change DBID for RMAN utility otherwise no need.



Regards
Taj

Report message to a moderator

Previous Topic: OracleXE Silent Installation
Next Topic: Installation Oracle 8i on WinXP
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 08 06:59:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.