Real Application Test(RAT)
利用RAT,可以將Primary上的工作負載,在Standby上進行“回放”。這在做變更測試時非常有用,因為免去了主庫上的變更。
1)分別啟動主備上的dbconsole,如果沒有配置,則用如下方法配置dbconsole。
2)在Standby上,將物理備用轉為快照備用(mount模式下取消DG,轉為快照備用,然後就可以open開啟資料庫了)
參考:http://blog.itpub.net/22621861/viewspace-1380091/
3)在Primary,登入dbcontrol,進入Software and Support->Real Application Testing->Database Replay->Capture Workload……
4)停止捕獲
5)將捕獲目錄傳到Standby伺服器上
6)在Standby上,預處理(Preprocess)
7)在Standby建立還原點,這是為了能在Standby上多次replay工作負載
8)開始Replay,其中會要求建立客戶端連線到資料庫。使用Oracle提供的wrc工具作為客戶端。
9)完成後可以做測試,如果需要倒回還原點,
10)結束測試後,刪除還原點
11)將快照備用轉為物理備用
1)分別啟動主備上的dbconsole,如果沒有配置,則用如下方法配置dbconsole。
點選(此處)摺疊或開啟
- emca -config dbcontrol db -repos recreate
參考:http://blog.itpub.net/22621861/viewspace-1380091/
點選(此處)摺疊或開啟
- alter database recover managed standby database cancel;
-
alter database convert to snapshot standby;
4)停止捕獲
5)將捕獲目錄傳到Standby伺服器上
6)在Standby上,預處理(Preprocess)
7)在Standby建立還原點,這是為了能在Standby上多次replay工作負載
點選(此處)摺疊或開啟
- create restore point beforereplay guarantee flashback database;
- shutdown immediate
- startup
點選(此處)摺疊或開啟
-
wrc mode=calibrate REPLAYDIR=/oradata/rat
- wrc REPLAYDIR=/oradata/rat userid=hk password=hk
點選(此處)摺疊或開啟
-
shutdown immediate
-
startup mount
-
flashback database to restore point beforereplay;
- alter database open resetlogs;
點選(此處)摺疊或開啟
- drop restore point beforereplay;
點選(此處)摺疊或開啟
- shutdown immediate
- startup mount
- alter database convert to physical standby;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22621861/viewspace-1384212/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RAT(Oracle Real Application Testing)時ORA 600報錯處理OracleAPP
- 【RAT】Oracle Real Application Testing(真用應用測試)介紹OracleAPP
- Oracle Real Application Clusters GFSOracleAPP
- How a Database Is Mounted with Real Application Clusters (294)DatabaseAPP
- CRS and 10g Real Application ClustersAPP
- Split Brain in Oracle Clusterware and Real Application ClusterAIOracleAPP
- oracle real cluster application install on windows with VMweaverOracleAPPWindows
- Deinstallation Tool for Oracle Clusterware and Oracle Real Application ClustersOracleAPP
- ORA-00439: feature not enabled: Real Application ClustersAPP
- 尋找Web Application的Test Plan TemplateWebAPP
- Read Consistency with Real Application Clusters (314)APP
- Oracle Real Application Testing之DB Replay實踐案例OracleAPP
- oracle rat spaOracle
- oracle real application clusters and administration and deployment guide 7-13OracleAPPGUIIDE
- Using Real Application Testing Functionality in Earlier Releases_560977.1APPFunction
- oracle rat database replayOracleDatabase
- Configuring Raw Devices for Real Application Clusters on Linux_246205.1devAPPLinux
- RAT手冊總結
- Clone Madison 12R TEST application with customized data file locationAPPZed
- zt_real application cluster恢復為單例項single instanceAPP單例
- zt_oracle10g rac real application cluster+asm修改spfile到新路徑OracleAPPASM
- 10g Hp-ux Oracle Real Application Clusters 安裝和配置指南(1)UXOracleAPP
- zt_oracle10g rac real application cluster ocr and voting disk備份恢復OracleAPP
- Oracle RAT介紹及最佳實踐Oracle
- 對於診斷Oracle Clusterware CRS或GI和Real Application Cluster RAC問題的資料收集OracleAPP
- Please set RAT_ELRACKTYPE and try againAI
- test
- 11g 新特性 real time apply +real time queryAPP
- webservice testWeb
- test_NO
- 查詢real-time apply、real-time query的檢視APP
- Joe Harris is a real problem with this team
- Oracle Real Time SQL MonitorOracleSQL
- 【Android Test】糟心的“Empty test suite ”異常AndroidUI
- Shell test 命令
- JavaScript test() 方法JavaScript
- Spring testSpring
- ACM Coin TestACM