Home » RDBMS Server » Server Administration » How to Create Test Database in Production Server
How to Create Test Database in Production Server [message #179442] Tue, 27 June 2006 07:40 Go to next message
madhumax
Messages: 1
Registered: June 2006
Location: Bangalore
Junior Member
How to create a test database in production server.

I have one production database on sunsolaries- 9
It has 44 datafiles across 5 locations.

I want to create a test database as same as production database
in the 2 locations which are unused.

Please help on this.

Report message to a moderator

Re: How to Create Test Database in Production Server [message #179443 is a reply to message #179442] Tue, 27 June 2006 07:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
First, i would not create a test database on a production server.
No harm, unless, i would break things apart.
All you need to do , create another database (either in same oracle home or another home).
Export and import the database
or
even use a cold copy.
For more information search the forum

[Updated on: Tue, 27 June 2006 07:48]

Report message to a moderator

Re: How to Create Test Database in Production Server [message #179510 is a reply to message #179442] Tue, 27 June 2006 15:29 Go to previous message
Vamshee
Messages: 32
Registered: February 2005
Member
Hi Madhu


Please refer to this link for more info.

http://www.dba-oracle.com/oracle_tips_db_copy.htm

NOTE:
Once again , as Mahesh suggested its not a good practise to try things on Production Server.

Let me know if you need more information
Thanks
Vamshee

Report message to a moderator

Previous Topic: parallelism, Oracle and an 8 cpu server
Next Topic: Intstallation Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:35:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.