Home » RDBMS Server » Server Utilities » tool copy database
tool copy database [message #154861] Wed, 11 January 2006 01:17 Go to next message
marwan.h
Messages: 24
Registered: December 2005
Location: bey
Junior Member
hello
does anyone know any good tool to copy an entire database to another host,not schema's the whole database.
thanks
Re: tool copy database [message #154863 is a reply to message #154861] Wed, 11 January 2006 01:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
RMAN ( if the hosts are of same OS)
or
Export/Import (Only method available if the hosts are of different OS)
Re: tool copy database [message #154916 is a reply to message #154861] Wed, 11 January 2006 05:21 Go to previous message
marwan.h
Messages: 24
Registered: December 2005
Location: bey
Junior Member
hello
suppose i have a win2000 server with database named A
and another win2000 server with database B
if i shutdown database B
copy all datafiles , controle files,redo log files , parameter files....into the same structure into server A

shutdown database A and startup the database specifieng the parameter file of database B that i just move..
1- does it works ?
2- is it considered as a legitimate copy of database B ?
3- any side effects ?
4- password file troubles ....

thanks
Previous Topic: Facing error while try to load data conditionally
Next Topic: SQL-Loader+ Big Problem
Goto Forum:
  


Current Time: Tue Jul 02 04:41:18 CDT 2024