Instant recovery of an Oracle database to any target using Backup and DR "Mount and Migrate" is a two-phase operation: The Restore Mount phase provides instant access to the database by starting it from a backup/recovery appliance presented backup image. The Migration phase migrates the database data files to the production storage while the database is online.
How it works
Restore Mount Phase: provides instant access to the database from selected image presented by the backup/recovery appliance.
- A copy of the selected backup image is mapped to the target database server and presented to the ASM or file system layer (based on the source database backup image format).
- RMAN API is used:
- to restore the Control file and Redo Log file to the specified control
file and redo file location (ASM diskgroup or file system). - to switch the database to the copy of the image presented by the backup/ recovery appliance.
- to roll-forward all available archive logs to the specified recovery point.
- to open the database in read and write mode.
- to restore the Control file and Redo Log file to the specified control
- The database is running from the mapped copy of the backup image presented by the backup/recovery appliance.
- The Control File and the Redo Log file of the database is on the selected local production storage (ASM diskgroup or file system) on the target.
- After a successful restore mount operation, the database is available for production operation and a migration option will be available to move the data back to the production storage (ASM disk group or file system) using the Oracle online datafile move API while the database and application is up and running.
Migration Phase: moves the database datafile online to the production storage:
- Data migration runs in the background. The Oracle online datafile move API
is used to migrate the data. - Datafiles are moved from the Backup and DR presented copy of backup image to the selected target database storage (ASM diskgroup or file system).
- The Backup and DR presented copy of the backup image (ASM diskgroup or file system) is removed and unmapped from target upon completion of migration.
You can track the progress of the Restore Migrate job in the management console monitor.
Procedure
Restore Mount phase
- From the App Manager Applications list, right-click the database and select Access.
- Select the latest snapshot to recover and choose Restore.
On the Restore page, choose MOUNT AND MIGRATE.
- Target: For all configurations, eligible Oracle database servers will be available to choose under the drop down. Select the target server for restore from the drop down
- Replace Original Application identity: This option is only available when restore is performed to a new server on the same appliance where the backup was originally generated.
- Yes: This will replace the original application and will carry the same application id, jobhistory, backup images and backup plan as the original application.
- No: This will not replace the original application. It will be discovered as a new application as part of restore job.
- Rollforward time: Choose a date and time for a database protected with logs to recover to the desired point in time.
Application Options:
- DATABASESID: This is pre-populated with the protected database sid name and is immutable.
- USERNAME: This is pre-populated with source database Oracle software owner. Update the USERNAME if the Oracle software owner on the selected target server is different.
- ORAHOME: This is pre-populated with source database Oracle Home path. Update the Oracle Home directory if the Oracle home is different on the selected target server.
- Advanced Options: This is pre-populated and displays all the database parameter settings (from pfile) at the source at backup time. Make sure the parameter value is correct for the target database server (source or new target) for restore.
Mapping Options:
CONTROL FILE TARGET TYPE: Select the desired database control file target type (ASM diskgroup or file system) for the database from the drop-down list. FS target type is not supported for backup images in ASM format.
Backup image format Supported storage type ASM ASM (FS not supported) FS FS, ASM CONTROL FILE TARGET: A drop-down list shows the available target (ASM diskgroup or file system) based on selected CONTROL FILE TARGET TYPE. Select the desired target for the control file location from the list of eligible disk groups or file systems in the drop-down list. Multiple selections can be made to multiplex the control file. This location is also used as the destination for the temporary files for the temp tablespace.
REDO TARGET: If none is selected then the Control File Target will be used for the Redo target. A drop-down list shows the available target (ASM diskgroup or file system) based on the selected Control File Target Type. Select the target for the redo file location from the list of eligible disk groups or file systems in the drop-down list. Multiple selections can be made to multiplex the redo file.
RAC NODES: This is only available when the selected restore target is set up with a RAC cluster. Click + to add the RAC node list for restore to RAC cluster.
Click the Pre-Flight Check. If the pre-flight check fails, fix the issue and resubmit the pre-flight check.
Click Submit to submit the restore job.
Migration phase
- From the management console App Manager Applications list right-click the database and select Access.
Select the mounted image. From the active mount select Migrate.
On the migrate page, for Copy Thread Count, enter a thread count value to configure parallelism for the online datafile move operation.
For Migrate Mapping, map the source volume to Target volume (ASM diskgroup or file system) where:
- Source volume displays source database data file distinct locations (ASM diskgroup or file system) name
- Required Size displays the space required on the Target location (ASM diskgroup or file system)
- Target volume displays all the eligible target locations (ASM diskgroup or file system) for datafiles, select the appropriate target for source datafile to target datafile location mapping
Click the pre-flight check. If the pre-flight check fails, fix the issue
and resubmit the pre-flight check.Click Submit to submit the restore job. When the migration job is complete, the Backup and DR presented backup image copy (ASM diskgroup or file system) will be removed and unmapped from the target, and the database will be running from your production storage.
The Oracle DBA Guide
- Backup and DR for Oracle databases
- Prerequisites for protecting an Oracle database
- Oracle patches and known issues
- Prepare Oracle databases for protection
- Discover and protect an Oracle database
- Details and settings for Oracle databases
- Use dNFS with Backup and DR
- Protect a discovered Oracle database
- Mount an Oracle database as a standard mount
- Create an instant virtual copy of an Oracle database
- Restore and recover an Oracle database
- Instant recovery of an Oracle database using Mount and Migrate
- Provision an environment with a Backup and DR workflow