這篇文章主要為大家展示了“oracle 11g  dg broker如何開(kāi)啟和配置”，內(nèi)容簡(jiǎn)而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓小編帶領(lǐng)大家一起研究并學(xué)習(xí)一下“oracle 11g  dg broker如何開(kāi)啟和配置”這篇文章吧。

站在用戶的角度思考問(wèn)題，與客戶深入溝通，找到平昌網(wǎng)站設(shè)計(jì)與平昌網(wǎng)站推廣的解決方案，憑借多年的經(jīng)驗(yàn)，讓設(shè)計(jì)與互聯(lián)網(wǎng)技術(shù)結(jié)合，創(chuàng)造個(gè)性化、用戶體驗(yàn)好的作品，建站類型包括：網(wǎng)站建設(shè)、成都網(wǎng)站制作、企業(yè)官網(wǎng)、英文網(wǎng)站、手機(jī)端網(wǎng)站、網(wǎng)站推廣、國(guó)際域名空間、虛擬主機(jī)、企業(yè)郵箱。業(yè)務(wù)覆蓋平昌地區(qū)。

Oracle11g 開(kāi)啟db broker實(shí)現(xiàn)管理dg的目的

保證兩邊都設(shè)置的如下幾個(gè)參數(shù)：

1.SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=/data/u01/app/oracle/archive/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=db1';

System altered.

2.SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=db1 LGWR aSYNC VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=db1';

System altered.

3.SQL> ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='/data/u01/app/oracle/oradata/db2/', '/data/u01/app/oracle/oradata/db1/' scope =spfile;

System altered.

4.SQL> ALTER SYSTEM SET DB_FILE_NAME_CONVERT= '/data/u01/app/oracle/oradata/db2/', '/data/u01/app/oracle/oradata/db1/' scope =spfile;

System altered.

5.SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SCOPE=SPFILE;

System altered.

6.SQL> ALTER SYSTEM SET FAL_CLIENT = db1 SCOPE=SPFILE;

System altered.

7.SQL> ALTER SYSTEM SET FAL_SERVER = db2 SCOPE=SPFILE;

System altered.

8.主庫(kù)備庫(kù)添加了standby logfile

9. SQL> alter database force logging;

Database altered.

前提：主庫(kù)db2 備庫(kù)db1

一：開(kāi)啟db broker

在主備庫(kù)上各設(shè)置為true

SQL> alter system set dg_broker_start=true;

主備庫(kù)：參數(shù)dg_broker_config_file，默認(rèn)即可!當(dāng)你后面創(chuàng)建了configuration 并且enable之后

就會(huì)在這個(gè)目錄下生成相應(yīng)的文件!

SQL> show parameter dg_broker_config_file;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

dg_broker_config_file1 string /data/u01/app/oracle/product/1

1.2.0/dbhome_1/dbs/dr1db2.dat

dg_broker_config_file2 string /data/u01/app/oracle/product/1

1.2.0/dbhome_1/dbs/dr2db2.dat

修改dg_broker_config_file參數(shù)。這里就用默認(rèn)的路徑，也可以自己指定。如果是在RAC環(huán)境中，這個(gè)把這個(gè)文件把到共享的存儲(chǔ)上面，如果有ASM可以放到ASM中。

二.主備庫(kù)listener.ora添加db broker切換使用的監(jiān)聽(tīng)服務(wù)，因?yàn)閐g broker使用的服務(wù)名就是db_unique_name_DGMGRL，注：如果不修改監(jiān)聽(tīng)利用原有的監(jiān)聽(tīng)也是可以得，下面會(huì)介紹這種方法!

2.1 vim listener.ora,添加下面的紅色部分!一定注意格式，嚴(yán)格對(duì)齊

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.21.178)(PORT = 1521))

)

)

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(GLOBAL_DBNAME=db2)

(ORACLE_HOME=/data/u01/app/oracle/product/11.2.0/dbhome_1)

(SID_NAME=db2))

(SID_DESC=

(GLOBAL_DBNAME=db2_DGMGRL)

(ORACLE_HOME=/data/u01/app/oracle/product/11.2.0/dbhome_1)

(SID_NAME=db2)))

ADR_BASE_LISTENER = /data/u01/app/oracle

2.2 重新加載監(jiān)聽(tīng)：

[oracle@beijing-fuli-hadoop-02 admin]$ lsnrctl reload

三.配置 db broker

3.1.連接主庫(kù)

[oracle@beijing-fuli-hadoop-02 admin]$ dgmgrl sys/oracle@db2

3.2.創(chuàng)建配置

DGMGRL> help

The following commands are available:

add Adds a standby database to the broker configuration

connect Connects to an Oracle database instance

convert Converts a database from one type to another

create Creates a broker configuration

disable Disables a configuration, a database, or fast-start failover

edit Edits a configuration, database, or instance

enable Enables a configuration, a database, or fast-start failover

exit Exits the program

failover Changes a standby database to be the primary database

help Displays description and syntax for a command

quit Exits the program

reinstate Changes a database marked for reinstatement into a viable standby

rem Comment to be ignored by DGMGRL

remove Removes a configuration, database, or instance

show Displays information about a configuration, database, or instance

shutdown Shuts down a currently running Oracle database instance

sql Executes a SQL statement

start Starts the fast-start failover observer

startup Starts an Oracle database instance

stop Stops the fast-start failover observer

switchover Switches roles between a primary and standby database

DGMGRL> help create

Creates a broker configuration

Syntax:

CREATE CONFIGURATION <configuration name> AS

PRIMARY DATABASE IS <database name>

CONNECT IDENTIFIER IS <connect identifier>;

DGMGRL> CREATE CONFIGURATION dbha_c AS PRIMARY DATABASE IS db2 CONNECT IDENTIFIER IS db2;

(解釋：其中 dbha_c是隨便起的名字，db2是主的數(shù)據(jù)庫(kù)唯一名，identifier is是tnsnames.ora的網(wǎng)絡(luò)服務(wù)名! 然后可以使用如下來(lái)刪除創(chuàng)建的configuration!

DGMGRL> REMOVE CONFIGURATION;)

3.3添加備庫(kù)的信息

DGMGRL> help add

DGMGRL> add database 'db1' as connect identifier is 'db1' maintained as physical;

Database "db1" added

注意identifier is 'db1' 這里的db1是你tnsnames.ora里面關(guān)于備庫(kù)的那個(gè)名字!

添加了之后

3.4啟動(dòng)這個(gè)db broker的CONFIGURATION!

DGMGRL> help enable

DGMGRL> ENABLE CONFIGURATION;

3.5查看db broker的的相關(guān)配置

DGMGRL> help show

DGMGRL> SHOW CONFIGURATION;

如下報(bào)錯(cuò)：

DGMGRL> show configuration

Configuration - dbha_c

Protection Mode: MaxPerformance

Databases:

db2 - Primary database

db1 - Physical standby database (disabled)

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

解決辦法：

將主從庫(kù)的這個(gè)目錄下的文件刪除，然后重新create configuration，即可!

SQL> show parameter dg_broker_config_file;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

dg_broker_config_file1 string /data/u01/app/oracle/product/1

1.2.0/dbhome_1/dbs/dr1db2.dat

dg_broker_config_file2 string /data/u01/app/oracle/product/1

1.2.0/dbhome_1/dbs/dr2db2.dat

解釋：這兩文件的作用?

如下顯示代表正常!!!

DGMGRL> show configuration

Configuration - dbha_c

Protection Mode: MaxPerformance

Databases:

db2 - Primary database

db1 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

查看數(shù)據(jù)庫(kù)的狀態(tài)：

DGMGRL> show database verbose db1;

#這里要注意了。broker里面的連接的service_name是<db_unique_name>_DGMGRL,所以上面要修改一下監(jiān)聽(tīng)!

如果不修改監(jiān)聽(tīng)文件的話，那也可以執(zhí)行下面的命令來(lái)修改StaticConnectIdentifier:

DGMGRL>edit database db1 set property StaticConnectIdentifier= '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=beijing-fuli-hadoop-01)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db1)(INSTANCE_NAME=db1)(SERVER=DEDICATED)))';

DGMGRL> edit database db2 set property StaticConnectIdentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=beijing-fuli-hadoop-02)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db2)(INSTANCE_NAME=db2)(SERVER=DEDICATED)))';

四：關(guān)于db broker的相關(guān)命令：

4.1：切換主從!

DGMGRL> help switchover

DGMGRL> switchover to db1

Performing switchover NOW, please wait...

Operation requires a connection to instance "db1" on database "db1"

Connecting to instance "db1"...

Connected.

New primary database "db1" is opening...

Operation requires startup of instance "db2" on database "db2"

Starting instance "db2"...

ORACLE instance started.

Database mounted.

Database opened.

Switchover succeeded, new primary is "db1"

DGMGRL>

4.2：把從庫(kù)切換成snapshot狀態(tài)!(前提是開(kāi)啟了flashback database)

主庫(kù)操作

DGMGRL> SHOW CONFIGURATION

DGMGRL> help convert

DGMGRL> CONVERT DATABASE db1 TO SNAPSHOT STANDBY;

DGMGRL> SHOW CONFIGURATION;

4.3: 修改下dg同步redo的方式，以及保護(hù)模式!

DGMGRL> help edit

DGMGRL> EDIT DATABASE db2 SET PROPERTY LogXptMode=SYNC; ---主庫(kù)

DGMGRL> EDIT DATABASE db1 SET PROPERTY LogXptMode=SYNC; ---備庫(kù)

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability; ---主庫(kù)

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability; ---備庫(kù)

以上是“oracle 11g  dg broker如何開(kāi)啟和配置”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對(duì)大家有所幫助，如果還想學(xué)習(xí)更多知識(shí)，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！

本文標(biāo)題：oracle11gdgbroker如何開(kāi)啟和配置
本文地址：http://aaarwkj.com/article36/iipjpg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站制作、企業(yè)網(wǎng)站制作、小程序開(kāi)發(fā)、App設(shè)計(jì)、網(wǎng)站維護(hù)、自適應(yīng)網(wǎng)站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)