Hello Everyone out there,
I am looking for steps to refresh sandbox environment with the DEV database backup available on the EMC data Domain.
Details of the environments and backups are as follows:
Environment: Development
DEV Database.
Version: Oracle 11gr2 (11.2.0.3)
Archivelog mode.
Plugin for Data Domain DDBOOST installed.
backups: RMAN (no catalog, using controlfile) FULL backup and shipping backup to EMC Data Domain and a copy to DR Domain using Media manager library.
Environment: Sandbox
Test Database
Version: Oracle 11gr2 (11.2.0.3)
Archivelog mode.
Plugin for Data Domain DDBOOST installed.
backups: RMAN (no catalog, using controlfile) Full backups and shipping backup to EMC Data Domain and a copy to DR Domain using Media manager library.
In both environments the devices used for backup are of type 'SBT_TAPE' and configured respectively.
The backups of DEV are available as of 07/07/2014.
The pfile of the Test database has the parameters db_file_name_convert and log_file_name_convert already set.
I would like to refresh Test Database with Development database backup as of 07/09/2014.
In the past the backups were all disk based and the backups were stored according to date in EVAULT system and it was easy to refresh the Test (sandbox ) environment.
Can somebody help me with the steps to be taken to refresh Test database from DEV database in the data domain scenario?
Thanks a ton in advance.
Ram.