10g DataGuard配置后,发现日志不会传递,且主库的alert中报如下错误:
Errors in file /apps/admin/tan01/bdump/tan01_lns1_4325.trc:
ORA-16057: DGID from server not in Data Guard configuration
LNS: Failed to archive log 1 thread 1 sequence 10 (16057)
查以下视图:
SQL> select dest_name,status,error from v$archive_dest
DEST_NAME STATUS ERROR
LOG_ARCHIVE_DEST_1 VALID
LOG_ARCHIVE_DEST_2 ERROR ORA-16057: DGID from server not in Data Guard configuration
LOG_ARCHIVE_DEST_3 INACTIVE
LOG_ARCHIVE_DEST_4 INACTIVE
LOG_ARCHIVE_DEST_5 INACTIVE
LOG_ARCHIVE_DEST_6 INACTIVE
LOG_ARCHIVE_DEST_7 INACTIVE
LOG_ARCHIVE_DEST_8 INACTIVE
LOG_ARCHIVE_DEST_9 INACTIVE
经检查:主库的的log_archive_config 里面没内容:修改如下:
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG = 'DG_CONFIG=(tan01,tan02)' scope=both;
修改后问题解决。
Errors in file /apps/admin/tan01/bdump/tan01_lns1_4325.trc:
ORA-16057: DGID from server not in Data Guard configuration
LNS: Failed to archive log 1 thread 1 sequence 10 (16057)
查以下视图:
SQL> select dest_name,status,error from v$archive_dest
DEST_NAME STATUS ERROR
LOG_ARCHIVE_DEST_1 VALID
LOG_ARCHIVE_DEST_2 ERROR ORA-16057: DGID from server not in Data Guard configuration
LOG_ARCHIVE_DEST_3 INACTIVE
LOG_ARCHIVE_DEST_4 INACTIVE
LOG_ARCHIVE_DEST_5 INACTIVE
LOG_ARCHIVE_DEST_6 INACTIVE
LOG_ARCHIVE_DEST_7 INACTIVE
LOG_ARCHIVE_DEST_8 INACTIVE
LOG_ARCHIVE_DEST_9 INACTIVE
经检查:主库的的log_archive_config 里面没内容:修改如下:
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG = 'DG_CONFIG=(tan01,tan02)' scope=both;
修改后问题解决。