OraFAQ Forum: Performance Tuning » Move Production database to test environment for load tests

Home » RDBMS Server » Performance Tuning » Move Production database to test environment for load tests

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

Move Production database to test environment for load tests [message #133039]

Wed, 17 August 2005 08:05

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?

Report message to a moderator

Re: Move Production database to test environment for load tests [message #133040 is a reply to message #133039]

Wed, 17 August 2005 08:11

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

Report message to a moderator

Re: Move Production database to test environment for load tests [message #133045 is a reply to message #133040]

Wed, 17 August 2005 08:21

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.

Report message to a moderator

Previous Topic:	Foreign Keys vs. custom scripts
Next Topic:	slow server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 11:40:21 CDT 2025