Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> datagurd broker with two protection mode
alireza.mmm
post Oct 4 2017, 07:03 AM
Post #1


Member
**

Group: Members
Posts: 12
Joined: 16-April 17
Member No.: 51,910



Hi
I want impelement oracle standby database 11gR2 with one primary database and two standby database with dataguard broker.
I want set one node of standby database to maximum availability and another node to maximum performance;
How do it ?
because in dataguard broker only one mode cat be set.
Thank you
Go to the top of the page
 
+Quote Post
burleson
post Oct 4 2017, 12:15 PM
Post #2


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi Alireza,

It looks like you must use maximum performance when deploying multiple standby databases:

http://www.oracle.com/technetwork/database...bp-1-131937.pdf

Also see my notes here:

http://www.dba-oracle.com/b_data_guard_standby.htm

Good luck!


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
alireza.mmm
post Oct 7 2017, 03:06 AM
Post #3


Member
**

Group: Members
Posts: 12
Joined: 16-April 17
Member No.: 51,910



QUOTE (burleson @ Oct 4 2017, 01:15 PM) *
Hi Alireza,

It looks like you must use maximum performance when deploying multiple standby databases:

http://www.oracle.com/technetwork/database...bp-1-131937.pdf

Also see my notes here:

http://www.dba-oracle.com/b_data_guard_standby.htm

Good luck!


thanks MR burleson for reply my question.

i have one primary database and dbname is ORC1 and i have one standby database with name ORC2 and another standby database with name ORC3.
i configure dataguard broker in primary database to maximum availability.
and config archive destination in primary database as below :

log_archive_dest_1=LOCATION=/u01/arc VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORC1
log_archive_dest_2=SERVICE=ORC2 LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLES) DB_UNIQUE_NAME=ORC2
log_archive_dest_3=SERVICE=ORC3 LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLES) DB_UNIQUE_NAME=ORC3

and configure my datagurd broker as below :

DGMGRL> show configuration;

Configuration - alireza

Protection Mode: MaxAvailability
Databases:
ORC1 - Primary database
ORC2 - Physical standby database
ORC3 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS


DGMGRL> show database ORC2;

Database - ORC2

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Apply Rate: 1.34 MByte/s
Real Time Query: ON
Instance(s):
ORC1

Database Status:
SUCCESS

DGMGRL> show database ORC3;

Database - ORC3

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Apply Rate: 746.00 KByte/s
Real Time Query: ON
Instance(s):
orc1

Database Status:
SUCCESS

and select protection mode from three database :

IN DATABASE ORC1 :

select protection_mode,protection_level from v$database;


PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY


IN DATABASE ORC2 :


select protection_mode,protection_level from v$database;


PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY



IN DATABASE ORC3 :

select protection_mode,protection_level from v$database;

PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE


Is my Configuration correct Mr. burleson?


thank you very much wink.gif wink.gif wink.gif


Go to the top of the page
 
+Quote Post
burleson
post Oct 7 2017, 07:05 AM
Post #4


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi Alireza,

It looks good to me!

Good luck!


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd October 2017 - 03:46 PM