RMAN-20223: DB_UNIQUE_NAME mismatch in snapshot control file

RMAN-20223: DB_UNIQUE_NAME mismatch in snapshot control file
Cause: 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.
Action: 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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:08

RMAN-20223：快照控制文件中的DB_UNIQUE_NAME不匹配,
.原因：快照控制文件中的DB_UNIQUE_NAME值不正确。当快照控制文件位置未在节点间共享，并且在使用RESYNC CATALOG FROM DB_UNIQUE_NAME commnad从中重新同步完成的远程数据库中设置虚拟IP时，可能会在Oracle RAC中出现此错误。,
.操作：为了避免此错误，可以执行以下操作之一：1）共享控制文件快照位置。可以通过在RMAN提示符处执行SHOW SNAPSHOT CONTROLFILE NAME来显示快照位置。2）不要在用于定义连接标识符的服务名称中使用虚拟IP。可以使用SHOW DB_UNIQUE_NAME命令在RMAN提示符处显示连接标识符。,
.

aiaiDBA

13718043309

010-86462881

RMAN-20223: DB_UNIQUE_NAME mismatch in snapshot control file

1 个回答

相似问题