Home » RDBMS Server » Server Administration » Database shifting (Oracle version is 10.2.0.1.0.Operation system Suse 9)
Database shifting [message #384571] Wed, 04 February 2009 05:41 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Hi Experts,

Is it true that if servers have same file system its possible to stop Oracle on 1 server machine and copy all files to new server and start Oracle on new server?

Both the machine is having same configuration.
Both machine having same OS i.e. Suse 9
Both machines having oracle 10.2.0.1.0.

Then if this is the case then will the copy paste of
1. Data files
2. Redo log files
3. Control file
4. Pfile,spfile
5. Password file
6. Please specify if any....

on the same file system will work?????

If yes then please let me know the step by step guide for the same.

Thanks,
Re: Database shifting [message #384584 is a reply to message #384571] Wed, 04 February 2009 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it is true.
Step by step? copy all these files in same location.

Regards
Michel
Re: Database shifting [message #384586 is a reply to message #384571] Wed, 04 February 2009 06:16 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks Michel,

Could you please send me any document link or any step by step guide. So that i will not miss anything on production.

Thanks in advance.
Re: Database shifting [message #384589 is a reply to message #384586] Wed, 04 February 2009 06:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do it in test and then you will be sure to miss anything in production.

Regards
Michel
Re: Database shifting [message #384595 is a reply to message #384571] Wed, 04 February 2009 06:33 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Nice answer Embarassed

But is there there any guide available?
I did find it on google.

Please help.
Re: Database shifting [message #384598 is a reply to message #384595] Wed, 04 February 2009 06:41 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just list all files using dba_data_files, dba_temp_files, v$logile and v$parameter for control files.

Regards
Michel

[Updated on: Wed, 04 February 2009 06:42]

Report message to a moderator

Previous Topic: Problem while exporting database
Next Topic: Read only schema
Goto Forum:
  


Current Time: Tue Dec 06 06:33:34 CST 2016

Total time taken to generate the page: 0.10764 seconds