In the event of data loss, you can use SnapCenter to restore data from one or more backups to your active file system and then recover the database.
Recovery is performed using the archive logs available at the configured archive log location. If the archive logs required for recovery are not available at the configured location, you should mount the Snapshot copy containing the logs and specify the path as external archive logs.
If you migrate ASM database from ASMLIB to ASMFD, then the backups created with ASMLIB can not be used to restore the database.You should create backups in the ASMFD configuration and use those backups to restore. Similarly, if ASM database is migrated from ASMFD to ASMLIB, you should create backups in the ASMLIB configuration to restore.
You can perform only connect-and-copy restore of ASM RAC databases on VMDK or RDM.
If you want to restore... | Do this... |
---|---|
All the datafiles of the database | Select All
Datafiles. Only the datafiles of the database are restored. The control files, archive logs, or redo log files are not restored. |
Tablespaces | Select
Tablespaces. You can specify the tablespaces that you want to restore. |
Control files | Select Control files. |
Redo log files | Select Redo
log files. This option is available only for Data Guard standby or Active Data Guard standby databases. Note: Redo log files are not backed up for non Data
Guard databases. For non Data Guard databases the
recovery is performed using archive
logs.
|
Pluggable databases (PDBs) | Select Pluggable databases, and then specify the PDBs that you want to restore. |
Pluggable database (PDB) tablespaces | Select
Pluggable database (PDB)
tablespaces, and then specify the PDB
and the tablespaces of that PDB that you want to
restore. This option is available only if you have selected a PDB for restore. |
If you... | Do this… |
---|---|
Want to recover to the last transaction | Select All Logs. |
Want to recover to a specific System Change Number (SCN) | Select Until SCN (System Change Number). |
Want to recover to a specific data and time | Select Date and Time. You must specify the date and time of the database host's time zone. |
Do not want to recover | Select No recovery. |
Want to specify any external archive log locations | Select Specify external archive log locations, and then specify the location of the external archive log files. If archive logs are pruned as part of backup, and you have manually mounted the required archive log backups, you must specify the mounted backup path as the external archive log location for recovery. NetApp Technical Report 4591: Database Data Protection Backup, Recovery, Replication, and DR |
If you are recovering a RAC database with the open database option selected, only the RAC instance where the recovery operation was initiated is brought back to the open state.
You can also specify the script timeout value. The default value is 60 seconds.
After restoring a container database (CDB) with or without control files, or after restoring only CDB control files, if you specify to open the database after recovery, then only the CDB is opened and not the pluggable databases (PDB) in that CDB.
In a RAC setup, only the RAC instance that is used for recovery is opened after recovery.