How to fix the Oracle error RMAN-20223: DB_UNIQUE_NAME mismatch in snapshot control file?

In this post, you’ll learn more about the Oracle ErrorRMAN-20223: DB_UNIQUE_NAME mismatch in snapshot control file with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-20223: DB_UNIQUE_NAME mismatch in snapshot control file

Reason for the Error RMAN-20223: DB_UNIQUE_NAME mismatch in snapshot control file

The DB_UNIQUE_NAME value in the snapshot control file was incorrect. This error can occur in Oracle RAC when the snapshot control file location is not shared across nodes and virtual IPs are setup in the remote database from where resynchronization is done using RESYNC CATALOG FROM DB_UNIQUE_NAME commnad.

How to fix the Error RMAN-20223: DB_UNIQUE_NAME mismatch in snapshot control file ?

You can fix this error in Oracle by following the below steps

To avoid this error, one of the following actions can be taken: 1) Share the control file snapshot location. The snapshot location can be displayed by executing SHOW SNAPSHOT CONTROLFILE NAME at the RMAN prompt. 2) Do not use Virtual IPs in the service name used to define the connect identifiers. The connect identifiers can be displayed using SHOW DB_UNIQUE_NAME command at the RMAN prompt.