Home » RDBMS Server » Server Utilities » copy from a production db to a test - how to?
copy from a production db to a test - how to? [message #68995] Thu, 11 October 2001 12:16 Go to next message
Lee
Messages: 56
Registered: May 1999
Member
what is the best way to copy a production db to a test db (v 8.1.6 on aix). Is there a checklist of steps?

----------------------------------------------------------------------
Re: copy from a production db to a test - how to? [message #69006 is a reply to message #68995] Sat, 13 October 2001 03:44 Go to previous message
Suresh Baral
Messages: 11
Registered: October 2001
Junior Member
Hi

1) Take cold backup (copy in OS level) of database files and restore it in test location.

2) change the parameters in init.ora file .i.e. db_name

3) Earlier create a control file script by using alter database backup controlfile to trace. Then in oracle_homerdbms80trace directory you will get the ora99999.trc file, where you will get the script to of create controlfile. So in this script you have to change path of all logfiles and datafiles. Instead of CREATE CONTROLFILE REUSE DATABASE dbname ...., modify it into CREATE CONTROLFILE SET DATABASE dbname......

Then run this file by using server manager utility.

That's ok. Good luck.

Suresh

----------------------------------------------------------------------
Previous Topic: showing oracle messages
Next Topic: Re: OCP Exam Papers
Goto Forum:
  


Current Time: Fri Mar 29 09:37:29 CDT 2024