資訊專欄INFORMATION COLUMN
Broker介紹
DG Broker是一個分布式管理框架，可自動且集中創建、維護和監控 DG。
broke作用
DG Broker搭建adg過程展示
[oracle@prodsty admin]$ cat listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = prod)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = prod)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.2)(PORT = 1521))
)
Tnsnames.pra
[oracle@prodsty admin]$ cat tnsnames.ora
pri =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)
)
sty =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prod)
)
)[oracle@prodpri dbs]$scp initprod.ora 192.168.**.*:
/u01/oracle/product/db11gr2/dbs
[oracle@prodpri dbs]$scp orapwprod 192.168.**.*:
/u01/oracle/product/db11gr2/dbs并修改db_unique_name，創建相關目錄，啟動數據庫到nomount狀態。
SQL> startup nomount。[oracle@prodsty dbs]$rman target sys/"#EDC5rdx"@pri
auxiliary sys/"#EDC5rdx"@sty nocatalog <rman.log
RMAN> duplicate target database for standby from active
database dorecover nofilenamecheck; SQL> alter system set dg_broker_config_file1 =/oradata/prod/dr1.dat;
System altered.
SQL> alter system set dg_broker_config_file2 =/oradata/prod/dr2.dat;
System altered.
SQL> alter system set dg_broker_start=true;
System altered.
SQL> show parameter broker
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string /oradata/prod/dr1.dat
dg_broker_config_file2 string /oradata/prod/dr2.dat
dg_broker_start boolean TRUE[oracle@prod prod]$ dgmgrl /
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> create configuration prod as primary database is prod_pri connect identifier is pri;
Configuration "prod" created with primary database "prod_pri"DGMGRL> add database prod_sty as connect identifier is sty maintained as physical;
Database "prod_sty" added
DGMGRL> enable configuration;
Enabled.DGMGRL> show configuration
Configuration - prod
Protection Mode: MaxPerformance
Databases:
prod_pri - Primary database
prod_sty - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESSDGMGRL> edit database prod_pri set property LogXptMode=SYNC;
Property "logxptmode" updated
DGMGRL> edit database prod_sty set property LogXptMode=SYNC;
Property "logxptmode" updated
DGMGRL> edit database prod_pri set property StandbyFileManagement = AUTO;
Property "standbyfilemanagement" updated
DGMGRL> edit database prod_sty set property StandbyFileManagement = AUTO;
Property "standbyfilemanagement" updated
DGMGRL> edit configuration set protection mode as maxavailability;
Succeeded.[oracle@prod ~]$ dgmgrl sys/#EDC5rdx@pri
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> switchover to prod_sty
Performing switchover NOW, please wait...
New primary database "prod_sty" is opening...
Operation requires startup of instance "prod" on database "prod_pri"
Starting instance "prod"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "prod_sty"DGMGRL> show configuration;
Configuration - prod
Protection Mode: MaxAvailability
Databases:
prod_sty - Primary database
prod_pri - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS-----------------------------------------
文章版權歸作者所有，未經允許請勿轉載,若此文章存在違規行為，您可以聯系管理員刪除。
轉載請注明本文地址：http://specialneedsforspecialkids.com/yun/129700.html
19C?DG?Broker配置和測試 img{ display:block; margin:0 auto !important; width:100%; } body{ width:75%; ...
摘要：問題九庫控制文件擴展報錯庫的擴展報錯，用的是裸設備，和還是原來大小，主庫的沒有報錯，并且大小沒有變，求解釋。專家解答從報錯可以看出，控制文件從個塊擴展到個塊時報錯，而裸設備最大只支持個塊，無法擴展，可以嘗試將參數改小，避免控制文件報錯。 鏈接描述引言 近期我們在DBASK小程序新關聯了運維之美、高端存儲知識、一森咖記、運維咖啡吧等數據領域的公眾號，歡迎大家閱讀分享。 問答集萃 接下來，...
摘要：新晉技術專家下面是墨天輪部分新晉的技術專家。大家可以點擊往期閱讀墨天輪技術專家邀請函了解詳情，申請成為我們的技術專家，加入專家團隊，與我們一起創建一個開放互助的數據庫技術社區。新關聯公眾號墨天輪是一個開放互助的數據庫技術社區。 引言 近期我們在DBASK小程序增加了數據庫 MongoDB、Redis、 Elasticsearch、DB2、Weblogic 等新的的專題欄目和一些新的技術...
閱讀 1346·2023-01-11 13:20
閱讀 1684·2023-01-11 13:20
閱讀 1132·2023-01-11 13:20
閱讀 1858·2023-01-11 13:20
閱讀 4100·2023-01-11 13:20
閱讀 2704·2023-01-11 13:20
閱讀 1385·2023-01-11 13:20
閱讀 3597·2023-01-11 13:20
