| copy from a production db to a test - how to? [message #68995] |
Thu, 11 October 2001 12:16  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
