Skip to main content
SnapManager for SAP

Perform a rollback on a single host or multiple hosts

Contributors
PDFs

You can perform a rollback on a single or multiple SnapManager server hosts by using the command-line interface (CLI).

What you'll need

You must ensure that all the prerequisites for performing a rollback are complete.

Steps

  1. To perform a rollback on a single host, enter the following command:

    smsaprepository rollback-repository-dbname repo_service_name -host repo_host -login -username repo_username -port repo_port -rollbackhost host_with_target_database

    Example

    The following example shows the command to roll back all the target databases that are mounted on hostA and a repository database named repoA located on the repository host, repo_host:

    smsap repository rollback
    -repository
      -dbname repoA
      -host repo_host
      -login
       -username repouser
       -port 1521
     -rollbackhost hostA

  2. To perform a rollback on multiple hosts, enter the following command:

    smsaprepository rollback-repository-dbname repo_service_name -host repo_host -login-username repo_username -port repo_port -rollback hosthost_with_target_database1,host_with_target_database2

    Note For multiple hosts, enter the host names separated by a comma and ensure that there is no space between the comma and the next host name.

    If you are using Real Application Clusters (RAC) configuration, you must manually roll back all RAC-associated hosts. You can use -allhosts to perform a rollback of all the hosts.

    Example

    The following example shows the command to roll back all the target databases that are mounted on the hosts, hostA, hostB, and a repository database named repoA located on the repository host, repo_host:

    smsap repository rollback
    -repository
      -dbname repoA
      -host repo_host
      -login
       -username repouser
       -port 1521
     -rollbackhost hostA,hostB

    The hosts, profiles, schedules, backups, and clones that are associated with the profiles of the target databases for the host are reverted to the earlier repository.