We have a 3TB Data Warehouse on Oracle 10g R2 database on IBM AIX 5.2 OS. We are in the stage of rebuilding a new test/disaster recovery (DR) environment which we want to use as DR and test environments. We would like to refresh the full 3TB of data on a regular basis for system testing, as well as set up some kind of DR on the same server. Is there any fast way of shipping 2TB of data across to the test environment? From what I have been reading a RMAN restore would take weeks, and Data Pump would take a long time as well. Any help on this will be much appreciated.
Probably the quickest way is to use Transportable Tablespaces to copy the files from one system to another. The copy can be as quick as simply transferring files from one server to another. Please read this document on
Oracle Transportable Tablespaces
for more information.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.