Backing up Oracle databases using Linux commands

The backup workflow includes planning, identifying the resources for backup, creating backup policies, creating resource groups and attaching policies, creating backups, and monitoring the operations.

Before you begin

About this task

You must execute the following commands to establish the connection with the SnapCenter Server, discover the Oracle database instances, add policy and resource group, backup and verify the backup.

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

SnapCenter Software 4.2 Linux Command Reference Guide

Steps

  1. Initiate a connection session with the SnapCenter Server for a specified user: Open-SmConnection
  2. Perform host resources discovery operation: Get-SmResources
  3. Configure Oracle database credentials and preferred nodes for backup operation of a Real Application Cluster (RAC) database: Configure-SmOracleDatabase
  4. Create a backup policy: Add-SmPolicy
  5. Retrieve the information about the secondary (SnapVault or SnapMirror) storage location : Get-SmSecondaryDetails
    This command retrieves the primary to secondary storage mapping details of a specified resource. You can use the mapping details to configure the secondary verification settings while creating a backup resource group.
  6. Add a resource group to SnapCenter: Add-SmResourceGroup
  7. Create a backup: New-SmBackup.
    You can poll the job using the WaitForCompletion option. If this option is specified, then the command continues to poll the server until the completion of the backup job.
  8. Retrieve the logs from SnapCenter: Get-SmLogs