Home » RDBMS Server » Server Administration » Creating a copy of database for testing purpose
Creating a copy of database for testing purpose [message #62270] Thu, 08 July 2004 12:01 Go to next message
Joan
Messages: 36
Registered: February 2002
Member
I need to create a copy of our production database for testing purpose. The database name will be different. What is the best way to do this without shutting down the production db and copy the files.

- Using backup controlfile  or

- Create the database from scratch and do full import from the production instance.

Can I use the controfile to create my db and all the tablespaces before doing the import.

Please give me your experience in both. I have always being succesfully in copying the files while the db is down but this time I have to make sure the db stay up.. thanks

 

Report message to a moderator

Re: Creating a copy of database for testing purpose [message #62294 is a reply to message #62270] Tue, 13 July 2004 03:48 Go to previous messageGo to next message
Oskar
Messages: 26
Registered: May 2002
Junior Member
Metalink (metalink.oracle.com) provides example scripts for cloning a database from a hot backup. You only need a valid account there.

Report message to a moderator

Re: Creating a copy of database for testing purpose [message #62305 is a reply to message #62270] Tue, 13 July 2004 14:51 Go to previous message
Chris L
Messages: 7
Registered: January 2004
Junior Member
See above.

I have used cloning. It is easy and quick.

If you have experience with RMAN you can now clone a database with RMAN.

Import/export takes too long and too many problems.

Report message to a moderator

Previous Topic: how can i locate the default oracle databases
Next Topic: Reasons to upgrade from Oracle 7.3.4 to 9i and beyond.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 04:27:28 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.