Home » RDBMS Server » Server Administration » add database to server
add database to server [message #496020] Wed, 23 February 2011 16:11 Go to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

MS SQL has a scenario, when you bring data and log file from another server to yours server you can just attach those files and you have new ms sql database in work progress?

Does this scenario is possible on oracle, or can I bring database backup from another server to my server (for develop & testing for example) and to keep another databases?

Thanks in advanced...
Re: add database to server [message #496025 is a reply to message #496020] Wed, 23 February 2011 17:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Does this scenario is possible on oracle, or
not possible.

>can I bring database backup from another server to my server (for develop & testing for example) and to keep another databases?
yes
Re: add database to server [message #496027 is a reply to message #496025] Wed, 23 February 2011 18:28 Go to previous messageGo to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi BlackSwan,

is it mean that if I have oraA database on my develop server and I restore oraB database and after that I have both database, of cource under same direcory like it is on original server from wich oraB database was backuped?

Thanks again...
Re: add database to server [message #496041 is a reply to message #496027] Wed, 23 February 2011 23:31 Go to previous message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot mix upi files from different databases in one.
You can have 2 databases on 1 server.

Now what you want is not clear.

Regards
Michel
Previous Topic: CSALTER ERROR after csscan ran clean.
Next Topic: Oracle 10.2.0.5 patch
Goto Forum:
  


Current Time: Wed May 08 18:37:53 CDT 2024