Primary Database :
DB_NAME DATABASE_ROLE DB_UNIQUE_NAME VERSION
---------------- -------------------- ---------------- --------------- --------------- ----------
orcl PRIMARY orcl 12.1.0.2.0
Standby Database :
DB_NAME DATABASE_ROLE DB_UNIQUE_NAME VERSION
---------------- -------------------- ---------------- --------------- --------------- -------
orcl PHYSICAL STANDBY orcl_dg 12.1.0.2.0
1. . On both primary and standby set db_broker_start to TRUE
SQL> alter system set dg_broker_start=true scope=both;
System altered.
SQL> show parameter dg_broker_start ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start boolean TRUE
Step 2 : Edit the listener.ora file on both primary and standby :
Include the db_unique_name_DGMGRL.db_domain values for the GLOBAL_DBNAME in both primary and standby database .
To set the value, lets check the db_domain and db_unique_name value .
primary :
============
SQL> show parameter db_unique_name ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string orcl
SQL> show parameter db_domain ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string
Since the value of db_domain is null so the the value of GLOBAL_DBNAME = orcl_DGMGRL for primary database
[grid@node1 ~]$ cat /data01/app/grid/product/12.1.0/grid/network/admin/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /data01/app/oracle/product/12c/db_1)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl_DGMGRL)
(ORACLE_HOME = /data01/app/oracle/product/12c/db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
standby :
=========
SQL> show parameter db_unique_name ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string orcl_dg
SQL> show parameter db_domain ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string
Since the value of db_domain is null so GLOBAL_DBNAME = orcl_dg_DGMGRL for standby database .
[grid@node2 ~]$ cat /data01/app/grid/product/12.1.0/grid/network/admin/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /data01/app/oracle/product/12c/db_1)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl_dg_DGMGRL)
(ORACLE_HOME = /data01/app/oracle/product/12c/db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
Configure the Data Guard Configuration
DGMGRL> connect sys/******@orcl
Connected as SYSDBA.
DGMGRL>
DGMGRL> CREATE CONFIGURATION 'ORCLCONF' AS PRIMARY DATABASE IS 'ORCL' CONNECT IDENTIFIER IS ORCL;
Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
Failed.
Reason : (For 12.1, for SERVICE= for Remote lad's if the NOREGISTER attribute is Not set, then you must remove/clear the lad before creating the broker configuration. Doc ID 1582179.1)
SQL> show parameter log_Archive_dest_2 ;
NAME TYPE VALUE
------------------------------------ ----------- ----------------------------------------------------------------------------------
log_archive_dest_2 string SERVICE=orcl_dg VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl_dg
SQL> alter system set log_Archive_dest_2='';
System altered.
SQL> show parameter log_Archive_dest_2 ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string
DGMGRL> connect sys/****@orcl
Connected as SYSDBA.
DGMGRL> CREATE CONFIGURATION 'ORCLCONF' AS PRIMARY DATABASE IS 'orcl' CONNECT IDENTIFIER IS orcl;
Configuration "ORCLCONF" created with primary database "orcl"
DGMGRL> ADD DATABASE 'orcl_dg' AS CONNECT IDENTIFIER IS orcl_dg MAINTAINED AS PHYSICAL ;
Database "orcl_dg" added
DGMGRL> show configuration
Configuration - ORCLCONF
Protection Mode: MaxPerformance
Members:
orcl - Primary database
orcl_dg - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration
Configuration - ORCLCONF
Protection Mode: MaxPerformance
Members:
orcl - Primary database
orcl_dg - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 10 seconds ago)
DGMGRL> show database verbose orcl
Database - orcl
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
orcl
Properties:
DGConnectIdentifier = 'orcl'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
RedoRoutes = ''
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.73)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '+DATA'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL> show database verbose orcl_dg
Database - orcl_dg
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 9.00 KByte/s
Active Apply Rate: 24.00 KByte/s
Maximum Apply Rate: 247.00 KByte/s
Real Time Query: OFF
Instance(s):
orcl
Properties:
DGConnectIdentifier = 'orcl_dg'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
RedoRoutes = ''
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '+DATA, +DATA2'
LogFileNameConvert = '+DATA, +DATA2'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl_dg_DGMGRL)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '+DATA'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL> validate database verbose orcl
Database Role: Primary database
Ready for Switchover: Yes
Capacity Information:
Database Instances Threads
orcl 1 1
Temporary Tablespace File Information:
orcl TEMP Files: 1
Flashback Database Status:
orcl: Off
Data file Online Move in Progress:
orcl: No
Transport-Related Information:
Transport On: Yes
Log Files Cleared:
orcl Standby Redo Log Files: Cleared
Automatic Diagnostic Repository Errors:
Error orcl
No logging operation NO
Control file corruptions NO
System data file missing NO
System data file corrupted NO
System data file offline NO
User data file missing NO
User data file corrupted NO
User data file offline NO
Block Corruptions found NO
DGMGRL> validate database verbose orcl_dg
Database Role: Physical standby database
Primary Database: orcl
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Capacity Information:
Database Instances Threads
orcl 1 1
orcl_dg 1 1
Temporary Tablespace File Information:
orcl TEMP Files: 1
orcl_dg TEMP Files: 1
Flashback Database Status:
orcl: Off
orcl_dg: Off
Data file Online Move in Progress:
orcl: No
orcl_dg: No
Standby Apply-Related Information:
Apply State: Running
Apply Lag: 0 seconds (computed 1 second ago)
Apply Delay: 0 minutes
Transport-Related Information:
Transport On: Yes
Gap Status: No Gap
Transport Lag: 0 seconds (computed 1 second ago)
Transport Status: Success
Log Files Cleared:
orcl Standby Redo Log Files: Cleared
orcl_dg Online Redo Log Files: Cleared
orcl_dg Standby Redo Log Files: Available
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(orcl) (orcl_dg)
1 3 2 Insufficient SRLs
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups Status
(orcl_dg) (orcl)
1 3 0 Insufficient SRLs
Warning: standby redo logs not configured for thread 1 on orcl
Current Configuration Log File Sizes:
Thread # Smallest Online Redo Smallest Standby Redo
Log File Size Log File Size
(orcl) (orcl_dg)
1 50 MBytes 50 MBytes
Apply-Related Property Settings:
Property orcl Value orcl_dg Value
DelayMins 0 0
ApplyParallel AUTO AUTO
Transport-Related Property Settings:
Property orcl Value orcl_dg Value
LogXptMode ASYNC ASYNC
RedoRoutes <empty> <empty>
Dependency <empty> <empty>
DelayMins 0 0
Binding optional optional
MaxFailure 0 0
MaxConnections 1 1
ReopenSecs 300 300
NetTimeout 30 30
RedoCompression DISABLE DISABLE
LogShipping ON ON
Automatic Diagnostic Repository Errors:
Error orcl orcl_dg
No logging operation NO NO
Control file corruptions NO NO
SRL Group Unavailable NO NO
System data file missing NO NO
System data file corrupted NO NO
System data file offline NO NO
User data file missing NO NO
User data file corrupted NO NO
User data file offline NO NO
Block Corruptions found NO NO
How to set up data guard broker for RAC
https://martincarstenbach.wordpress.com/2012/06/29/how-to-set-up-data-guard-broker-for-rac/
Jadwal Pertandingan Ayam SV388 7 Maret 2019 - Jumat, Lombok 8 Maret 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.
ReplyDeleteSitus Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.
Untuk Info Lebih Lanjut Bisa Hub kami Di :
wechat : bolavita
line : cs_bolavita
whatsapp : +628122222995
BBM: BOLAVITA
You’ve got some interesting points in this article. I would have never considered any of these if I didn’t come across this. Thanks!. south african brokers forex
ReplyDeleteIn spite of this, Cardano CEO Charles Hoskinson, still thinks that crypto is the best hedge. He states that if SARS-CoV-2 (otherwise called Coronavirus) gets large, the only hedge from tumbling markets and also stocks will be crypto. Auto bitcoin bot
ReplyDelete