SID and database name in oracle
Dear Experts,
Can we have different instance name and database name in single node (non-rac) environment.
This questions rises when we restore 2 node rac to single node server using Data Protector tool. They say target and source SID should be same.
Source 2 NODE rac
prodcdb1 and prodcdb2 are sid and prodcdb is database name.
Target single node ->they said to give sid as prodcdb2. When we give prodcdb2 as sid,then database name will also be prodcdb2 right? Please correct.
Thanks,
SG