萬盛學電腦網

 萬盛學電腦網 >> 數據庫 >> oracle教程 >> ORACLE-DataGuard系列:邏輯standby搭建

ORACLE-DataGuard系列:邏輯standby搭建

   准備:

  確認對象和語句能被standby支持

  確保primary庫中各表的行可被唯一標識

  環境:

  操作系統:RED HAT LINUX ENTERPRISE 5

  ORACLE: 11.2.0.1.0

  PRIMARY:

  IP: 192.168.1.11

  SID: test

  DB_UNIQUE_NAME:test

  安裝路徑:/oracle/oracle/product/11.2.0/dbhome_1

  本地歸檔路徑:/oracle/oradata/test/archive

  PHYSICS STANDBY:

  IP: 192.168.1.12

  SID: dgtest

  DB_UNIQUE_NAME:dgtest

  安裝路徑:/oracle/oracle/product/11.2.0/dbhome_1

  本地歸檔路徑:/oracle/oradata/dgtest/dgtest/archive

  LOGICAL STANDBY:

  IP: 192.168.1.15

  SID: logicdg

  DB_UNIQUE_NAME: logicdg

  安裝路徑:/oracle/oracle/product/11.2.0/dbhome_1

  本地歸檔路徑:/oracle/oradata/logicdg/local-archive

  本例測試采用物理standby轉邏輯standby的方式在一個已經存在的dataguard環境中新增一台邏輯standby.

  原dataguard環境可參考:

  http://xin23.blog.51cto.com/1827266/504066

  創建新物理standby的過程亦可參照此文。此處不再贅述。

  則目前環境為:

  primary:192.168.1.11

  physics: 192.168.1.12

  logical: 192.168.1.15 (目前為物理standby.待轉換)

  1.修改primary初始化參數文件(僅列出修改部分)

  *.log_archive_dest_state_2=defer

  *.log_archive_dest_state_3=defer

  *.log_archive_config='dg_config=(test,dgtest,logicdg)'

  *.log_archive_dest_2='service=test12 arch valid_for=(online_logfiles,primary_role) db_unique_name=dgtest'

  *.log_archive_dest_3='service=test15 arch valid_for=(online_logfiles,primary_role) db_unique_name=logicdg'

  *.fal_server=test11

  *.fal_client=test12

  *.standby_file_management=auto

  *.db_file_name_convert='/oracle/oradata/test','/oracle/oradata/dgtest/dgtest','/oracle/oradata/test','/

  oracle/oradata/logicdg'

  *.log_file_name_convert='/oracle/oradata/test','/oracle/oradata/dgtest/dgtest','/oracle/oradata/test','/

  oracle/oradata/logicdg'

  2.查看兩台物理standby同步狀態

  physics> select sequence#,applied from v$archived_log;

  SEQUENCE# APPLIED

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

  66 YES

  67 YES

  68 YES

  69 YES

  70 YES

  71 YES

  72 YES

  7 rows selected.

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

  logical> select sequence#,applied from v$archived_log;

  SEQUENCE# APPLIED

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

  67 YES

  68 YES

  69 YES

  70 YES

  71 YES

  72 YES

  6 rows selected.

  3.取消待轉換物理standby的redo應用

  logical> alter database recover managed standby database cancel;

  Database altered.

  4.primary生成數據字典

  primary> execute dbms_logstdby.build;

  PL/SQL procedure successfully completed.

  5.將物理standby轉換為邏輯standby

  logical> alter database recover to logical standby logicdg;

  Database altered.

  logical> shutdown immediate

  ORA-01507: database not mounted

  ORACLE instance shut down.

  logical> startup mount

  ORACLE instance started.

  Total System Global Area 2488635392 bytes

  Fixed Size 2215904 bytes

  Variable Size 1392508960 bytes

  Database Buffers 1090519040 bytes

  Redo Buffers 3391488 bytes

  Database mounted.

  6.調整standby初始化參數

  logical> alter system set log_archive_dest_1='location=/oracle/oradata/logicdg/local-archive valid_for=(online_logfiles,all_roles)

  2 db_unique_name=logicdg';

  System altered.

  logical> alter system set log_archive_dest_5='location=/oracle/oradata/logicdg/archive valid_for=(standby_logfiles,standby_role)

  2 db_unique_name=logicdg';

  System altered.

  7.resetlogs方式打開數據庫

  logical> alter database open resetlogs;

  Database altered.

  8.應用redo

  創建standby redologs

  logical> alter database add standby logfile group 11 '/oracle/oradata/logicdg/standbyredo11.log' size 100m;

  Database altered.

  logical> alter database add standby logfile group 12 '/oracle/oradata/logicdg/standbyredo12.log' size 100m;

  Database altered.

  logical> alter database add standby logfile group 13 '/oracle/oradata/logicdg/standbyredo13.log' size 100m;

  Database altered.

  啟動redo實時應用

  logical> alter database start logical standby apply immediate;

  Database altered.

copyright © 萬盛學電腦網 all rights reserved