Restore cloud native application data

Contributors netapp-soumikd

In the event of data loss, you can restore the data files, control files, or both and then recover the database.

Steps

  1. Click icon to select the action corresponding to the database that you want to restore and click View Details.

  2. Click icon to select the action corresponding to the data backup that you want to use for restoring and click Restore.

  3. In the Restore Scope section, perform the following actions:

    If you…​ Do this…​

    Want to restore only the data files

    Select All Data Files.

    Want to restore only the control files

    Select Control Files

    Want to restore both data files and control files

    Select All Data Files and Control Files.

    Note Restore of datafiles with control files or only control files are not supported for iSCSI on ASM layout.

    You can also select Force in-place restore checkbox.

    The Force in-place restore option overrides the spfile, password file, and archive log files from the data files diskgroup. You should use the latest backup when Force in-place restore option is selected.

  4. In the Recovery Scope section, perform the following actions:

    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 System Change Number and specify the SCN.

    Want to recover to a specific date and time

    Select Date and Time.

    Do not want to recover

    Select No recovery.

    For the selected recovery scope, in the Archive Log Files Locations field you can optionally specify the location that contains the archive logs required for recovery.

    Select the check box if you want to open the database in READ-WRITE mode after recovery.

  5. Click Next and review the details.

  6. Click Restore.