[DataGuard] REDO 应用相关操作

1. redo 实时应用

1.1 物理备库
PDG> alter database recover managed standby database [disconnect from session] [using current logfile];
PDG> alter database recover managed standby database cancel;

1.2 逻辑备库
LDG> alter database start logical standby apply [immediate];
LDG> alter database stop logical standby apply;
LDG> alter database abort logical standby apply;


2. redo 应用延迟

2.1 设定, 单位分, 默认 30 分
PRIM> alter system set log_archive_dest_3='service=test arch valid_for ... delay=15';

2.2 忽略 redo 应用延迟

2.2.1 如果启动应用时指定实时应用, 延迟将被忽略

2.2.2 启动应用时指定 nodelay
PDG> alter database recover managed standby database nodelay;
LDG> alter database start logical standby apply nodelay;