Unable to restore RAC database from one of the RAC nodes where the profile was not created

Contributors Download PDF of this page

In an Oracle RAC environment where both nodes belong to the same cluster, if you attempt a restore operation from a node which is different from the node where the backup was created, the restore operation fails.

For example, if you create a backup in Node A and try to restore from Node B, the restore operation fails.

What to do

Before performing restore operation from node B, perform the following in node B:

  1. Add the repository.

  2. Sync the profile by running the command smo profile sync.

  3. Set the credential for the profile to be used for restore operation by running the command smo credential set.

  4. Update the profile to add the new host name and the corresponding SID by running the command smo profile update.