Oracle 19C Dataguard Broker新特性

在Oracle 19c中dg broker有如下新特性：
1、支持导出导入配置文件
[code]DGMGRL> help export

Export Data Guard Broker configuration to a file.

Syntax:

EXPORT CONFIGURATION [TO <file_name>];

DGMGRL> help import

Import Data Guard Broker configuration from a file.

Syntax:

IMPORT CONFIGURATION FROM <file_name>;[/code]
2、查询所有配置的LAG
[code]DGMGRL> SHOW CONFIGURATION lag;

Configuration - csdg

Protection Mode: MaxPerformance
Members:
cs19c - Primary database
cs19cdg - Physical standby database
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)

Fast-Start Failover: Disabled

Configuration Status:
SUCCESS (status updated 40 seconds ago)[/code]
3、设置数据库PFILE
[code]EDIT INSTANCE <instance name> [ON { DATABASE | FAR_SYNC } <object name>]
SET AUTO PFILE [ = {<initialization file path> | OFF} ];

EDIT { RECOVERY_APPLIANCE | DATABASE | FAR_SYNC | MEMBER }
<object name> SET PARAMETER <parameter name> = <value>
[ <initialization parameter options> ];[/code]
4、TRACE_LEVEL取代DEBUG
[code]SET TRACE_LEVEL { SUPPORT | USER | NONE };[/code]
5、fast-start failover支持observer-only模式
[code]ENABLE FAST_START FAILOVER [OBSERVE ONLY];

DGMGRL> help stop

Stops the fast-start failover observer

Syntax:

STOP OBSERVER [<observer name> | ALL];

STOP OBSERVING [<configuration group name>];

DGMGRL> help start

Starts the fast-start failover observer

Syntax:

START OBSERVER [FILE=<observer file>];

START OBSERVER [<observer name>]
[FILE IS <observer file>]
[LOGFILE IS <observer log file>]
[TRACE_LEVEL IS { USER | SUPPORT }];

START OBSERVER [<observer name>]
IN BACKGROUND
[FILE IS <observer file>]
[LOGFILE IS <observer log file>]
CONNECT IDENTIFIER IS <connect identifier>
[TRACE_LEVEL IS { USER | SUPPORT }];

START OBSERVING [<configuration group name>]
[TRACE_LEVEL IS { USER | SUPPORT }];

DGMGRL> [/code]
6、增加ArchiveLocation配置
[code]DGMGRL> edit database cs19c reset property ArchiveLocation;
Property "archivelocation" updated
DGMGRL> [/code]

7、 动态改变FSFO目标
[code]SET FAST_START FAILOVER TARGET TO <database name> [NOWAIT];[/code]