oracle10gr2流復制操作簡明手冊

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

2、.................................................................................................................217.3獲取數據庫的核心初始化參數值獲取數據庫的核心初始化參數值..........................................................................

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

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

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

6、.............227.9查詢所有包含有查詢所有包含有hle的應用及庫表的應用及庫表..........................................................................................237.10查詢所有設置了補充日志的表查詢所有設置了補充日志的表...................................................

7、..................................................237.11查詢所有設置了補充日志的列查詢所有設置了補充日志的列.....................................................................................................237.12查詢流復制的警告信息查詢流復制的警告信息...........

8、......................................................................................................237.13查詢與流有關的數據對象的建立時間查詢與流有關的數據對象的建立時間................................................................................

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查詢所有隊列當前緩存的記錄數及累計入列記錄數查詢所有隊列當前緩存的記錄數及累計入列記錄數.................................................................247.18查詢流復制不支持的表查詢流復制不支持的表...............

11、..................................................................................................247.19查詢流復制處理的數據量查詢流復制處理的數據量..............................................................................................

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

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

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

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

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

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

18、...................................................................257.31查看應用進程的參數值查看應用進程的參數值.................................................................................................................267.32查詢應用進程的最

19、新應用時間查詢應用進程的最新應用時間.....................................................................................................267.33查詢流應用時的報錯信息查詢流應用時的報錯信息.........................................................................

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

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

22、.......26八、八、流復制的維護流復制的維護...........................................................................................................................278.1啟動啟動ApplyPropagation和Capture進程的語句進程的語句.............................

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

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