已索引

启用/停止日志传输（主库上操作）

broker

DGMGRL> EDIT DATABASE demodb SET STATE=TRANSPORT-ON;
DGMGRL> EDIT DATABASE demodb SET STATE=TRANSPORT-OFF;

SQL

SQL> alter system set log_archive_dest_state_2=enable sid='*';
SQL> alter system set log_archive_dest_state_2=defer sid='*';

在 19C 中，broker 后端是将值改为 RESET。
defer：Specifies that valid destination information and attributes are preserved, but the destination is excluded from archiving operations until reenabled.
reset：Functions the same as defer, but clears any error messages for the destination if it had previously failed.

启用/停止日志应用（备库上操作）

broker

DGMGRL> EDIT DATABASE 'demodbstd' SET STATE='APPLY-ON';
DGMGRL> EDIT DATABASE 'demodbstd' SET STATE='APPLY-OFF';

SQL

alter database recover managed standby database using current logfile disconnect from session;
alter database recover managed standby database cancel;