ORA-16053: DB_UNIQUE_NAME is not in the Data Guard Configuration
PURPOSE: All documents are provided on this Blog just for educational purposes only. Please make sure that you run it in your test environment before to move on to production environment.
SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=+DATA VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=EDUDB01';
SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=+DATA VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=EDUDB01';
alter system set
LOG_ARCHIVE_DEST_1='LOCATION=+DATA VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=EDUDB01'
*
ERROR at line 1:
ORA-02097: parameter cannot be
modified because specified value is invalid
ORA-16053: DB_UNIQUE_NAME EDUDB01 is
not in the Data Guard Configuration
SOLUTION:
srvctl remove database -d edudb
srvctl add database -d EDUDB01
-oraclehome /oracle19c/product/19.6.0.0/db
srvctl modify database -d EDUDB01
-oraclehome /oracle19c/product/19.6.0.0/db -p
+DATA/EDUDB/PARAMETERFILE/spfile.270.1034096743
srvctl config database -d EDUDB01
alter system set db_unique_name=xxx
scope=spfile;
Done:
