Skip to main content
SnapManager Oracle

Performing a rollback on a single host or multiple hosts

Contributors

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

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

  1. To perform a rollback on a single host, enter the following command: smorepository rollback-repository-dbnamerepo_service_name-hostrepo_host-login-usernamerepo_username-portrepo_port-rollbackhosthost_with_target_database

    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:

    smo 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: smorepository rollback-repository-dbnamerepo_service_name-hostrepo_host-login-usernamerepo_username-portrepo_port-rollbackhosthost_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.

    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:

    smo 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.

Related information