ITPub博客

ORACLE 11G 扩展表空间增加数据文件导致DG日志应用失败SQL> select sequence#, first_time, next_time, applied from v$archived_log where applied='NO' order by sequence# ; SEQUENCE# FIRST_TIME          NEXT_TIME           APPLIED---------- ----...

DG 创建alter system set  LOG_ARCHIVE_CONFIG='DG_CONFIG=(pxdb,szpxdbdg,shpxdbdg)';alter system set  LOG_ARCHIVE_DEST_3='SERVICE=shpxdbdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=shpxdbdg';...

在DATAGUARD中手工处理日志GAP的方法SQL> select process,status from v$managed_standby;PROCESS   STATUS--------- ------------ARCH      CLOSINGARCH      CONNECTEDARCH      CONNECTEDARCH    &...