Q
Problem solve Get help with specific problems with your technologies, process and projects.

Media for transporting data to new data center

I'm one of the DBAs responsible for moving databases and applications to the new data center, and the database sizes vary from 7 terabytes to 40 GB. What media should I use to transport the data?

I'm one of the DBAs responsible for moving databases and applications to the new data center, and the database sizes vary from 7 terabytes to 40 GB. What media should I use to transport the data? What is the best way to move the data through FTP, or what are the other methods? Do I tell the DBAs on the other end to get the data as a dump file or flat file, especially with 7 terabytes?
One of the easiest ways to transport data is to use Oracle's Transportable Tablespaces. This saves you the hassle of having to perform lengthy export and import processes. The biggest factor is the time it takes to copy datafiles. When transporting multiple terabytes of data to another server, especially at another site, it can be too taxing on your network to FTP these files. So you might want to dump the files to media like USB2 or Firewire external disk devices. A popular size for these devices now is 300GB so four disks will hold 1.2TB of data.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close