Home » RDBMS Server » Performance Tuning » Move Production database to test environment for load tests
Move Production database to test environment for load tests [message #133039] Wed, 17 August 2005 08:05 Go to next message
HansHaeberle
Messages: 2
Registered: August 2005
Junior Member
We have on test and production the same hardware and disk sizes.

Now we want to move the production data to the test environment. An export and import will "destroy" the fragmentation of the Oracle data files.

Does anybody have experience with copying the data files? What disadvantages do we have to consider?
Re: Move Production database to test environment for load tests [message #133040 is a reply to message #133039] Wed, 17 August 2005 08:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> An export and import will "destroy" the fragmentation of the Oracle data files.
So dont you want to have 'fragmentation' fixed?
actually,
with DMT, if you use pctincrease=0 and initial=next
or
with LMT, if you use uniform extent size
There is absolutely no fragmentation.

anyhow to anser your question
>>does anybody have experience with copying the data files?
>>What disadvantages do we have to consider?

1. You can use RMAN to duplicate the PROD to TEST.
2. You cold copy cloning.
take backup of controlfile( backup controlfile to trace)
shutdown your production
copy all the files to new location
rebuild the control files
Works cool
Re: Move Production database to test environment for load tests [message #133045 is a reply to message #133040] Wed, 17 August 2005 08:21 Go to previous message
HansHaeberle
Messages: 2
Registered: August 2005
Junior Member
Mahesh Rajendran wrote on Wed, 17 August 2005 15:11

>> An export and import will "destroy" the fragmentation of the Oracle data files.
So dont you want to have 'fragmentation' fixed?


Of course we want issues like fragmentation fixed - but on production. Therefore we set up a test database which is as close as possible as production.
Previous Topic: Foreign Keys vs. custom scripts
Next Topic: slow server
Goto Forum:
  


Current Time: Tue Dec 06 20:58:01 CST 2022