OraFAQ Forum: Server Administration » How to Create Test Database in Production Server

Home » RDBMS Server » Server Administration » How to Create Test Database in Production Server

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

How to Create Test Database in Production Server [message #179442]

Tue, 27 June 2006 07:40

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

Mahesh Rajendran
Messages: 10708
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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 20 14:29:46 CST 2025