No question at this time
DBA Top 10
1 A. Kavsek 12400
2 M. Cadot 7300
3 B. Vroman 6400
4 P. Wisse 5600
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 A. Chavan 300
9 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48458
Total active users1485
Act. users last 24h4
Act. users last hour0
Registered user hits last week184
Registered user hits last month815
Go up

Broker syntax configuration for standby
Next thread: SCHEMA GROWTH
Prev thread: Long running query without rownum filter in where-clause

Message Score Author Date
Hi, I am a bit confused by the broker syntax to...... Lauri Jul 25, 2019, 13:02
How is DB_UNIQUE_NAME defined for the primary and ...... Lauri Jul 25, 2019, 13:09

Follow up by mail Click here


Subject: Broker syntax configuration for standby
Author: Lauri, Netherlands
Date: Jul 25, 2019, 13:02, 134 days ago
Os info: Linux
Oracle info: 12c
Error info: n.a.
Message: Hi,

I am a bit confused by the broker syntax to use for configuring a standby database.
I am confused by the use of atabase name, db_name, db_unique_name, TNS name in the whole broker configuration.

1) Setting the configuration:

-- From the standby server:

create configuration CENPRD_STBY_CONFIG as
primary database is CENPRD
connect identifier is CENPRD_REMOTE;

With:

CENPRD_STBY_CONFIG -> name for the broker configuration
CENPRD -> database name, db_name, db_unique_name (of the primary database)
CENPRD_REMOTE -> TNS name for the primary database

add database CENPRDSBY as
connect identifier is CENPRD_LOCAL
maintained as physical;

With:

CENPRDSBY -> database name, db_unique_name (of the standby database)
CENPRD_LOCAL -> TNS name for the standby database

2) Prepare for switchover and logshipping:

-- From the standby server:

-- for primary site:

EDIT DATABASE CENPRD
SET PROPERTY StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg12c03-dg.mydomain.local)
(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=CENPRD_REMOTE)(INSTANCE_NAME=CENPRD) (SERVER=DEDICATED)))';

-- for the standby site:

EDIT DATABASE CENPRDSBY
SET PROPERTY StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg12c04-dg.mydomain.local)
(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=CENPRD_LOCAL)(INSTANCE_NAME=CENPRD) (SERVER=DEDICATED)))';

Can someone explain me if this is the correct syntax for create configuration, add database, EDIT DATABASE, SERVICE_NAME, INSTANCE_NAME?

Thanks by advance.

Kind Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Broker syntax configuration for standby
Author: Lauri, Netherlands
Date: Jul 25, 2019, 13:09, 134 days ago
Message: How is DB_UNIQUE_NAME defined for the primary and standby database?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here