oracle學(xué)習(xí)資料-資料下載頁
2025-06-29 06:37本頁面
【正文】 stance。、日志傳送狀態(tài)監(jiān)控1 主庫察看當(dāng)前日志狀況SQL select sequence,status from v$log。2 備庫察看RFS(Remote File Service)接收日志情況和MRP 應(yīng)用日志同步主庫情況SQL SELECT PROCESS, STATUS, THREAD, SEQUENCE, BLOCK, BLOCKSFROM V$MANAGED_STANDBY。3 察看備庫是否和主庫同步SQL SELECT ARCHIVED_THREAD, ARCHIVED_SEQ, APPLIED_THREAD,APPLIED_SEQ FROM V$ARCHIVE_DEST_STATUS。4 察看備庫已經(jīng)歸檔的redoSQL SELECT REGISTRAR, CREATOR, THREAD, SEQUENCE, FIRST_CHANGE,NEXT_CHANGE FROM V$ARCHIVED_LOG。5 察看備庫已經(jīng)應(yīng)用的redoSQL SELECT THREAD, SEQUENCE, FIRST_CHANGE, NEXT_CHANGEFROM V$LOG_HISTORY。6 察看備庫接收,應(yīng)用redo 數(shù)據(jù)過程.SQL SELECT MESSAGE FROM V$DATAGUARD_STATUS。 備庫歸檔目錄維護1 找到備庫歸檔目錄SQL show parameter log_archive_dest_12 維護策略每周2,4,7 刪除已經(jīng)應(yīng)用的歸檔文件具體參見附錄二主庫正常切換1 在主庫端檢驗數(shù)據(jù)庫可切換狀態(tài)SQL SELECT SWITCHOVER_STATUS FROM V$DATABASE。SWITCHOVER_STATUS:TO STANDBY 表示可以正常切換.如果SWITCHOVER_STATUS 的值為SESSIONS ACTIVE,表示當(dāng)前有會話處于ACTIVE狀態(tài)2 開始主庫正常切換如果SWITCHOVER_STATUS 的值為TO STANDBY 則:SQL ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY。如果SWITCHOVER_STATUS 的值為SESSIONS ACTIVE 則:SQL ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSIONSHUTDOWN。成功運行這個命令后，主庫被修改為備庫3 重啟先前的主庫SQL SHUTDOWN IMMEDIATE。SQL STARTUP MOUNT。4 在備庫驗證可切換狀態(tài)SQL SELECT SWITCHOVER_STATUS FROM V$DATABASE。SWITCHOVER_STATUSTO_PRIMARY1 row selected5 將目標(biāo)備庫轉(zhuǎn)換為主庫如果SWITCHOVER_STATUS 的值為TO STANDBY 則:SQL ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY。如果SWITCHOVER_STATUS 的值為SESSIONS ACTIVE 則:SQL ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN。成功運行這個命令后，備庫被修改為主庫6 重啟目標(biāo)備庫SQL SHUTDOWN IMMEDIATE。SQL STARTUP。7 先前主庫啟動日志傳送進程SQL alter database recover managed standby database disconnect?？偨Y(jié): ,原先的主庫變?yōu)閭鋷?原先的備庫變?yōu)橹鲙?1 主庫切換為備庫在主庫上運行腳本/admin/dataGuard/switchover/2 備庫切換為主庫在備庫上運行腳本/admin/dataGuard/switchover/腳本1 成功運行后,再運行腳本2,不能同時運行兩個腳本.經(jīng)過這次切換后原來的主庫變?yōu)閭鋷?原先的備庫變?yōu)橹鲾?shù)據(jù)并且OPEN 對應(yīng)用提供服務(wù).3 復(fù)原最初狀態(tài)在原備庫上運行腳本/admin/dataGuard/switchover/成功完成后在原主庫上運行腳本/admin/dataGuard/switchover/主庫災(zāi)難切換通過運行腳本實現(xiàn)主庫災(zāi)難切換SQLalter database recover managed standby database cancel。SQLshutdown immediateSQLstartup mountSQLALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE。SQLalter database recover managed standby database finish。 switchSQLalter database mit to switchover to primary with session shutdown。 openSQLshutdown immediateSQLstartup13 / 1
畢業(yè)設(shè)計相關(guān)推薦
鄂ICP備17016276號-1