【DG】Oracle11g 異構平臺之

Linux To Windows DataGuard 安裝配置--duplicate

select name , open_mode, log_mode,force_logging,DATABASE_ROLE,switchover_status from v$database;
alter database force logging;
alter database archivelog;
select * from v$standby_log;
select group#,bytes/1024/1024 ||'M' from v$log ;
SELECT * FROM V$LOGFILE;
alter database add standby logfile group 5 ( 'Z:\APP\ADMINISTRATOR\ORADATA\ORCL\standby_redo05A.log','Z:\APP\ADMINISTRATOR\ORADATA\ORCL\standby_redo05B.log') size 100m;
alter database add standby logfile group 6 ( 'Z:\APP\ADMINISTRATOR\ORADATA\ORCL\standby_redo06A.log','Z:\APP\ADMINISTRATOR\ORADATA\ORCL\standby_redo06B.log') size 100m;
alter database add standby logfile group 7 ( 'Z:\APP\ADMINISTRATOR\ORADATA\ORCL\standby_redo07A.log','Z:\APP\ADMINISTRATOR\ORADATA\ORCL\standby_redo07B.log') size 100m;
alter database add standby logfile group 8 ( 'Z:\APP\ADMINISTRATOR\ORADATA\ORCL\standby_redo08A.log','Z:\APP\ADMINISTRATOR\ORADATA\ORCL\standby_redo08B.log') size 100m;
alter database add standby logfile group 9 ( 'Z:\APP\ADMINISTRATOR\ORADATA\ORCL\standby_redo09A.log','Z:\APP\ADMINISTRATOR\ORADATA\ORCL\standby_redo09B.log') size 100m;
 select * from v$standby_log;
alter system set db_unique_name='orcl' scope=spfile;  
alter system set log_archive_config='DG_CONFIG=(orcl,orcldg)';  
alter system set log_archive_dest_1='LOCATION=Z:\archive db_unique_name=orcl valid_for=(ALL_LOGFILES,ALL_ROLES)';  
alter system set log_archive_dest_2='SERVICE=orcldg LGWR ASYNC db_unique_name=orcldg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)';  
alter system set log_archive_dest_state_1=ENABLE;  
alter system set log_archive_dest_state_2=ENABLE;  
alter system set log_archive_max_processes=4;  
alter system set remote_login_passwordfile='EXCLUSIVE' scope=spfile;  
 
alter system set db_file_name_convert='orcldg','orcl' scope=spfile;  
alter system set log_file_name_convert='orcldg','orcl' scope=spfile;  
alter system set standby_file_management='AUTO';  
alter system set fal_server='orcldg';  
alter system set fal_client='orcl'; 
重啟主庫
---------備庫操作
oradim -new -sid orcldg
主備庫配置監聽和tnsnames.ora  ---配置靜態監聽
-由於要求主庫與備庫sys使用相同的密碼，在此處，我們直接複製了主庫的密碼檔案到備庫
echo db_name=orcl >$ORACLE_HOME/database/initorcldg.ora     而且db_name必須相同
建立相關路徑
mkdir D:\app\Administrator\admin\orcldg\adump
mkdir Z:\archive
mkdir Z:\app\Administrator\oradata\orcldg\
set ORACLE_SID=orcldg
services.msc 中 啟動服務
sqlplus sys/wxqhaey as sysdba
startup nomount
rman target sys/wxqhaey@orcl auxiliary sys/wxqhaey@orcldg
duplicate target database 
for standby  nofilenamecheck
from active database 
DORECOVER 
spfile 
set db_unique_name='orcldg'
set log_archive_dest_1='LOCATION=Z:\archive\orcldg  valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=orcldg'
set log_archive_dest_2='service=orcl async lgwr register valid_for=(online_logfile,primary_role) db_unique_name=orcl'
set standby_file_management='AUTO'
set fal_server='orcl'
set fal_client='orcldg'
set control_files='Z:\app\Administrator\oradata\orcldg\control01.ctl','Z:\app\Administrator\oradata\orcldg\control02.ctl'
set db_file_name_convert='orcl','orcldg'
set log_file_name_convert='orcl','orcldg'
set memory_target='161061273600'
set audit_file_dest='D:\app\Administrator\admin\orcldg\adump'
;
-------校驗
select open_mode from v$database;
show parameter instance_name
alter database open;
select * from v$log;
set line 9999
select dbid,name,current_scn,protection_mode,database_role,force_logging,open_mode,switchover_status from v$database;
alter database recover managed standby database using current logfile disconnect;
--主庫切換日誌
ALTER SYSTEM SWITCH LOGFILE; 
orcl.__db_cache_size=104152956928
orcl.__java_pool_size=1879048192
orcl.__large_pool_size=1342177280
orcl.__oracle_base='D:\app\Administrator'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=22548578304
orcl.__sga_target=138512695296
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=29796335616
orcl.__streams_pool_size=536870912
*.audit_file_dest='D:\app\Administrator\admin\orcl\adump'
*.audit_trail='NONE'
*.compatible='11.2.0.4.0'
*.control_files='Z:\app\Administrator\oradata\orcl\control01.ctl','Z:\app\Administrator\oradata\orcl\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.deferred_segment_creation=FALSE
*.diagnostic_dest='D:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=1000
*.log_archive_dest_1='LOCATION=Z:\archive'
*.log_archive_format='ARC%S_%R.%T'
*.memory_target=161061273600
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=21474836480
*.processes=2500
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_case_sensitive_logon=FALSE
*.sessions=2755
*.sga_target=128849018880
*.undo_tablespace='UNDOTBS1'
RUN { 
allocate channel c1 type disk;
allocate channel c2 type disk;
sql 'alter system archive log current';
backup current controlfile for standby format='Z:\backup\20150724\control_%U';
BACKUP FORMAT 'Z:\backup\20150724\oradg_%U_%T.bak' skip inaccessible filesperset 5 DATABASE ; 
sql 'alter system archive log current';
BACKUP FORMAT 'Z:\backup\20150724\arch_%U_%T.bak' skip inaccessible filesperset 5 ARCHIVELOG ALL;
sql "alter database create standby controlfile as ''Z:\backup\20150724\control01.ctl'' reuse";
release channel c2;
release channel c1;
}
sys/wxqhaey
sqlplus sys/wxqhaey as sysdba
orapwd file="D:\app\Administrator\product\11.2.0\dbhome_1\database\PWDorcl.ORA" password=wxqhaey force=y
oradg11g--oradgphy---oradgss--oradgss
 
oradg11g.__db_cache_size=125829120
oradg11g.__java_pool_size=4194304
oradg11g.__large_pool_size=4194304
oradg11g.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
oradg11g.__pga_aggregate_target=83886080
oradg11g.__sga_target=327155712
oradg11g.__shared_io_pool_size=0
oradg11g.__shared_pool_size=184549376
oradg11g.__streams_pool_size=0
audit_file_dest='/u01/app/oracle/admin/oradg11g/adump'
audit_trail='db'
compatible='11.2.0.0.0'
control_files='/u01/app/oracle/oradata//oradg11g/control01.ctl','/u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl'
db_block_size=8192
db_domain=''
rman target sys/lhr@tns_oradgphy auxiliary sys/lhr@tns_oradg11g
duplicate target database 
for standby  nofilenamecheck
from active database 
DORECOVER 
spfile 
set db_unique_name='oradg11g'
set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)'
set log_archive_dest_2='SERVICE=tns_oradgphy LGWR ASYNC db_unique_name=oradgphy valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'
set log_archive_dest_3='SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'
set log_archive_dest_4='SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)'
set log_archive_dest_state_1='ENABLE'
set log_archive_dest_state_2='ENABLE'
set log_archive_dest_state_3='defer'
set log_archive_dest_state_4='defer'
set standby_file_management='AUTO'
set fal_client='oradg11g'
set fal_server='oradgphy'
set control_files='/u01/app/oracle/oradata/oradg11g/control01.ctl','/u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl'
set db_file_name_convert='oradgphy','oradg11g'
set log_file_name_convert='oradgphy','oradg11g'
set memory_target='200M'
set audit_file_dest='/u01/app/oracle/admin/oradg11g/adump'
;
rman target sys/lhr@tns_oradg11g auxiliary sys/lhr@tns_oradglg
duplicate target database 
for standby nofilenamecheck
from active database 
DORECOVER 
spfile 
set db_unique_name='oradglg'
set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST   valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=oradglg'
set standby_file_management='AUTO'
set fal_server='oradg11g'
set fal_client='oradglg'
set control_files='/u01/app/oracle/oradata/oradglg/control01.ctl','/u01/app/oracle/oradata/oradglg/control02.ctl'
set db_file_name_convert='oradg11g','oradglg'
set log_file_name_convert='oradg11g','oradglg'
set memory_target='190M'
;
rman target sys/lhr@tns_oradg11g auxiliary sys/lhr@tns_oradgss
duplicate target database 
for standby nofilenamecheck
from active database 
DORECOVER 
spfile 
set db_unique_name='oradgss'
set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST   valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=oradgss'
set standby_file_management='AUTO'
set fal_server='oradg11g'
set fal_client='oradgss'
set control_files='/u01/app/oracle/oradata/oradgss/control01.ctl','/u01/app/oracle/oradata/oradgss/control02.ctl'
set db_file_name_convert='oradg11g','oradgss'
set log_file_name_convert='oradg11g','oradgss'
set memory_target='190M'
;
duplicate target database 
for standby  nofilenamecheck
from active database 
DORECOVER 
spfile 
set db_unique_name='orcldg'
set log_archive_dest_1='LOCATION=Z:\archive\orcldg  valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=orcldg'
set log_archive_dest_2='service=orcl async lgwr register valid_for=(online_logfile,primary_role) db_unique_name=orcl'
set standby_file_management='AUTO'
set fal_server='orcl'
set fal_client='orcldg'
set control_files='Z:\app\Administrator\oradata\orcldg\control01.ctl','Z:\app\Administrator\oradata\orcldg\control02.ctl'
set db_file_name_convert='orcl','orcldg'
set log_file_name_convert='orcl','orcldg'
set memory_target='161061273600'
set audit_file_dest='D:\app\Administrator\admin\orcldg\adump'
;
alter system set db_unique_name='orcl' scope=spfile;  
alter system set log_archive_config='DG_CONFIG=(orcl,orcldg)';  
alter system set log_archive_dest_1='LOCATION=Z:\archive db_unique_name=orcl valid_for=(ALL_LOGFILES,ALL_ROLES)';  
alter system set log_archive_dest_2='SERVICE=orcldg LGWR ASYNC db_unique_name=orcldg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)';  
alter system set log_archive_dest_state_1=ENABLE;  
alter system set log_archive_dest_state_2=ENABLE;  
alter system set log_archive_max_processes=4;  
alter system set remote_login_passwordfile='EXCLUSIVE' scope=spfile;  
 
alter system set db_file_name_convert='orcldg','orcl' scope=spfile;  
alter system set log_file_name_convert='orcldg','orcl' scope=spfile;  
alter system set standby_file_management='AUTO';  
alter system set fal_server='orcldg';  
alter system set fal_client='orcl'; 
*.log_archive_config='DG_CONFIG=(oradg11g,oradgphy,oradgss,oradgss)'

1 、環境介紹

1.1 、主庫

Ø  作業系統：RedHat Enterprise Linux 5.4 64bit

Ø  IP 地址： 172.168.10.231

Ø  資料庫版本：oracle 11.2.0.3 64bit

Ø  資料庫sid 名： demo1

Ø  資料庫名：demo1

Ø  資料庫db_unique_name demo231

Ø  資料檔案路徑：/oradata/demo1

Ø  歸檔路徑：/oracle/arch

1.2 、備庫

Ø  作業系統：windows server 2003 64bit

Ø  IP 地址： 172.168.10.233

Ø  資料庫版本：oracle 11.2.0.3

Ø  資料庫sid 名： demo1

Ø  資料庫名：demo1

Ø  資料庫db_unique_name ： demo233

Ø  資料檔案路徑：c:\oradata\demo1

Ø  歸檔路徑：c:\oracle\arch

 

2 、 DG 配置準備

2.1 、主庫安裝 oracle 11.2.0.3 資料庫軟體並建立資料庫例項

Ø  安裝oracle 資料庫軟體（略）

Ø  建立資料庫例項（略）

Ø  建立監聽（略）

2.2 、備庫安裝 oracle 11.2.0.3 資料庫軟體

Ø  安裝oracle 資料庫軟體（略）

Ø  建立資料庫例項：oradim -new -sid orcldg

Ø  建立監聽（略）

3 、 DG 配置

3.1 、將主庫設定為歸檔模式

Ø  略

3.2 、設定主庫為強制歸檔模式

Ø  SQL>alter database force logging;

3.3 、主庫監聽配置

Ø  listener.ora

SID_LIST_LISTENER=

  (SID_LIST=

    (SID_DESC=

      (GLOBAL_DBNAME=demo1)

      (ORACLE_HOME=/oracle/product/11.2.0/db_1)

      (SID_NAME=demo1)

    )

    (SID_DESC=

      (SID_NAME=PLSExtProc)

      (ORACLE_HOME=/oracle/product/11.2.0/db_1)

      (PROGRAM=extproc)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

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

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

    )

  )

Ø  tnsnames.ora

DEMO231 =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = demo1)

    )

  )

 

DEMO233 =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = demo1)

    )

  )

3.4 、備庫監聽配置

Ø  listener.ora

SID_LIST_LISTENER=

  (SID_LIST=

    (SID_DESC=

      (GLOBAL_DBNAME=demo1)

      (ORACLE_HOME=C:\oracle\product\11.2.0.3/db_1)

      (SID_NAME=demo1)

    )

    (SID_DESC=

      (SID_NAME=PLSExtProc)

      (ORACLE_HOME=C:\oracle\product\11.2.0.3/db_1)

      (PROGRAM=extproc)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

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

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

    )

  )

Ø  tnsnames.ora

DEMO231 =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = demo1)

    )

  )

 

DEMO233 =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = demo1)

    )

  )

3.5 、主庫初始化引數修改

Ø  生成pfile 檔案（ create pfile from spfile ）

Ø  修改生成的pfile 檔案，新增如下紅色部分內容

demo1.__db_cache_size=205520896

demo1.__java_pool_size=4194304

demo1.__large_pool_size=4194304

demo1.__oracle_base='/oracle'#ORACLE_BASE set from environment

demo1.__pga_aggregate_target=218103808

demo1.__sga_target=327155712

demo1.__shared_io_pool_size=0

demo1.__shared_pool_size=104857600

demo1.__streams_pool_size=0

*.audit_file_dest='/oracle/admin/demo1/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/oradata/demo1/control01.ctl','/oradata/demo1/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='demo1'

*.diagnostic_dest='/oracle'

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

*.log_archive_dest_1='LOCATION=/oracle/arch'

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=545259520

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

*.db_unique_name=demo231

*.log_archive_config='dg_config=(demo231,demo233)'

*.log_archive_dest_1='location=/oracle/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=demo231'

*.log_archive_dest_2='SERVICE=demo233 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=demo233'

*.fal_server=demo233

*.fal_client=demo231

*.log_archive_dest_state_1=ENABLE

*.log_archive_dest_state_2=ENABLE

*.log_archive_max_processes=10

*.standby_file_management=AUTO

*.db_file_name_convert='C:\oradata\demo1','/oradata/demo1'

*.log_file_name_convert='C:\oradata\demo1','/oradata/demo1'

Ø  由pfile 檔案生成 spfile

SQL>shutdown immediate

SQL>create spfile from pfile;

SQL>startup

3.6 、備庫初始化引數修改

Ø  將主庫生成的pfile 檔案傳到備庫，修改如下紅色部分內容

         demo1.__db_cache_size=205520896

demo1.__java_pool_size=4194304

demo1.__large_pool_size=4194304

demo1.__oracle_base='C:\oracle'#ORACLE_BASE set from environment

demo1.__pga_aggregate_target=218103808

demo1.__sga_target=327155712

demo1.__shared_io_pool_size=0

demo1.__shared_pool_size=104857600

demo1.__streams_pool_size=0

*.audit_file_dest='C:\oracle\admin\demo1\adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='C:\oradata\demo1\control01.ctl','C:\oradata\demo1\control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='demo1'

*.diagnostic_dest='C:\oracle'

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

*.log_archive_dest_1='LOCATION=C:\oracle\arch'

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=545259520

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

*.db_unique_name=demo233

*.log_archive_config='dg_config=(demo233,demo231)'

*.log_archive_dest_1='location=C:\oracle\arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=demo233'

*.log_archive_dest_2='SERVICE=demo231 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=demo231'

*.fal_server=demo231

*.fal_client=demo233

*.log_archive_dest_state_1=ENABLE

*.log_archive_dest_state_2=ENABLE

*.log_archive_max_processes=10

*.standby_file_management=AUTO

*.db_file_name_convert='/oradata/demo1','C:\oradata\demo1'

*.log_file_name_convert='/oradata/demo1','C:\oradata\demo1'

Ø  生成備庫spfile檔案

SQL>create spfile from pfile= ’ c:\oracle\initdemo1.ora ’ ;

Ø  將備庫啟動到nomount狀態

SQL>startup nomount

3.7 、新增 standby 日誌組

SQL>alter database add standby logfile group 4

>( ‘ /oradata/demo1/redo04.log ’ ) size 50M ；

SQL>alter database add standby logfile group 5

>(‘/oradata/ demo1 /redo05.log’) size 5 0 M;

SQL>alter database add standby logfile group 6

>(‘/oradata/ demo1 /redo06.log’) size 50 M;

SQL>alter database add standby logfile group 7

>( ‘ /oradata/demo1/redo07.log ’ ) size 50M;

3.8 、在主庫上使用 rman 進行 duplicate 操作

  $ rman target sys/oracle auxiliary  sys/oracle@demo233

RMAN>  DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE NOFILENAMECHECK;  

RMAN 恢復完以後會自動將 standby 資料庫自動切換到 mount 狀態。

3.9 、將備庫置於 ADG 模式下

SQL>   alter database open read only;

SQL> alter database recover managed standby database using current logfile disconnect from session;

3.10 、資料同步測試

Ø  在主庫上以scott 使用者執行

SQL>create table emp_test as select * from emp;

SQL>commit;

Ø  在備庫上以scott 用執行查詢

SQL>select * from emp_test;

4 、主備切換測試

4.1 、主庫上查詢切換狀態（要有 TO STANDBY ）

SQL> select switchover_status from v$database ;

SWITCHOVER_STATUS

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

T O  STANDBY

查詢關閉多餘會話

SQL>  select program,type from v$session where type='USER';

PROGRAM                        TYPE

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

sqlplus@node1 (TNS V1-V3)        USER

4.2 、在主庫上執行切換

SQL>alter database commit to switchover to physical standby;

4.3 、在備庫上執行切換

SQL> alter database commit to switchover to primary ;

如果資料庫處於read only 狀態，則重啟資料庫到 open 狀態

SQL>shutdown immediate

SQL>startup

否則

SQL>alter database open;

4.4 、重啟原主庫到 mount 狀態，並將其置於 ADG 模式下

SQL>  alter database recover managed standby database using current logfile disconnect from session;

 

4.5 、在新主庫上執行日誌切換，檢視日誌是否正常

SQL>ALTER SYSTEM SWITCH LOGFILE;

 

---

---

About Me

........................................................................................................................ ● 本文作者：小麥苗，部分內容整理自網路，若有侵權請聯絡小麥苗刪除 ● 本文在itpub、部落格園、CSDN和個人微 信公眾號（ xiaomaimiaolhr）上有同步更新 ● 本文itpub地址： http://blog.itpub.net/26736162 ● 本文部落格園地址： http://www.cnblogs.com/lhrbest ● 本文CSDN地址： https://blog.csdn.net/lihuarongaini ● 本文pdf版、個人簡介及小麥苗雲盤地址： http://blog.itpub.net/26736162/viewspace-1624453/ ● 資料庫筆試面試題庫及解答： http://blog.itpub.net/26736162/viewspace-2134706/ ● DBA寶典今日頭條號地址： ........................................................................................................................ ● QQ群號： 230161599 、618766405 ● 微 信群：可加我微 信，我拉大家進群，非誠勿擾 ● 聯絡我請加QQ好友 （ 646634621 ），註明新增緣由 ● 於 2019-08-01 06:00 ~ 2019-08-31 24:00 在西安完成 ● 最新修改時間：2019-08-01 06:00 ~ 2019-08-31 24:00 ● 文章內容來源於小麥苗的學習筆記，部分整理自網路，若有侵權或不當之處還請諒解 ● 版權所有，歡迎分享本文，轉載請保留出處 ........................................................................................................................ ● 小麥苗的微店： ● 小麥苗出版的資料庫類叢書： http://blog.itpub.net/26736162/viewspace-2142121/ ● 小麥苗OCP、OCM、高可用網路班： http://blog.itpub.net/26736162/viewspace-2148098/ ● 小麥苗騰訊課堂主頁： https://lhr.ke.qq.com/ ........................................................................................................................ 使用 微 信客戶端掃描下面的二維碼來關注小麥苗的微 信公眾號（ xiaomaimiaolhr）及QQ群（DBA寶典）、新增小麥苗微 信， 學習最實用的資料庫技術。 ........................................................................................................................