單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(3)
單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(1):http://space.itpub.net/81227/viewspace-706435
單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(2):http://space.itpub.net/81227/viewspace-706748
2.檢查待轉換邏輯Standby的日誌應用情況
查詢重做日誌的應用情況,可以透過V$LOGSTDBY_PROGRESS檢視進行,例如:
SQL> SELECT APPLIED_SCN,LATEST_SCN FROM V$LOGSTDBY_PROGRESS;
APPLIED_SCN LATEST_SCN
----------- ----------
598967 598967
如果返回的結果中顯示,兩列的列值一致,則表示所有接收到的重做日誌都已經應用。如果不一致的話,啟動邏輯Standby端的SQL應用。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/81227/viewspace-706749/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(6)LinuxOracle
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(5)LinuxOracle
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(4)LinuxOracle
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(2)LinuxOracle
- 單機Linux平臺Oracle 10g DataGuard Logical Standby 搭建例項LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(3)LinuxOracle 10g
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(3)LinuxOracle
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(10)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(9)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(8)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(7)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(6)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(5)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(4)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(2)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(1)LinuxOracle 10g
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(7)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(6)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(5)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(4)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(2)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(1)LinuxOracle
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項-3OracleLinux
- 【DG】在Linux平臺上搭建單例項的dataguard--duplicateLinux單例
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項OracleLinux
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項 -2OracleLinux
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項 -1OracleLinux
- 【DG】在Linux平臺上搭建單例項的dataguard--rman還原方式Linux單例
- DataGuard:Logical Standby Switchover
- DataGuard:Logical Standby FailoverAI
- Oracle10g RAC環境下 DataGuard備庫搭建例項-3-eygleOracle
- Oracle11g 搭建單例項DataGuardOracle單例
- Oracle10g logical standby 建立Oracle
- Oracle 10G windows 平臺 DataGuard 例項Oracle 10gWindows
- Oracle10g RAC環境下DataGuard備庫搭建例項Oracle
- 配置 Oracle 10g 單例項物理dataguard和邏輯standbyOracle 10g單例
- Oracle10g RAC環境下DataGuard備庫搭建例項-eygleOracle
- 虛擬機器下搭建Linux Oracle10g DataGuard虛擬機LinuxOracle