Oracle 12C dgbroker 配置
關於DGbroker的配置網上有太多資料了,此處在不做詳細介紹配置,貼一片metalink上的文章共大家參考學習。
1. Prerequisits,
Start the Dataguard broker DMON process. ----------啟動dg_broker
On Primary and Standby,
SQL> alter system set dg_broker_start=true sid='*';
2. Connect to DGMGRL ---------------------------連線dgmgrl,進行配置
Primary,
DGMGRL>connect sysdg
password: *****
3. Create configuration, ----------------------------建立配置
DGMGRL> CREATE CONFIGURATION '<configuration name>' AS PRIMARY DATABASE IS '<primary db_unique_name>' CONNECT IDENTIFIER IS <primary connect string>;
ex,
DGMGRL> CREATE CONFIGURATION '12c' AS PRIMARY DATABASE IS 'boston' CONNECT IDENTIFIER IS boston;
NOTE : If create configuration fails with ORA-16698 refer to
Note 1582179.1: Create Configuration Failing with ORA-16698
Verify configuration,
Configuration - 12c
Protection Mode: MaxPerformance
Databases:
boston - Primary database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
4. Add Standby, -------------------------------新增備用環境
DGMGRL> add database <standby db_unique_name> as connect identifier is <standby connect string>;
ex,
DGMGRL> add database chicago as connect identifier is chicago;
Configuration - 12c
Protection Mode: MaxPerformance
Databases:
boston - Primary database
chicago - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
5. Enable Configuration,
6. Verify configuration,
Configuration - 12c
Protection Mode: MaxPerformance
Databases:
boston - Primary database
chicago - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Database - boston
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
boston
Database Status:
SUCCESS
DGMGRL> show database chicago;
Database - chicago
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 1 second ago)
Apply Lag: 0 seconds (computed 1 second ago)
Apply Rate: 2.54 MByte/s
Real Time Query: ON
Instance(s):
chicago
SUCCESS
Datagurd configuration details recorded in binary file,
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string /u01/app/oracle/product/12.1.0
/dbhome_1/dbs/dr1boston.dat
dg_broker_config_file2 string /u01/app/oracle/product/12.1.0
/dbhome_1/dbs/dr2boston.dat
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28612416/viewspace-2120010/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 12c RAC構築之二:共享磁碟配置Oracle
- ORACLE 11G dgbroker異常之ORA-16820&ORA-16825&ORA-12541Oracle
- Oracle 11g/12c 監聽器白名單的配置Oracle
- Oracle 12c Automatic ReoptimizationOracle
- Oracle 12C安裝Oracle
- Linux 6.9 加盤後的Oracle 12c ASM DiskGroup配置過程LinuxOracleASM
- Oracle 12C Database File Mapping for Oracle ASM FilesOracleDatabaseAPPASM
- Oracle 12c升級指南Oracle
- 12C Oracle ASM Filter DriverOracleASMFilter
- Oracle 12C Statistics on Column GroupsOracle
- sysbench壓測Oracle 12COracle
- benchmark 壓測Oracle 12cOracle
- Manage SQL Plan Baselines in Oracle 12cSQLOracle
- Oracle 12c CDB&PDBs管理Oracle
- oracle 12c rman備份pdbOracle
- Oracle 12c系列(五)|PDB RefreshOracle
- Oracle 12c系列(六)|Relocate a PDBOracle
- oracle 12c release 2 安裝Oracle
- Oracle 12C 官方文件地圖Oracle地圖
- Oracle 12C新特性-History命令Oracle
- Oracle 12C新特性In-MemoryOracle
- Oracle 12c 兩個新特性Oracle
- Oracle 12c RMAN全攻略Oracle
- Oracle 12c系列(十) | 12c中的Recovering Tables and Table PartitionsOracle
- 【OCM】Oracle 12C OCMU 12c OCM升級考試大綱Oracle
- Oracle OCP(34):環境準備(Redhat 7 + Oracle 12c)OracleRedhat
- Oracle 12c 備份與恢復Oracle
- Oracle 12c rac ocr和votedisk管理Oracle
- Oracle 12C Sharding部署和測試Oracle
- Oracle 12C ASM asmcmd amdu_extractOracleASM
- Oracle 12c系列(八)|RMAN (FROM SERVICE)Oracle
- Oracle 12c 關閉歸檔模式Oracle模式
- Oracle 12c nocdb轉換成cdbOracle
- Oracle 12c資料庫安裝Oracle資料庫
- Oracle Goldengate 12c打pus補丁OracleGo
- ORACLE 12C opatch fuser與ChecksystemCommandAvailable failedOracleAI
- Oracle 12c叢集啟動故障Oracle
- Oracle 12c系列(二)|PDB的建立Oracle
- ORACLE 12C Cloud Control(二)介紹OracleCloud