dataguard – OracleBlog

令人误解的ORA-16047: DGID mismatch between destination setting and target database

2017-06-29 没有评论

今天为一个Rac onenode的主库搭建好一个dg库之后，一直没有传日志，在主库的alertlog中，有报错：

Thu Jun 29 14:55:34 2017
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;
Thu Jun 29 14:55:44 2017
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Thu Jun 29 14:55:44 2017
Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:
ORA-16047: DGID mismatch between destination setting and target database
Thu Jun 29 14:55:44 2017
Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:
ORA-16047: DGID mismatch between destination setting and target database
Thu Jun 29 14:55:44 2017
Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:
ORA-16047: DGID mismatch between destination setting and target database
Thu Jun 29 14:55:45 2017
Thread 2 advanced to log sequence 632 (LGWR switch)
  Current log# 7 seq# 632 mem# 0: +DATA/PAYROLL/ONLINELOG/group_7.303.946836271
  Current log# 7 seq# 632 mem# 1: +FRA/PAYROLL/ONLINELOG/group_7.791.946836271
Thu Jun 29 14:55:45 2017

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

Thu Jun 29 14:55:34 2017

ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;

Thu Jun 29 14:55:44 2017

ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;

Thu Jun 29 14:55:44 2017

Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:

ORA-16047: DGID mismatch between destination setting and target database

Thu Jun 29 14:55:44 2017

Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:

ORA-16047: DGID mismatch between destination setting and target database

Thu Jun 29 14:55:44 2017

Errors in file /data/prd/oracle/diag/rdbms/payroll/payroll_2/trace/payroll_2_tt00_27554.trc:

ORA-16047: DGID mismatch between destination setting and target database

Thu Jun 29 14:55:45 2017

Thread 2 advanced to log sequence 632 (LGWR switch)

Current log# 7 seq# 632 mem# 0: +DATA/PAYROLL/ONLINELOG/group_7.303.946836271

Current log# 7 seq# 632 mem# 1: +FRA/PAYROLL/ONLINELOG/group_7.791.946836271

Thu Jun 29 14:55:45 2017

根据oerr的报错信息：

SQL> !oerr ora 16047
16047, 00000, "DGID mismatch between destination setting and target database"
// *Cause:  The DB_UNIQUE_NAME specified for the destination did not match
//          the DB_UNIQUE_NAME at the target database.
// *Action: Make sure the DB_UNIQUE_NAME specified in the LOG_ARCHIVE_DEST_n
//          parameter matches the DB_UNIQUE_NAME parameter defined at the
//          destination.

SQL>

1

2

3

4

5

6

7

8

9

SQL> !oerr ora 16047

16047, 00000, "DGID mismatch between destination setting and target database"

// *Cause: The DB_UNIQUE_NAME specified for the destination did not match

// the DB_UNIQUE_NAME at the target database.

// *Action: Make sure the DB_UNIQUE_NAME specified in the LOG_ARCHIVE_DEST_n

// parameter matches the DB_UNIQUE_NAME parameter defined at the

// destination.

SQL>

检查了主库和备库的db_un […]

..experience, Working case

在阿里云上创建dataguard+FSFO

2017-05-14 没有评论

在阿里云上创建rac或者rac onenode，共享存储比较麻烦，需要配iSCSI，我们可以用dataguard+fsfo架构来类似的实现高可用方案。本文介绍了在阿里云上oracle 12.1.0.2 dataguard+fsfo的搭建过程。（一）、基础工作序列：阿里云上创建Oracle […]

..experience, Working case

dataguard不传输日志的问题

2017-03-12 没有评论

搭建一个两地三中心的dataguard，主库，本地dg已经搭建好，一直工作正常。但是在搭建一个远程dg的时候，收到告警说，主库和本地dg的同步已经断了好几个小时。难道我搭建远程dg库，对主库有影响？于是进行分析。找到了初步的原因，是因为在搭建远程dg的时候，需要修改主库的log_archive_c […]

..experience, Working case

一次dataguard坏块的修复

2016-11-18 3条评论

客户有个11g的active dataguard库，mrp进程停了，看alertlog，可以看到有关ora-7445[kdxlin]的报错：

cat alert*.log
....
Exception [type:SIGSEOV,Address not mapped to object] [ADDR:0xC] |PC：0x96504C7,kdxlin()+4153][flags: 0x0,count:1]
Errors in le /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/trace/partsm_pr18_21343.trc (incident=70353):
ORA-07445: exception encountered: core dump (kdxlin()+4153) [SIGSEGV] [ADDR:0xC] |PC:0x96504C7][Address not mapped to object][]
Incident details in: /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc
Use ADRCI or Support Workbench to package the incident.

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xC][PC:0x96504C7,kdxlin()+4153][flags:0XO,count:1]
Incidenl 70353 created, dump file/aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc
ORA-07445: exception encountered: core dump (kdxlin()+4153) [SIGSEGV] [ADDR:0xC] |PC:0x96504C7][Address not mapped to object][]
...

1

2

3

4

5

6

7

8

9

10

11

12

cat alert*.log

....

Exception [type:SIGSEOV,Address not mapped to object] [ADDR:0xC] |PC：0x96504C7,kdxlin()+4153][flags: 0x0,count:1]

Errors in le /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/trace/partsm_pr18_21343.trc (incident=70353):

ORA-07445: exception encountered: core dump (kdxlin()+4153) [SIGSEGV] [ADDR:0xC] |PC:0x96504C7][Address not mapped to object][]

Incident details in: /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc

Use ADRCI or Support Workbench to package the incident.

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xC][PC:0x96504C7,kdxlin()+4153][flags:0XO,count:1]

Incidenl 70353 created, dump file/aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc

ORA-07445: exception encountered: core dump (kdxlin()+4153) [SIGSEGV] [ADDR:0xC] |PC:0x96504C7][Address not mapped to object][]

...

cat /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc
...
Error 607 in redo applicalion callback
Dump of change vector
Typ:2 CLS:1 APN:5 DBA0x2598d645 OBJ:3S3792 SCN:0x0960.99d2655e SEQ:1 OP:10.2 ENC:0 RBL:0
index redo(kdxlin):insert leaf row
KTB Redo
op:0x01 ver:0x01
compat bit:4(post-11) padding:1
op:F xid:0x0001.01a.010d8f34 uba:0x00dc8e3.6bf5.20
REDO: SINGLE/NONKEY/--
itl:3, sno:255, row size 23
insert key:(14):05 c4 02 4e 31 4f 07 78 74 0b 09 11 27 29
nonkey (length: 5):
fb: --H-FL-- lb:0x0 cc:1
(2).01 80
Block after image is corrupt:
buffer tsn: 5 rdba:0x2598d645(1024/630773317)
scn:0x960.99d10d33 seq:0x01 flg:0x04 tail:0x0d330601
frmt:0x02 chkval:0xa1ae type:0x06=trans data
Hex dump of currupt header 3=CHKVAL
...

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

cat /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc

...

Error 607 in redo applicalion callback

Dump of change vector

Typ:2 CLS:1 APN:5 DBA0x2598d645 OBJ:3S3792 SCN:0x0960.99d2655e SEQ:1 OP:10.2 ENC:0 RBL:0

index redo(kdxlin):insert leaf row

KTB Redo

op:0x01 ver:0x01

compat bit:4(post-11) padding:1

op:F xid:0x0001.01a.010d8f34 uba:0x00dc8e3.6bf5.20

REDO: SINGLE/NONKEY/--

itl:3, sno:255, row size 23

insert key:(14):05 c4 02 4e 31 4f 07 78 74 0b 09 11 27 29

nonkey (length: 5):

fb: --H-FL-- lb:0x0 cc:1

(2).01 80

Block after image is corrupt:

buffer tsn: 5 rdba:0x2598d645(1024/630773317)

scn:0x960.99d10d33 seq:0x01 flg:0x04 tail:0x0d330601

frmt:0x02 chkval:0xa1ae type:0x06=trans data

Hex dump of currupt header 3=CHKVAL

...

从trace中，我们可以看 […]

..experience, Working case

另类解决dataguard的BAD PARAM ORA-16053

2016-09-24 没有评论

有一个库，在主库添加了一个tora10g的配置，发现原来已经存在的rora10g和lora10g都发生了异常，不再继续传日志。检查v$archive_dest显示status为BAD PARAM，error为：ORA-16053 DB_UNIQUE_NAME is not in the Data G […]

..experience, Working case

12c的Data guard中将废弃使用using current logfile

2016-06-12 没有评论

问题起源于客户的一个12c的数据库，需要启动到非real time apply的模式，但是发现执行： alter database recover managed standby database cancel; alter database recover managed standby data […]

..experience, Working case

DG备库遭遇ORA-16146的bug

2010-11-05 一条评论

今天收到监控的一个告警：

ORA-16146: standby destination control file enqueue unavailable

1	ORA-16146: standby destination control file enqueue unavailable

登录主库和备库检查其报错信息：备库上的alertlog：

Media Recovery Waiting for thread 1 seq# 2506
Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2506.arc
Wed Oct 27 20:30:24 2010
Media Recovery Waiting for thread 1 seq# 2507
Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2507.arc
Thu Oct 28 00:13:35 2010
Media Recovery Waiting for thread 1 seq# 2508
Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2508.arc
Thu Oct 28 01:24:57 2010
RFS: controlfile enqueue unavailable
Possible invalid cross-instance archival configuration
Thu Oct 28 01:25:00 2010
Errors in file /oracle_log/JPJDE/admin/udump/jpjde_rfs_1331404.trc:
ORA-16146: standby destination control file enqueue unavailable
Thu Oct 28 01:44:42 2010
RFS: Error State mode '2'
Thu Oct 28 01:45:31 2010
Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2509.arc
Thu Oct 28 01:46:53 2010
RFS: Forced Shutdown due to RFS_ERROR state
Thu Oct 28 01:50:33 2010
Media Recovery Waiting for thread 1 seq# 2510 (in transit)
Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2510.arc
Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2511.arc
Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2512.arc
Thu Oct 28 02:11:34 2010
Media Recovery Waiting for thread 1 seq# 2513
Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2513.arc

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

Media Recovery Waiting for thread 1 seq# 2506

Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2506.arc

Wed Oct 27 20:30:24 2010

Media Recovery Waiting for thread 1 seq# 2507

Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2507.arc

Thu Oct 28 00:13:35 2010

Media Recovery Waiting for thread 1 seq# 2508

Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2508.arc

Thu Oct 28 01:24:57 2010

RFS: controlfile enqueue unavailable

Possible invalid cross-instance archival configuration

Thu Oct 28 01:25:00 2010

Errors in file /oracle_log/JPJDE/admin/udump/jpjde_rfs_1331404.trc:

ORA-16146: standby destination control file enqueue unavailable

Thu Oct 28 01:44:42 2010

RFS: Error State mode '2'

Thu Oct 28 01:45:31 2010

Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2509.arc

Thu Oct 28 01:46:53 2010

RFS: Forced Shutdown due to RFS_ERROR state

Thu Oct 28 01:50:33 2010

Media Recovery Waiting for thread 1 seq# 2510 (in transit)

Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2510.arc

Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2511.arc

Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2512.arc

Thu Oct 28 02:11:34 2010

Media Recovery Waiting for thread 1 seq# 2513

Media Recovery Log /oracle_log/JPJDE/arch_logs/stby_1_2513.arc

对应同一时间，主库上的信息： [crayon-676e31e602b3a06915 […]

..oracle service, Working case

跨平台的DATAGUARD组合列表

2009-06-22 一条评论

oracle允许在同一个oracle platform下安装dataguard，要求尽量的同样的操作系统版本。 oracle platform可以用以下的语句查看（9i的v$database没有PLATFORM_ID和PLATFORM_NAME字段）： [crayon-676e31e60405502 […]

..unix shell, Useful script

定期删除DG归档日志的脚本

2008-01-19 3条评论

Dataguard的维护稍微麻烦点，不能删除尚未applied的归档日志，但是每次手工去核对就比较麻烦了，今天在pub上看到这样一个要求：“哪位有 standby数据库定期删除已经apply的archive的shell脚本？”于是就写了个脚本，基本可以满足题目的要求： 1、已经在standby库a […]

..experience, Working case

关于rman建DG的tempfile

2008-01-16 没有评论

用rman建dataguard之后，在备库的机器上是没有tempfile文件的，因此我们在switchover之后，需要让备库作为primary顶一段时间，需要有tempfile来进行排序操作。那么，我们怎么给备库加tempfile呢？在这里需要注意的是，由于数据库没有tempfile也能启动，因 […]

Study note

基于数据文件的rman建DG

2008-01-16 没有评论

前段时间，itpub上有朋友问“小弟仔细想了想发现一个问题：dataguard的空间不足以容下一份rman备份和数据文件．这样就只能停机做了吗？？”。在主机空间不够的情况下，我们可以用rman一个数据文件一个数据文件的做dataguard。今天把基于数据文件的rman建datagurard操作了一下 […]

Study note

Dataguard启动的各个阶段

2008-01-12 一条评论

主库启动instance和lsnr，在备库启动lsnr后，在dg启动的各个阶段，dg都做了什么呢：启动了那些进程？什么时候会传归档？什么时候开始应用归档？ 1.备库关闭时。 1.1 检查备库进程：

[oracle@standby1 arch]$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 11 23:52:25 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.


> 
> !ps -ef |grep ora_
oracle    3917  3915  0 23:52 pts/1    00:00:00 /bin/bash -c ps -ef |grep ora_
oracle    3919  3917  0 23:52 pts/1    00:00:00 grep ora_

1

2

3

4

5

6

7

8

9

10

11

12

13

[oracle@standby1 arch]$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 11 23:52:25 2008

Connected to an idle instance.

>

> !ps -ef |grep ora_

oracle 3917 3915 0 23:52 pts/1 00:00:00 /bin/bash -c ps -ef |grep ora_

oracle 3919 3917 0 23:52 pts/1 00:00:00 grep ora_

1.2 备库arch目录： [cra […]