Description:-
- Oracle 19c New Features for data guard broker
- New commands are available to set, modify, and display the value of database initialization parameters in a database, far sync instance, or Recovery Appliance. Values set using these commands are directly applied to the database and are not stored in the broker configuration file. The new commands are as follows:
EDIT DATABASE (Parameter)
EDIT DATABASE RESET (Parameter)
SET TRACE_LEVEL
- The database must be available when this command is run.
- SCOPE: Set one of the following values for scope: SPFILE, MEMORY, or BOTH. The default value is BOTH. If the specified parameter is a static parameter, then set SCOPE= SPFILE.
- SID: Specify the name of a database instance for which the parameter must be set. If the specified parameter must be set for all instances, set SID=’*’.
Example:-
EDIT DATABASE (Parameter)
DGMGRL> EDIT DATABASE ‘chennai’ SET PARAMETER log_archive_trace = 1 ‘SCOPE = Both’;
Parameter “log_archive_trace” updated
EDIT DATABASE RESET (Parameter)
DGMGRL> EDIT DATABASE ‘chennai’ RESET PARAMETER log_archive_trace;
Parameter “log_archive_trace” reset
SET TRACE_LEVEL
DGMGRL> show all
trace_level USER
echo OFF
time OFF
observerconfigfile = observer.ora
Set trace level to USER to limit the amount of tracing information stored. This is the default setting and includes information about fast-start failover, status changes of the primary and target standby database, and error or warning messages.
Set trace level to SUPPORT to increase the amount of tracing information to include lower-level information needed by Oracle Support Services.
DGMGRL> SET TRACE_LEVEL SUPPORT;
DGMGRL> show all
trace_level SUPPORT
echo OFF
time OFF
observerconfigfile = observer.ora
DGMGRL> START OBSERVER TRACE_LEVEL is USER;
Replaces the DEBUG qualifier in Oracle Database 18c starting with 19c
SHOW ALL changes to display the TRACE_LEVEL instead of DEBUG
EDIT DATABASE (Property)
Set database initialization parameters
Oracle Data Guard broker properties, now map to Database Parameters
The name of an existing database-specific property. If this is an Oracle RAC database, this property change affects all instances of the database.
The database must be active.
If you are connecting to a remote database, the connection must not be established using operating system authentication.
The following conditions apply when updating the value of the properties
ArchiveLagTarget
DataGuardSyncLatency
LogArchiveMaxProcesses
LogArchiveMinSucceedDest
LogArchiveTrace
StandbyFileManagement
DbFileNameConvert
LogArchiveFormat
LogFileNameConvert
Connect with me:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/hariprasathdba
