Oracle DataGuard switchover切換一例
Oracle DataGuard switchover切換一例
做DG的切換測試,發現了一些有趣的小問題,寥作記錄
1.主庫當時歸檔日誌狀態
2.備庫當時歸檔日誌狀態
3.此時進行切換
主庫的alert日誌
這時主庫做了一次日誌切換,加入EOR標記,並傳輸日誌到所有備庫,然後檢查確認所有備庫全部接受到所有的redo
這時查詢備庫
85號日誌確實已經收到並且應用,備庫alert如下
收到85號日誌之後,與主庫失去聯絡,在應用85號日誌的時候遇到EOR標記
備庫切換為主庫
新主庫alert
新主庫開啟的時候向主庫傳輸86號日誌被拒絕,這裡我猜測是一個gap檢測的問題,至於為何報錯,暫時沒搞清楚,我覺得出現了FAL應該是備庫檢測到gap來請求日誌的,但為何拒絕不甚清楚,而在新備庫的日誌卻發現是接受成功的
可見86,87已經接收到了
下一刻便開始正常傳輸了,主庫日誌資訊如下:
有一個歸檔目的地2啟用的提示,難道是一開始未啟用?
此時再來看一下歸檔日誌資訊
新主庫:
備庫歸檔目的地86,97兩個日誌的FAL都是yes,而且在新主庫檢視切換期間產生的84,85兩個日誌的applied狀態為yes,而在新備庫(原主庫)查詢84,85在新主庫(原備庫)的applied狀態卻為NO,很有意思的一個現象
新備庫:
總結:
1.switchover前後每個主庫角色都會切換1次日誌(本次實驗為準,並不絕對)
2.新主庫產生的前2個日誌是以FAL方式傳輸到備庫
3.在原主庫查詢switcover之前產生的兩個日誌的applied狀態時為NO,而在新的主庫(原備庫)查詢日誌的應用狀態是為YES的
關於本文中提到的FAL報錯的問題,希望廣大DBA朋友幫助解惑,如文中還有其他錯誤之處,還望批評指正
做DG的切換測試,發現了一些有趣的小問題,寥作記錄
1.主庫當時歸檔日誌狀態
2.備庫當時歸檔日誌狀態
3.此時進行切換
主庫的alert日誌
- Tue Feb 16 14:55:15 2016
- ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY
- ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 5441] (minstd)
- Waiting for all non-current ORLs to be archived...
- All non-current ORLs have been archived.
- Waiting for all FAL entries to be archived...
- All FAL entries have been archived.
- Waiting for potential Physical Standby switchover target to become synchronized...
- Active, synchronized Physical Standby switchover target has been identified
- Switchover End-Of-Redo Log thread 1 sequence 85 has been fixed
- Switchover: Primary highest seen SCN set to 0x0.0x101743
- ARCH: Noswitch archival of thread 1, sequence 85
- ARCH: End-Of-Redo Branch archival of thread 1 sequence 85
- ARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
- ARCH: Standby redo logfile selected for thread 1 sequence 85 for destination LOG_ARCHIVE_DEST_2
- Archived Log entry 17 added for thread 1 sequence 85 ID 0x97bd9e7c dest 1:
- ARCH: Archiving is disabled due to current logfile archival
- Primary will check for some target standby to have received alls redo
- Final check for a synchronized target standby. Check will be made once.
- LOG_ARCHIVE_DEST_2 is a potential Physical Standby switchover target
- Active, synchronized target has been identified
- Target has also received all redo
這時查詢備庫
85號日誌確實已經收到並且應用,備庫alert如下
- Tue Feb 16 14:52:22 2016
- Archived Log entry 19 added for thread 1 sequence 84 ID 0x97bd9e7c dest 1:
- Media Recovery Waiting for thread 1 sequence 85 (in transit)
- Recovery of Online Redo Log: Thread 1 Group 4 Seq 85 Reading mem 0
- Mem# 0: /u01/app/oradata/min/stdb_redo01.log
- Tue Feb 16 14:55:17 2016
- RFS[5]: Assigned to RFS process 7837
- RFS[5]: Selected log 4 for thread 1 sequence 85 dbid -1749202365 branch 903912515
- Tue Feb 16 14:55:17 2016
- Archived Log entry 20 added for thread 1 sequence 85 ID 0x97bd9e7c dest 1:
- Tue Feb 16 14:55:17 2016
- RFS[2]: Possible network disconnect with primary database
- Tue Feb 16 14:55:17 2016
- RFS[6]: Assigned to RFS process 7782
- RFS[6]: Possible network disconnect with primary database
- Tue Feb 16 14:55:17 2016
- RFS[1]: Possible network disconnect with primary database
- Tue Feb 16 14:55:17 2016
- RFS[7]: Assigned to RFS process 7835
- RFS[7]: Possible network disconnect with primary database
- Tue Feb 16 14:55:17 2016
- Resetting standby activation ID 2545786492 (0x97bd9e7c)
- Media Recovery End-Of-Redo indicator encountered
- Media Recovery Continuing
- Media Recovery Waiting for thread 1 sequence 86
備庫切換為主庫
新主庫alert
- ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN
- ALTER DATABASE SWITCHOVER TO PRIMARY (min)
- Maximum wait for role transition is 15 minutes.
- All dispatchers and shared servers shutdown
- CLOSE: killing server sessions.
- CLOSE: all sessions shutdown successfully.
- Tue Feb 16 15:00:29 2016
- SMON: disabling cache recovery
- Backup controlfile written to trace file /home/oracle/app/oracle/diag/rdbms/min/min/trace/min_ora_7726.trc
- SwitchOver after complete recovery through change 1054531
- Online log /u01/app/oradata/min/redo01.log: Thread 1 Group 1 was previously cleared
- Online log /u01/app/oradata/min/redo02.log: Thread 1 Group 2 was previously cleared
- Online log /u01/app/oradata/min/redo03.log: Thread 1 Group 3 was previously cleared
- Standby became primary SCN: 1054529
- AUDIT_TRAIL initialization parameter is changed back to its original value as specified in the parameter file.
- Switchover: Complete - Database mounted as primary
- Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN
- Tue Feb 16 15:00:42 2016
- alter database open
- Tue Feb 16 15:00:42 2016
- Assigning activation ID 2545831887 (0x97be4fcf)
- Thread 1 advanced to log sequence 87 (thread open)
- Tue Feb 16 15:00:42 2016
- ARC8: Becoming the 'no SRL' ARCH
- Thread 1 opened at log sequence 87
- Current log# 2 seq# 87 mem# 0: /u01/app/oradata/min/redo02.log
- Successful open of redo thread 1
- MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
- Tue Feb 16 15:00:42 2016
- ARC9: Becoming the 'no SRL' ARCH
- Tue Feb 16 15:00:42 2016
- ARCa: Becoming the 'no SRL' ARCH
- Tue Feb 16 15:00:42 2016
- SMON: enabling cache recovery
- Archived Log entry 21 added for thread 1 sequence 86 ID 0x97be4fcf dest 1:
- Tue Feb 16 15:00:42 2016
- ARCt: Becoming the 'no SRL' ARCH
- Tue Feb 16 15:00:42 2016
- NSA2 started with pid=18, OS id=7850
- [7726] Successfully onlined Undo Tablespace 2.
- Undo initialization finished serial:0 start:86759444 end:86759474 diff:30 (0 seconds)
- Dictionary check beginning
- Dictionary check complete
- Verifying file header compatibility for 11g tablespace encryption..
- Verifying 11g file header compatibility for tablespace encryption completed
- SMON: enabling tx recovery
- Database Characterset is ZHS16GBK
- Starting background process SMCO
- Tue Feb 16 15:00:42 2016
- idle dispatcher 'D000' terminated, pid = (17, 1)
- ARCt: Standby redo logfile selected for thread 1 sequence 86 for destination LOG_ARCHIVE_DEST_2
- Tue Feb 16 15:00:42 2016
- SMCO started with pid=50, OS id=7852
- No Resource Manager plan active
- Starting background process QMNC
- Tue Feb 16 15:00:42 2016
- QMNC started with pid=52, OS id=7856
- LOGSTDBY: Validating controlfile with logical metadata
- LOGSTDBY: Validation complete
- Completed: alter database open
- Tue Feb 16 15:00:43 2016
- ARC0: Becoming the 'no SRL' ARCH
- Tue Feb 16 15:00:43 2016
- ARC1: Becoming the 'no SRL' ARCH
- ARC0: Archive log rejected (thread 1 sequence 86) at host 'minstd'
- FAL[server, ARC0]: FAL archive failed, see trace file.
- ARCH: FAL archive failed. Archiver continuing
- ORACLE Instance min - Archival Error. Archiver continuing.
- Thread 1 advanced to log sequence 88 (LGWR switch)
- Current log# 3 seq# 88 mem# 0: /u01/app/oradata/min/redo03.log
- Tue Feb 16 15:00:45 2016
- ARC2: Becoming the 'no SRL' ARCH
- Archived Log entry 23 added for thread 1 sequence 87 ID 0x97be4fcf dest 1:
- Tue Feb 16 15:00:45 2016
- ARC3: Becoming the 'no SRL' ARCH
- ARC3: Standby redo logfile selected for thread 1 sequence 87 for destination LOG_ARCHIVE_DEST_2
- ******************************************************************
- LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
- ******************************************************************
- LNS: Standby redo logfile selected for thread 1 sequence 88 for destination LOG_ARCHIVE_DEST_2
- Tue Feb 16 15:01:05 2016
- ARCr: Becoming the 'no SRL' ARCH
- Tue Feb 16 15:00:42 2016
- Using STANDBY_ARCHIVE_DEST parameter default value as /u01/app/archive
- RFS[1]: Assigned to RFS process 5901
- RFS[1]: Selected log 4 for thread 1 sequence 86 dbid -1749202365 branch 903912515
- Tue Feb 16 15:00:42 2016
- Archived Log entry 19 added for thread 1 sequence 86 ID 0x97be4fcf dest 1:
- Tue Feb 16 15:00:45 2016
- RFS[2]: Assigned to RFS process 5905
- RFS[2]: Selected log 4 for thread 1 sequence 87 dbid -1749202365 branch 903912515
- Tue Feb 16 15:00:45 2016
- Archived Log entry 20 added for thread 1 sequence 87 ID 0x97be4fcf dest 1:
- Tue Feb 16 15:00:45 2016
- Primary database is in MAXIMUM PERFORMANCE mode
- RFS[3]: Assigned to RFS process 5907
- RFS[3]: Selected log 4 for thread 1 sequence 88 dbid -1749202365 branch 903912515
- Tue Feb 16 15:01:36 2016
- ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE disconnect
- Attempt to start background Managed Standby Recovery process (minstd)
- Tue Feb 16 15:01:36 2016
- MRP0 started with pid=55, OS id=5923
- MRP0: Background Managed Standby Recovery process started (minstd)
- started logmerger process
下一刻便開始正常傳輸了,主庫日誌資訊如下:
- Tue Feb 16 15:00:45 2016
- ARC3: Becoming the 'no SRL' ARCH
- ARC3: Standby redo logfile selected for thread 1 sequence 87 for destination LOG_ARCHIVE_DEST_2
- ******************************************************************
- LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
- ******************************************************************
- LNS: Standby redo logfile selected for thread 1 sequence 88 for destination LOG_ARCHIVE_DEST_2
- Tue Feb 16 15:01:05 2016
- ARCr: Becoming the 'no SRL' ARCH
此時再來看一下歸檔日誌資訊
新主庫:
備庫歸檔目的地86,97兩個日誌的FAL都是yes,而且在新主庫檢視切換期間產生的84,85兩個日誌的applied狀態為yes,而在新備庫(原主庫)查詢84,85在新主庫(原備庫)的applied狀態卻為NO,很有意思的一個現象
新備庫:
總結:
1.switchover前後每個主庫角色都會切換1次日誌(本次實驗為準,並不絕對)
2.新主庫產生的前2個日誌是以FAL方式傳輸到備庫
3.在原主庫查詢switcover之前產生的兩個日誌的applied狀態時為NO,而在新的主庫(原備庫)查詢日誌的應用狀態是為YES的
關於本文中提到的FAL報錯的問題,希望廣大DBA朋友幫助解惑,如文中還有其他錯誤之處,還望批評指正
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26838672/viewspace-1989656/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle DataGuard 主備切換 (switchover) oracle11gOracle
- 【DATAGUARD】物理dg的switchover切換(五)
- DataGuard---->物理StandBy的角色切換之switchover
- oracle dataguard 切換Oracle
- Oracle 10g DataGuard物理主備切換-switchover與failoverOracle 10gAI
- DATAGUARD在做SWITCHOVER切換時遇到問題總結
- dataguard角色轉換—switchover
- Oracle DataGuard切換步驟Oracle
- oracle 之dataguard standby 切換Oracle
- 物理dataguard 正常切換 角色轉換,switchover_status 狀態改變
- 【DataGuard】使用Grid Control對Oracle物理Data Guard進行Switchover切換Oracle
- 【DataGuard】Oracle 11g DataGuard 角色轉換(一)物理備庫SwitchoverOracle
- 物理dataguard 正常切換 腳色轉換,switchover_status 狀態改變
- oracle11g dataguard切換Oracle
- 【DataGuard】Oracle DataGuard 資料保護模式切換Oracle模式
- dataguard手動switchover切換步驟及注意的問題 轉
- 【DataGuard】10g物理standby主備switchover方式切換詳述
- Dataguard物理Standby Switchover 角色轉換
- 備庫的切換狀態為SWITCHOVER PENDING時進行dataguard主備庫角色切換
- Oracle 11g dg switchover切換操作流程Oracle
- Oracle 11.2.0.4 physical dataguard和snapshot dataguard切換Oracle
- DataGuard SwitchOver
- dataguard主備switchover互切實驗及理解
- oracle dataguard 進行switchover測試Oracle
- Oracle物理DG自動切換——Dataguard Broker配置Oracle
- 【DataGuard】Oracle 11g physical standby switchoverOracle
- 【DATAGUARD】Oracle Dataguard物理備庫切換最佳實踐(sqlplus)OracleSQL
- DATA GUARD物理STANDBY的 SWITCHOVER切換
- RAC環境STANDBY的SWITCHOVER切換
- DataGuard切換保護模式模式
- ORACLE 11g dataguard系列,手工切換測試Oracle
- DataGuard:Physical Standby Switchover
- oracle11g dataguard完全手冊--switchoverOracle
- Oracle 11g Active Dataguard Switchover實驗Oracle
- 【DG】Data Guard主備庫Switchover切換
- DATA GUARD物理備庫的SWITCHOVER切換
- DATA GUARD物理STANDBY的 SWITCHOVER切換[zt]
- oracle 9iDATA GUARD物理STANDBY的 SWITCHOVER切換步驟Oracle