Init parameterData Guard

DB_UNIQUE_NAME

What it controls

A name that's unique to each database in a Data Guard configuration, used by the broker, services and file naming.

Know this before you change it

Set it when creating the standby. Changing it later affects OMF paths and the broker configuration.

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'db_unique_name';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'db_unique_name' AND isspecified = 'TRUE';8 9-- Static: saved in the spfile, takes effect after a restart10ALTER SYSTEM SET db_unique_name = 'ORCLSTBY' SCOPE = SPFILE SID = '*';

Open in the parameter referenceOracle's reference

More in Data Guard

• DG_BROKER_STARTStarts the Data Guard broker process (DMON).
• LOG_ARCHIVE_CONFIGThe DB_UNIQUE_NAMEs of every database in the Data Guard configuration.
• FAL_SERVERNet service names a standby asks for missing archived logs.
• STANDBY_FILE_MANAGEMENTWhether datafiles added on the primary are created automatically on the standby.