| copy database [message #154858] |
Wed, 11 January 2006 01:05  |
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
|
|
|
|
|
|
| Re: copy database [message #154881 is a reply to message #154858] |
Wed, 11 January 2006 02:23  |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
thx
i found that i should backup control file to trace,
but why shall i do so
cause on the new database im using the parameter file that points to the control files of the database being moved?
thanks
|
|
|
|
|
|
| Re: copy database [message #154893 is a reply to message #154858] |
Wed, 11 January 2006 03:26 |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
sorry
i have a database on server B called database B
so instead of starting up database B with its own parameter file.
i will started up with the parameter file of database A of course after moving all data redo control files to the same structure of database B.
i dont need database A, it's created with installation of oracle server9i
it works ???
thanks for all of ur replies..
|
|
|
|
|
|
| Re: copy database [message #154908 is a reply to message #154858] |
Wed, 11 January 2006 04:45 |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
thanks for ur help
ill make it more clear and detailed
i have 2 oracle database A & B
if i shutdown database B , copy all datafile , controle file, redo log file , parameter file
then copy those file into database A preserving file structure
shutdown database A
startup database A pointing to the parameter file of database B
does it work ?
meaning database B will b runing instead of database A
thanks alot
|
|
|
|
| Re: copy database [message #154924 is a reply to message #154908] |
Wed, 11 January 2006 06:23 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
As asked before,
READ documentation. May be you are using a different terminology here that i do not understand.
>>then copy those file into database A preserving file structure
makes no sense.
You cannot do that.
Oracle datafiles are NOT plug-and-play files ( unless you use a transportable tablespace, which is a very different case).
All you can do is,
Have two different databases A and B with two different pfiles.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
