I am trying to restore one table for a Oracle RAC db (11.2 on Unix).
Backup runs fine, with no errors, but the following message appears:
ORACLE_SID Specified in GUI [inteli1] and actual ORACLE_SID [inteli2] differ. Offline Backup with Lights-out script may not be successful.
I understand that something in my configuration is causing this since I have:
- 2 rack nodes (node1 and node2)
- 1 racdb named inteli
- 1 instance of inteli on each RAC node (inteli1 and inteli2)
But, I was not very concerned because I am not testing offline backups. So I proceed with the table restore test.
During the restore, the job became pending with the following message:
Oracle Instance Name specified in ContentStore [inteli1] and connected Oracle Instance [inteli2] are different. Please rename the instance in ContentStore to match with Connected Oracle Instance.
So, I have three questions:
1 - Should I proceed with that rename in the ContentStore? How? (I understand this as a workaround)
2 - What could be wrong in my config that causes that?
3 - What should be done in order for the backup/restore operations to deal with RAC DBs with multiple instances (apparently this is the issue)?