We recently did this with the export/import method for a 700G DB and it took, all in all about 24 hours. We've done it using backups before, and as long as your systems match exactly for disks and space this can be faster (~12 hours).
Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Soria, Joe Sent: Thursday, December 09, 2010 5:02 PM To: [email protected] Subject: Re: Oracle 10g Data Migration There are many ways to perform this task. To name a few: 1) perform a cold backup of the database -> copy to new server 2) export/import 3) using data pump 4) using oracle's database creation assistant (DBCA) My recommendation is, if you are not familiar with these terms/tools. Find a DBA. What version of Oracle are you going from to? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of G. Lafontant Sent: Thursday, December 09, 2010 2:56 PM To: [email protected] Subject: Oracle 10g Data Migration Does anyone know approximately how long will it take to replicate a database server of 600gig of data to another Oracle server box? And what's the best tool out there to make that feasible quick and easy? ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
