Oracle 10g Data Guard 环境缺少log_archive_config 参数导致归档路径被禁用

Oracle 10g Data Guard的一个主要特点就是引入了log_archive_config参数，如果缺少这个参数，可能会导致归档路径被禁用。实验过程：当前是一个已经配置好的Data Guard，为了模拟错误，先将这个参数设置为空：SQL> alter system set log_archive_config = "";System altered.SQL> alter system switch logfile;System altered.SQL> show parameter log_archive_dest_2NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string      SERVICE=standby LGWR SYNC VALI
                                                 D_FOR=（ONLINE_LOGFILES,PRIMARY _ROLE） DB_UNIQUE_NAME=standbySQL> alter system set log_archive_dest_2 = "SERVICE=standby ARCH ASYNC VALID_FOR=（ONLINE_LOGFILES,PRIMARY_ROLE） DB_UNIQUE_NAME=standby";System altered.SQL> alter system switch logfile;System altered.观察日志切换后，alert文件中并没有任何的错误，包含重新设置log_archive_dest_2参数后再次执行切换日志，alert文件中仍然看不到预期的错误。导致问题无法重现的原因可能是由于系统中已经设置过log_archive_config参数，虽然现在已经置为空，但是这个参数的生效可能会一直保留，于是尝试重启数据库。SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 2147483648 bytes
Fixed Size                  2074112 bytes
Variable Size             486541824 bytes
Database Buffers         1644167168 bytes
Redo Buffers               14700544 bytes
Database mounted.Database opened.
SQL> alter system switch logfile;System altered.SQL> alter system set log_archive_dest_2 = "SERVICE=standby LGWR ASYNC VALID_FOR=（ONLINE_LOGFILES,PRIMARY_ROLE） DB_UNIQUE_NAME=standby";System altered.SQL> alter system switch logfile;System altered.观察alert日志，这时从alert文件中可以看到预期的错误：Thu Dec 23 21:42:48 2010Completed: ALTER DATABASE OPEN
Thu Dec 23 21:42:51 2010Thread 1 advanced to log sequence 11Current log# 2 seq# 11 mem# 0: /data/oradata/primary/redo02.logThu Dec 23 21:42:51 2010
Errors in file /opt/ora10g/admin/primary/bdump/primary_arc1_18406.trc:
ORA-16057: DGID from server not in Data Guard configuration
Thu Dec 23 21:42:51 2010
FAL[server, ARC1]: Error 16057 creating remote archivelog file "standby"FAL[server, ARC1]: FAL archive failed, see trace file.
Thu Dec 23 21:42:51 2010
Errors in file /opt/ora10g/admin/primary/bdump/primary_arc1_18406.trc:ORA-16055: FAL request rejectedARCH: FAL archive failed. Archiver continuing
Thu Dec 23 21:42:51 2010
ORACLE Instance primary - Archival Error. Archiver continuing.Thu Dec 23 21:43:46 2010Shutting down archive processes
Thu Dec 23 21:43:51 2010ARCH shutting downARC2: Archival stoppedThu Dec 23 21:45:10 2010
ALTER SYSTEM SET log_archive_dest_2="SERVICE=standby LGWR ASYNC VALID_FOR=（ONLINE_LOGFILES,PRIMARY_ROLE） DB_UNIQUE_NAME=standby" SCOPE=BOTH;LNS1 started with pid=18, OS id=18425
Thu Dec 23 21:45:29 2010
Thread 1 advanced to log sequence 12Current log# 3 seq# 12 mem# 0: /data/oradata/primary/redo03.logThu Dec 23 21:45:29 2010
Errors in file /opt/ora10g/admin/primary/bdump/primary_arc1_18406.trc:ORA-16057: DGID from server not in Data Guard configuration
Thu Dec 23 21:45:29 2010FAL[server, ARC1]: Error 16057 creating remote archivelog file "standby"
FAL[server, ARC1]: FAL archive failed, see trace file.Thu Dec 23 21:45:29 2010
Errors in file /opt/ora10g/admin/primary/bdump/primary_arc1_18406.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Thu Dec 23 21:45:29 2010
ORACLE Instance primary - Archival Error. Archiver continuing.
Thu Dec 23 21:50:51 2010
Errors in file /opt/ora10g/admin/primary/bdump/primary_arc1_18406.trc:ORA-16057: DGID from server not in Data Guard configurationThu Dec 23 21:50:51 2010
PING[ARC1]: Heartbeat failed to connect to standby "standby". Error is 16057.
Thu Dec 23 21:55:51 2010Errors in file /opt/ora10g/admin/primary/bdump/primary_arc1_18406.trc:ORA-16057: DGID from server not in Data Guard configurationThu Dec 23 21:55:51 2010
PING[ARC1]: Heartbeat failed to connect to standby "standby". Error is 16057.Thu Dec 23 22:00:51 2010Errors in file /opt/ora10g/admin/primary/bdump/primary_arc1_18406.trc:ORA-16057: DGID from server not in Data Guard configuration
Thu Dec 23 22:00:51 2010
PING[ARC1]: Heartbeat failed to connect to standby "standby". Error is 16057.错误信息很明确ORA-16057，说明当前的SERVICE归档设置的主机没有包括在DATA GUARD配置中。将log_archive_config参数添加回来：SQL> alter system set log_archive_config = "DG_CONFIG=（primary,standby）";System altered.SQL> alter system switch logfile;System altered.观察alert日志文件：Thu Dec 23 22:05:29 2010
ALTER SYSTEM SET log_archive_config="DG_CONFIG=（primary,standby）" SCOPE=BOTH;
Thu Dec 23 22:05:40 2010Thread 1 advanced to log sequence 13
  Current log# 1 seq# 13 mem# 0: /data/oradata/primary/redo01.log
Thu Dec 23 22:05:40 2010
ARC0: Archivelog destination LOG_ARCHIVE_DEST_2 disabled: destination Data Guard configuration error

Catalog下的RMAN增量备份SHELL脚本Oracle AWR报告生成与查看相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（1）

评论声明