Cloning a production database using different storage group paths
You might have to clone a production database onto a test database that uses a different machine. The test machine and production server are likely to have different storage group paths. The test system might not have paths backed by the newest and fastest storage disks.
About this task
Suppose you have a production database proddb
,
where some data is in storage group sg_hot
, which
has paths on an SSD device. You want to restore the data into the
less expensive and lower-performance test database testdb
.
The test system does not have the SSD device, but the other paths
are equivalent. Performing a redirected restore can change the paths
for sg_hot
on the test system without changing the
other storage groups.
Procedure
To restore data from a production database to a test database: