oracle10gr2流復(fù)制操作簡明手冊

1、acle10gR2流復(fù)制流復(fù)制簡明操作手冊簡明操作手冊作者：夏明偉作者：夏明偉二OO八年十月八年十月夏明偉第2頁20198287.1查看數(shù)據(jù)庫對補(bǔ)充日志的設(shè)置情況查看數(shù)據(jù)庫對補(bǔ)充日志的設(shè)置情況...............................................................................................217.2獲取數(shù)據(jù)庫的全局名獲取數(shù)據(jù)庫的全局名......

2、.................................................................................................................217.3獲取數(shù)據(jù)庫的核心初始化參數(shù)值獲取數(shù)據(jù)庫的核心初始化參數(shù)值..........................................................................

3、.........................217.4查詢數(shù)據(jù)庫中所有流的規(guī)則定義查詢數(shù)據(jù)庫中所有流的規(guī)則定義...................................................................................................227.5查詢流進(jìn)程對應(yīng)的正、負(fù)向規(guī)則集和規(guī)則查詢流進(jìn)程對應(yīng)的正、負(fù)向規(guī)則集和規(guī)則......................

4、.............................................................227.6查詢流進(jìn)程是否存在空規(guī)則集查詢流進(jìn)程是否存在空規(guī)則集.......................................................................................................227.7查詢數(shù)據(jù)庫中定義的所有隊列查詢數(shù)據(jù)庫中定

5、義的所有隊列.......................................................................................................227.8查詢所有包含有轉(zhuǎn)換函數(shù)的規(guī)則及規(guī)則集查詢所有包含有轉(zhuǎn)換函數(shù)的規(guī)則及規(guī)則集......................................................................

6、.............227.9查詢所有包含有查詢所有包含有hle的應(yīng)用及庫表的應(yīng)用及庫表..........................................................................................237.10查詢所有設(shè)置了補(bǔ)充日志的表查詢所有設(shè)置了補(bǔ)充日志的表...................................................

7、..................................................237.11查詢所有設(shè)置了補(bǔ)充日志的列查詢所有設(shè)置了補(bǔ)充日志的列.....................................................................................................237.12查詢流復(fù)制的警告信息查詢流復(fù)制的警告信息...........

8、......................................................................................................237.13查詢與流有關(guān)的數(shù)據(jù)對象的建立時間查詢與流有關(guān)的數(shù)據(jù)對象的建立時間................................................................................

9、.........237.14檢查執(zhí)行檢查執(zhí)行MAINTAIN_TABLE|SCHEMA|GLOBAL腳本的錯誤語句腳本的錯誤語句....................................237.15檢查執(zhí)行檢查執(zhí)行MAINTAIN_TABLE|SCHEMA|GLOBAL腳本時的錯誤信息腳本時的錯誤信息................................237.16檢查檢查MAINTAIN腳本的每一步腳本的每一

10、步fward語句和語句和undo語句及狀態(tài)語句及狀態(tài)......................................237.17查詢所有隊列當(dāng)前緩存的記錄數(shù)及累計入列記錄數(shù)查詢所有隊列當(dāng)前緩存的記錄數(shù)及累計入列記錄數(shù).................................................................247.18查詢流復(fù)制不支持的表查詢流復(fù)制不支持的表...............

11、..................................................................................................247.19查詢流復(fù)制處理的數(shù)據(jù)量查詢流復(fù)制處理的數(shù)據(jù)量..............................................................................................

12、...............247.20查詢已定義的捕獲流狀態(tài)及對應(yīng)的捕獲規(guī)則查詢已定義的捕獲流狀態(tài)及對應(yīng)的捕獲規(guī)則.............................................................................247.21查詢已定義的捕獲進(jìn)程的狀態(tài)查詢已定義的捕獲進(jìn)程的狀態(tài)....................................................

13、.................................................247.22查詢捕獲進(jìn)程中的查詢捕獲進(jìn)程中的SCN情況及狀態(tài)和錯誤信息情況及狀態(tài)和錯誤信息.......................................................................247.23查詢捕獲進(jìn)程的參數(shù)設(shè)置情況查詢捕獲進(jìn)程的參數(shù)設(shè)置情況.......................

14、..............................................................................257.24查詢?yōu)椴东@進(jìn)程注冊的日志文件查詢?yōu)椴东@進(jìn)程注冊的日志文件.................................................................................................257.25查詢被捕獲

15、的表及其上補(bǔ)充日志的設(shè)置情況查詢被捕獲的表及其上補(bǔ)充日志的設(shè)置情況.............................................................................257.26查詢被捕獲的用戶及其上補(bǔ)充日志的設(shè)置情況查詢被捕獲的用戶及其上補(bǔ)充日志的設(shè)置情況................................................................

16、.........257.27查詢被捕獲的數(shù)據(jù)庫及其上補(bǔ)充日志的設(shè)置情況查詢被捕獲的數(shù)據(jù)庫及其上補(bǔ)充日志的設(shè)置情況.....................................................................257.28查詢定義的傳播流狀態(tài)及對應(yīng)的傳播規(guī)則查詢定義的傳播流狀態(tài)及對應(yīng)的傳播規(guī)則....................................................

17、.............................257.29查詢定義的應(yīng)用流狀態(tài)及對應(yīng)的應(yīng)用規(guī)則查詢定義的應(yīng)用流狀態(tài)及對應(yīng)的應(yīng)用規(guī)則.................................................................................257.30查詢定義的應(yīng)用進(jìn)程的狀態(tài)查詢定義的應(yīng)用進(jìn)程的狀態(tài)......................................

18、...................................................................257.31查看應(yīng)用進(jìn)程的參數(shù)值查看應(yīng)用進(jìn)程的參數(shù)值.................................................................................................................267.32查詢應(yīng)用進(jìn)程的最

19、新應(yīng)用時間查詢應(yīng)用進(jìn)程的最新應(yīng)用時間.....................................................................................................267.33查詢流應(yīng)用時的報錯信息查詢流應(yīng)用時的報錯信息.........................................................................

20、....................................267.34查詢表級序列化的查詢表級序列化的SCN值...........................................................................................................267.35查詢數(shù)據(jù)庫、用戶級序列化的查詢數(shù)據(jù)庫、用戶級序列化的SCN值...............

21、........................................................................267.36待定待定..........................................................................................................................................

22、.......26八、八、流復(fù)制的維護(hù)流復(fù)制的維護(hù)...........................................................................................................................278.1啟動啟動ApplyPropagation和Capture進(jìn)程的語句進(jìn)程的語句.............................

23、...........................................278.2停止停止ApplyPropagation和Capture進(jìn)程的語句進(jìn)程的語句........................................................................278.3刪除刪除ApplyPropagation和Capture流及隊列和相應(yīng)的規(guī)則集和規(guī)則的語句流及隊列和相應(yīng)的規(guī)則集和

24、規(guī)則的語句........................278.4在本地數(shù)據(jù)庫中清除整個流配置在本地數(shù)據(jù)庫中清除整個流配置...................................................................................................288.5數(shù)據(jù)庫級實(shí)例化過程數(shù)據(jù)庫級實(shí)例化過程....................................