Restore and recover Oracle databases using UNIX commands

Contributors netapp-soumikd netapp-asubhas Download PDF of this page

The restore and recovery workflow includes planning, performing the restore and recovery operations, and monitoring the operations.

About this task

You should execute the following commands to establish the connection with the SnapCenter Server, list the backups and retrieve its information, and restore the backup.

The information regarding the parameters that can be used with the command and their descriptions can be obtained by running Get-Help command_name. Alternatively, you can also refer to the SnapCenter Software Command Reference Guide.

Steps

  1. Initiate a connection session with the SnapCenter Server for a specified user: Open-SmConnection

  2. Retrieve the information about the backups that you want to restore: Get-SmBackup

  3. Retrieve the detailed information about the specified backup: Get-SmBackupDetails

    This command retrieves the detailed information about the backup of a specified resource with a given backup ID. The information includes database name, version, home, start and end SCN, tablespaces, pluggable databases, and its tablespaces.

  4. Restore data from the backup: Restore-SmBackup