Using VMS Shadowing to Copy Your Database

August, 2002


We have a 25GB Oracle production database spread over 11 shadow sets. From time to time the database administrator (DBA) decides that it is time to ‘copy prod to test,’ repopulating the test database with current production data. We describe a technique we use to accomplish this using VMS Host Shadowing and the shared access disk capability of a VMS Cluster.