跨平臺級聯(lián)dataguard配置

正式環(huán)境中的OA庫要從Windows遷移到Linux，但由于數(shù)據(jù)量比較大，帶寬又比較窄，數(shù)據(jù)泵方式耗時太長，因此打算用DataGuard方式遷移，因此進(jìn)行了測試。

雙城網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián)公司,雙城網(wǎng)站設(shè)計制作，有大型網(wǎng)站制作公司豐富經(jīng)驗。已為雙城成百上千提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\成都外貿(mào)網(wǎng)站建設(shè)要多少錢，請找那個售后服務(wù)好的雙城做網(wǎng)站的公司定做！

環(huán)境

主庫：OS:Windows VERSION:11.2.0.4 ORACLE_SID:OA DB_NAME:OA DB_UNIQUE_NAME:OA

備庫：OS:Windows VERSION:11.2.0.4 ORACLE_SID:OA DB_NAME:OA DB_UNIQUE_NAME:OA_DG

級聯(lián)備庫：OS:Linux VERSION:11.2.0.4 ORACLE_SID:OA DB_NAME:OA DB_UNIQUE_NAME:OA_DG2

1.查看各庫平臺信息

SQL>select platform_id,platform_name from v$database;

主庫與備庫相同：

PLATFORM_ID PLATFORM_NAME

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

12 Microsoft Windows x86 64-bit

級聯(lián)備庫：

PLATFORM_ID PLATFORM_NAME

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

13 Linux x86 64-bit

查看兼容表格，可看到當(dāng)前的平臺與Oracle版本是可跨平臺搭建DataGuard的，但是要打Patch 13104881(當(dāng)前版本已打)

跨平臺級聯(lián)dataguard配置

2.備庫生成pfile，并將pfile、密碼文件傳輸?shù)絆A_DG2相關(guān)目錄下

3.級聯(lián)備庫上修改pfile

[oracle@node3 dbs]$ more initOA.ora

*. audit_file_dest ='/opt/app/oracle/admin/OA/adump'

*.audit_trail='DB'

*.compatible='11.2.0.0.0'

*. control_files ='/opt/app/oracle/oradata/OA/CONTROL01.CTL','/opt/app/oracle/fast_recovery_area/OA/CONTROL02.CTL'

*.db_block_size=8192

*.db_name='OA'

*.db_recovery_file_dest_size=4102029312

*. db_recovery_file_dest ='/opt/app/oracle/fast_recovery_area'

*. db_unique_name ='OA_DG2'

*. diagnostic_dest ='/opt/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=OAXDB)'

*. fal_client ='OA_DG2'

*. fal_server ='OA_DG'

*. db_file_name_convert ='C:\APP\ADMINISTRATOR\ORADATA\OA\','/opt/app/oracle/oradata/OA/','C:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\OA\','/opt/app/oracle/fast_recovery_area/OA/'

*. log_file_name_convert ='C:\APP\ADMINISTRATOR\ORADATA\OA\','/opt/app/oracle/oradata/OA/'

*. log_archive_config ='dg_config=(OA,OA_DG,OA_DG2)'

*.log_archive_dest_1='location=/opt/app/oracle/archivelog valid_for=(all_logfiles,all_roles)

*.log_archive_format='ARC%S_%R.%T'

*.nls_language='SIMPLIFIED CHINESE'

*.nls_territory='CHINA'

*.open_cursors=300

*.pga_aggregate_target=428867584

*.processes=150

*.recyclebin='OFF'

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=1291845632

*.standby_file_management='AUTO'

*.undo_tablespace='UNDOTBS1'

修改紅色字體部分，使其適應(yīng)當(dāng)前環(huán)境

4.級聯(lián)備庫上創(chuàng)建所需目錄

cd $ORACLE_BASE

mkdir -p oradata/OA/adump

mkdir -p oradata/OA

mkdir -p fast_recovery_area/OA

5.添加tns

備庫添加級聯(lián)備庫的tns

OA_DG2 =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = oa)

)

級聯(lián)備庫添加備庫的tns

OA_DG =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = oa)

)

6.修改備庫參數(shù)，將standby logfile傳輸?shù)郊壜?lián)備庫

SQL> alter system set log_archive_dest_state_3=defer; --暫時關(guān)閉

SQL> alter system set log_archive_config='dg_config=(OA,OA_DG,OA_DG2)';

SQL> alter system set log_archive_dest_3='service=OA_DG2 async valid_for=(STANDBY_LOGFILES,STANDBY_ROLE) db_unique_name=OA_DG2'

7.級聯(lián)備庫配置靜態(tài)監(jiān)聽

[oracle@node3 admin]$ more listener.ora

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

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

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

)

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(SID_NAME = OA)

(ORACLE_HOME = /opt/app/oracle/product/11g)

(GLOBAL_DBNAME = OA)

)

ADR_BASE_LISTENER = /opt/app/oracle

8.使用RMAN的復(fù)制功能創(chuàng)建備庫：

1)lsnrctl start

2)rman target sys@primary auxiliary sys@standby

3)duplicate target database for standby from active database;

如果報錯RMAN-05001: auxiliary file name /opt/app/oracle/oradata/orcl/users01.dbf conflicts with a file used by the target database，則執(zhí)行duplicate target database for standby from active database nofilenamecheck;

也可以并行復(fù)制以提高性能。需要分派主庫和備庫多個通道后，再執(zhí)行復(fù)制命令：

run

{

allocate channel chan1 type disk;

allocate channel chan2 type disk;

allocate channel chan3 type disk;

allocate channel chan4 type disk;

allocate auxiliary channel aux1 type disk;

allocate auxiliary channel aux2 type disk;

allocate auxiliary channel aux3 type disk;

allocate auxiliary channel aux4 type disk;

duplicate target database for standby from active database;

}

9.復(fù)制完成后，驗證級聯(lián)備庫中各文件路徑是否正確

SQL> select file_name from dba_data_files;

FILE_NAME

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

/opt/app/oracle/oradata/OA/USERS01.DBF

/opt/app/oracle/oradata/OA/UNDOTBS01.DBF

/opt/app/oracle/oradata/OA/SYSAUX01.DBF

/opt/app/oracle/oradata/OA/SYSTEM01.DBF

SQL> select group#,member from v$logfile;

GROUP# TYPE MEMBER

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

3 ONLINE /opt/app/oracle/oradata/OA/REDO03.LOG

2 ONLINE /opt/app/oracle/oradata/OA/REDO02.LOG

1 ONLINE /opt/app/oracle/oradata/OA/REDO01.LOG

4 STANDBY C:\APP\ADMINISTRATOR\ORADATA\OA\STANDBYREDO04.LOG

5 STANDBY C:\APP\ADMINISTRATOR\ORADATA\OA\STANDBYREDO05.LOG

6 STANDBY C:\APP\ADMINISTRATOR\ORADATA\OA\STANDBYREDO06.LOG

7 STANDBY C:\APP\ADMINISTRATOR\ORADATA\OA\STANDBYREDO07.LOG

7 rows selected.

可看到standby redo的目錄不正確(貌似log_file_name_convert對standby log沒起作用)，此時可手動刪掉standby日志組，再重新添加：

SQL> alter database drop standby logfile group 4;

SQL> alter database drop standby logfile group 5;

SQL> alter database drop standby logfile group 6;

SQL> alter database drop standby logfile group 7;

SQL> alter database add standby logfile group 4 ('/opt/app/oracle/oradata/OA/STANDBYRD04.LOG') size 50M;

SQL> alter database add standby logfile group 5 ('/opt/app/oracle/oradata/OA/STANDBYRD05.LOG') size 50M;

SQL> alter database add standby logfile group 6 ('/opt/app/oracle/oradata/OA/STANDBYRD06.LOG') size 50M;

SQL> alter database add standby logfile group 7 ('/opt/app/oracle/oradata/OA/STANDBYRD07.LOG') size 50M;

驗證完畢后打開備庫的傳輸參數(shù)

SQL> alter system set log_archive_dest_3_state=enable;

驗證傳輸是否正常，在級聯(lián)備庫執(zhí)行

SQL> SELECT PROCESS,

2 PID,

3 STATUS,

4 SEQUENCE#,

5 DELAY_MINS

6 FROM V$MANAGED_STANDBY;

PROCESS PID STATUS SEQUENCE# DELAY_MINS

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

ARCH 30382 CLOSING 158 0

ARCH 30384 CLOSING 154 0

ARCH 30386 CONNECTED 0 0

ARCH 30388 CLOSING 155 0

RFS 32195 IDLE 0 0

RFS 32193 IDLE 0 0

RFS 32191 IDLE 0 0

可看到RFS進(jìn)程已經(jīng)建立，說明傳輸沒有問題。(如果傳輸有問題，可結(jié)合備庫的alert日志進(jìn)行處理，應(yīng)該就是密碼文件的問題)

10.級聯(lián)備庫啟動實時應(yīng)用

啟動日志應(yīng)用：

alter database recover managed standby database disconnect;

這個命令指示備庫開始使用歸檔日志文件進(jìn)行恢復(fù)。

待歸檔日志應(yīng)用完畢后，啟動實時應(yīng)用：

SQL> alter database recover managed standby database cancel;

SQL> alter database open;

SQL> alter database recover managed standby database using current logfile disconnect; - -雖然語句執(zhí)行后MRP進(jìn)程啟動成功，但驗證下來還是沒有真正實時應(yīng)用日志。

驗證實時應(yīng)用情況：

SQL> SELECT * FROM V$DATAGUARD_STATS;

NAME VALUE UNIT TIME_COMPUTED DATUM_TIME

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

transport lag +00 00:05:22 day(2) to second(0) interval 11/01/2018 17:44:19 11/01/2018 17:43:28

apply lag +00 00:05:22 day(2) to second(0) interval 11/01/2018 17:44:19 11/01/2018 17:43:28

apply finish time day(2) to second(3) interval 11/01/2018 17:44:19

estimated startup time 11 second

注意：Oracle 11g的級聯(lián)備庫是不支持實時應(yīng)用的，要等源庫日志切換后才會應(yīng)用。Oracle 12c的級聯(lián)備庫支持實時應(yīng)用。

名稱欄目：跨平臺級聯(lián)dataguard配置
本文鏈接：http://chinadenli.net/article2/jhjjoc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站設(shè)計公司、網(wǎng)站策劃、網(wǎng)站制作、網(wǎng)站維護(hù)、、軟件開發(fā)

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

猜你還喜歡下面的內(nèi)容

欧美一区二区三区老妇人-欧美做爰猛烈大尺度电-99久久夜色精品国产亚洲a-亚洲福利视频一区二区

跨平臺級聯(lián)dataguard配置