OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database shifting (Oracle version is 10.2.0.1.0.Operation system Suse 9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database shifting [message #384571]

Wed, 04 February 2009 05:41

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,

Report message to a moderator

Re: Database shifting [message #384584 is a reply to message #384571]

Wed, 04 February 2009 06:09

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: Database shifting [message #384586 is a reply to message #384571]

Wed, 04 February 2009 06:16

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.

Report message to a moderator

Re: Database shifting [message #384589 is a reply to message #384586]

Wed, 04 February 2009 06:19

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: Database shifting [message #384595 is a reply to message #384571]

Wed, 04 February 2009 06:33

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.

Report message to a moderator

Re: Database shifting [message #384598 is a reply to message #384595]

Wed, 04 February 2009 06:41

Michel Cadot
Messages: 68666
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 04:42:15 CDT 2024