3.4.5 Using the Same DB_UNIQUE_NAME for Multiple Database Instances

You can create database instances that use the same DB_UNIQUE_NAME value if the databases are associated with separate Oracle ASM clusters.

Starting with Oracle Exadata System Software release 19.1.0, multiple Oracle databases sharing the same Oracle ASM storage can use the same DB_UNIQUE_NAME.

WARNING:

If you configure databases to have the same DB_UNIQUE_NAME, then those databases cannot be backed up to Oracle Zero Data Loss Recovery Appliance.

To use the same DB_UNIQUE_NAME across multiple Oracle databases you must:

  • Use separate Oracle ASM clusters for the databases using the same DB_UNIQUE_NAME value. The Oracle ASM cluster name is used to qualify the DB_UNIQUE_NAME in I/O Resource Management (IORM), Exadata Smart Flash Cache, and Exadata Smart Scan Offload operations.

  • Implement ASM-scoped security for each Oracle ASM cluster that contains the databases using the same DB_UNIQUE_NAME value.