Dataguard configuration

[Roshan]

Oracle Database 12c
Linux 6.5

Hello,

I have configured dataguard on a test instance.
47.PNG

I have checked the db_unique_name for the standby database. It is ok.

Regards,

Roshan

[ErmanArslansOracleBlog]

Please write your problem with all of its details.

This is a information sharing environment. So if you don't write the problem, describe your env and etc, then who get benefit from the solution?

I see the error ORA-16047, but please use that in a sentence :) and tell me the problem in a paragraph.

So, describe your env. Explain the problem and send me all the necessary diag info (like log_archive_dest or any standby related parameters in your init ora files standby+primary)

[Roshan]

Hello,

both the primary and standby databases are in  a single instance.

Primary Database                       Physical Standby database
Red Hat Linux 6.5                        Red Hat Linux 6.5
Oracle Database 12.1.0.2.0           Oracle Database 12.1.0.2.0
ora12c                                        oracle
SID: TEST12C                             SID: boston

Primary database alert log:
alert_TEST12C.log
initTEST12C.ora

Standby database alert log
alert_boston.log
initboston.ora

Regards,

Roshan

[Roshan]

listenerboston.PNG

[ErmanArslansOracleBlog]

What is this log_archive_dest?

*.LOG_ARCHIVE_DEST_2='SERVICE=TEST12C ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston'

IT is a little bit strange becauase your primary service is also TEST12C, am I wrong?

So, if that so, it is confusing.

What do you get when you tnsping from primary
I mean -> from primary> "tnsping TEST12C" -> what does this command returns? (is it going to primary or standby?)

[ErmanArslansOracleBlog]

In addition why don't you use the service name boston there?

You have boston service available in your standby site.
Just a tns entry named boston(which points to your standby) in to your primary db server's tnsnames.ora and use boston in your log_archive_dest_2.

[Roshan]

Hello,

please find attached. The RFS process is not running

waitforlogSTDBY.PNG

[Roshan]

Standby alert log:
Media Recovery Waiting for thread 1 sequence 9
Tue Jan 24 09:40:59 2017
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Tue Jan 24 19:27:06 2017
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:2624274992)
Tue Jan 24 19:27:06 2017
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:2624274992)
Tue Jan 24 19:27:06 2017
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:2624274992)
Tue Jan 24 19:33:04 2017
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:2624274992)
Tue Jan 24 19:38:04 2017
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:2624274992)
Tue Jan 24 19:43:04 2017

[ErmanArslansOracleBlog]

Please answer my previous questions:

What is this log_archive_dest? 

*.LOG_ARCHIVE_DEST_2='SERVICE=TEST12C ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston' 

IT is a little bit strange becauase your primary service is also TEST12C, am I wrong? 

So, if that so, it is confusing. 

What do you get when you tnsping from primary 
I mean -> from primary> "tnsping TEST12C" -> what does this command returns? (is it going to primary or standby?) 

2017-01-25 9:27 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

Standby alert log:
Media Recovery Waiting for thread 1 sequence 9
Tue Jan 24 09:40:59 2017
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Tue Jan 24 19:27:06 2017
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:<a href="tel:(0262)%20427%2049%2092" value="[phone]" target="_blank">2624274992)
Tue Jan 24 19:27:06 2017
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:<a href="tel:(0262)%20427%2049%2092" value="[phone]" target="_blank">2624274992)
Tue Jan 24 19:27:06 2017
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:<a href="tel:(0262)%20427%2049%2092" value="[phone]" target="_blank">2624274992)
Tue Jan 24 19:33:04 2017
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:<a href="tel:(0262)%20427%2049%2092" value="[phone]" target="_blank">2624274992)
Tue Jan 24 19:38:04 2017
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:<a href="tel:(0262)%20427%2049%2092" value="[phone]" target="_blank">2624274992)
Tue Jan 24 19:43:04 2017

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Dataguard-configuration-tp1992p2003.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[Roshan]

Standby

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
                                                 LOCATION=/app/oracle/fast_recovery_area/BOSTON/archivelog VA
                                                 LID_FOR=(ALL_LOGFILES,ALL_ROLE
                                                 S) DB_UNIQUE_NAME=boston

log_archive_dest_2                   string      SERVICE=TEST12C ASYNC VALID_FO
                                                 R=(ONLINE_LOGFILES,PRIMARY_ROL
                                                 E) DB_UNIQUE_NAME=TEST12C


Primary
log_archive_dest_1                   string      LOCATION=/u01/ora12c/fast_reco
                                                 very_area/TEST12C/archivelog V
                                                 ALID_FOR=(ALL_LOGFILES,ALL_ROL
                                                 ES) DB_UNIQUE_NAME=TEST12C

log_archive_dest_2                   string      SERVICE=boston ASYNC VALID_FOR
                                                 =(ONLINE_LOGFILES,PRIMARY_ROLE
                                                 ) DB_UNIQUE_NAME=boston

[ErmanArslansOracleBlog]

Looking at your standby 's init.ora.

You have:

*.db_name='boston'
*.db_unique_name='boston'

It should be;

*.db_name='TEST12C'
*.db_unique_name='boston'

See: http://docs.oracle.com/cd/E11882_01/server.112/e41134/create_ps.htm#SBYDB4724 (Example 3-3 Modifying Initialization Parameters for a Physical Standby Database )

2017-01-25 19:13 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

Standby

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
                                                 LOCATION=/app/oracle/fast_recovery_area/BOSTON/archivelog VA
                                                 LID_FOR=(ALL_LOGFILES,ALL_ROLE
                                                 S) DB_UNIQUE_NAME=boston

log_archive_dest_2                   string      SERVICE=TEST12C ASYNC VALID_FO
                                                 R=(ONLINE_LOGFILES,PRIMARY_ROL
                                                 E) DB_UNIQUE_NAME=TEST12C


Primary
log_archive_dest_1                   string      LOCATION=/u01/ora12c/fast_reco
                                                 very_area/TEST12C/archivelog V
                                                 ALID_FOR=(ALL_LOGFILES,ALL_ROL
                                                 ES) DB_UNIQUE_NAME=TEST12C

log_archive_dest_2                   string      SERVICE=boston ASYNC VALID_FOR
                                                 =(ONLINE_LOGFILES,PRIMARY_ROLE
                                                 ) DB_UNIQUE_NAME=boston

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Dataguard-configuration-tp1992p2012.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[ErmanArslansOracleBlog]

Read  http://ermanarslan.blogspot.com.tr/2016/03/rdbms-dataguard-physical-standby.html for getting a more detailed info about creating standby environments.

[ErmanArslansOracleBlog]

Any updates?
Issue solved?

[Roshan]

I found the issue.

In alert log of standby, I am getting
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:2624274992)

(Doc ID 397014.1)

The DBID is physical database DBID
1538400285

If I disable log_archive_dest_2 it will not transport the log to standby database.

[ErmanArslansOracleBlog]

so if you dont transport redologs to stanby, then what is the point of having a standby? 

27 Oca 2017 12:47 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

I found the issue.

In alert log of standby, I am getting
Standby database ID mismatch [0x5bb2201d:0x9c6b4230] (1538400285:<a href="tel:(0262)%20427%2049%2092" value="[phone]" target="_blank">2624274992)

(Doc ID 397014.1)

The DBID is physical database DBID
1538400285

If I disable log_archive_dest_2 it will not transport the log to standby database.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Dataguard-configuration-tp1992p2021.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML