_____________________________________________________________________________________________________________________
Error Description
Dgmgrl
Create configuration command failed with following error
DGMGRL>
CREATE CONFIGURATION 'DG_Conf' AS PRIMARY DATABASE IS 'CMLPROD' CONNECT
IDENTIFIER IS 'CMLPROD';
Error: ORA-16698: LOG_ARCHIVE_DEST_n
parameter set for object to be added
Failed.
Solution Description
You have to reset the log_archive_dest_2 parameter which
is applicable to your standby database to blank before you create the
configuration through dgmgrl interface. In this example I have configured the LOG_ARCHIVE_DEST_2 for the first standby database.
SQL>
show parameter LOG_ARCHIVE_DEST_2
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
log_archive_dest_2 string SERVICE=CMLPROD SYNC NOAFF
IRM VALID_FOR=(ONLINE_LOGFILES
,PRIMARY_ROLE) DB_UNIQUE_NAME=
CMLPROD
SQL>
alter system set LOG_ARCHIVE_DEST_2=''
scope=both;
System
altered.
DGMGRL>
connect sys
Password:
Connected
as SYSDG.
DGMGRL>
CREATE CONFIGURATION 'DG_Conf' AS PRIMARY DATABASE IS 'CMLPROD' CONNECT
IDENTIFIER IS 'CMLPROD';
Configuration
"DG_Conf" created with primary database "CMLPROD"
The above create command internally will set the value for the
log_archive_dest_2
SQL>
show parameter LOG_ARCHIVE_DEST_2
log_archive_dest_2 string SERVICE=CMLPROD SYNC NOAFFIRM
VALID_FOR=(ONLINE_LOGFILES,PRI
MARY_ROLE)
DB_UNIQUE_NAME=ONLP
ROD
You have to make the changes to Standby side also to make the proper
working of data guard broker.
SQL>
alter system set LOG_ARCHIVE_DEST_2='' scope=both;
System
altered.
DGMGRL>
ADD DATABASE 'CMLPRODSTBY' AS CONNECT IDENTIFIER IS CMLPRODSTBY;
Database
"CMLPRODSTBY" added
DGMGRL>
show configuration;
Configuration
- DG_Conf
Protection Mode: MaxAvailability
Members:
CMLPROD
- Primary database
CMLPRODSTBY - Physical standby database
Fast-Start
Failover: DISABLED
Configuration
Status:
DISABLED
DGMGRL>
enable configuration;
Enabled.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment