Update the target database host name associated with a profile

Contributors

SnapManager (3.2 or later) for SAP provides the ability to update the host name of the target database in the SnapManager profile.

What you’ll need

  • The local user’s home directory must be aware of the profile-to-repository mappings.

  • The SnapManager graphical user interface (GUI) sessions must be closed.

About this task

You can update the profile with the new host name by using only the CLI.

Scenarios not supported for changing the target database host name in profile

The following scenarios not supported for changing the target database host name in the profile:

  • Changing the target database host name by using the SnapManager GUI

  • Rolling back of the repository database after updating the target database host name of the profile

  • Updating multiple profiles for a new target database host name by running a single command

  • Changing the target database host name when any SnapManager operation is running

Note After you update the target database host name in the profile, only the target database host name is changed. All the other configuration parameters set on the profile are retained.

After you update the target database host name, you cannot delete or unmount the backup if the clone or mounted backup is not available in the new host. In such scenarios, running the SnapManager operations from the new host lead to failure as well as stale entries in the earlier host. To perform SnapManager operations, you must revert to the earlier host name by using profile update.

Steps
  1. Enter the following command:

    smsap profile update -profile profile [-profile-password profile_password][-database -dbname db_dbname -host db_host [-sid db_sid] [-login-username db_username -password db_password -port db_port]] [{-rman{-controlfile | {-login-username rman_username -password rman_password -tnsname rman_tnsname}}} | -remove-rman] [-retain [-hourly [-count n] [-duration m]] [-daily [-count n] [-duration m]] [-weekly [-count n] [-duration m]] [-monthly [-count n] [-duration m]]] [-comment comment][-snapname-pattern pattern][-summary-notification] [-notification [-success -email email_address1, email_address2 -subject subject_pattern] [-failure -email email_address1, email_address2 -subject subject_pattern]] [-separate-archivelog-backups-retain-archivelog-backups -hours hours | -days days | -weeks weeks| -months months [-protect [-include-with-online-backups | -no-include-with-online-backups]] [-dump]

    Other options for this command are as follows:

    [-force] [-noprompt]

    [quiet | -verbose]

    If you want to…​ Then…​

    Change the target database host name

    Specify -host new_db_host

  2. To view the target database host name of the profile, enter the following command:

    smsap profile show