oracle ocm dba手冊-包括tunning等課件les flashback執(zhí)行閃回數(shù)據(jù)庫到一個時間點上

閃回技術:閃回技術:閃課程目標RecyclebinFlashbackDBConfig.FBDB截斷表表表錯誤地執(zhí)行一條語句FLASHBACKTOBEFOREDROPTABLE回收4312DROPTABLE被重命不能被移重建被丟棄的表和從屬對象如果有多個回收站具有相同的原名當使用原名時，表用后進先除的方 如果名稱是當前被使用的，就要重命名原名FLASHBACKTABLETOBEFOREDROP[RENAMETO回收站回收站2DBA_FREE_SPACE-RECYCLEBIN擴3BIN$zbrdpw==$0BIN$zb回收站PURGEPURGETABLESPACE<ts_name>[USERPURGE{TABLE<table_name>|INDEXDROPUSER<user_name>[CASCADE]DROPTABLESPACE<ts_name>[INCLUDINGCONTENTS];DROPTABLE<table_name>[PURGE]SQL>SHOWSELECToriginal_name,type,ts_name,droptime,related,spaceFROMuser_recyclebinWHEREcan_undrop=SELECTowner,original_name,object_name,type,ts_name,droptime,related,spaceFROMdba_recyclebinWHEREcan_undrop='YES'; 回收 SELECTFROM"BIN$zbjrBdpw==$0"[ASOF...]WHERE...數(shù)據(jù)庫閃回:數(shù)據(jù)庫閃回操作用戶產(chǎn)生錯數(shù)據(jù)庫被損你“按下倒帶按鈕” 數(shù)據(jù)庫“口Recycle>FlashbackDBConfig.FBDBMonitorFBDBGuar.Res.Pt.重做日志緩沖器重做日志緩沖器閃回緩沖器高速緩 閃回日志重做日志1改前的圖象21.配置閃回恢復區(qū)2.設置保留對象3.啟用數(shù)據(jù)庫閃回SQL>SHUTDOWNIMMEDIATE;SQL>STARTUPMOUNTEXCLUSIVE;SQL>ALTERSYSTEMSET2DB_FLASHBACK_RETENTION_TARGET=2880SCOPE=BOTH;SQL>ALTERDATABASEFLASHBACKON;SQL>ALTERDATABASERecyclebin>Config.FBDBMonitorFBDBGuar.Res.Pt.確保該數(shù)據(jù)庫是在ARCHIVELOG模啟動閃回日志并指定閃回區(qū)域數(shù)據(jù)庫閃回:數(shù)據(jù)庫閃回:SQL>FLASHBACK2TOTIMESTAMP(SYSDATE-1/24);SQL>FLASHBACKDATABASETOSCN53943;SQL>FLASHBACKDATABASETORESTOREPOINTRMAN>FLASHBACKDATABASETOTIME=2>"TO_DATE('2004-05-2716:00:00',3>'YYYY-MM-DDRMAN>FLASHBACKDATABASETOSCN=23565;RMAN>FLASHBACKDATABASE2>TOSEQUENCE=223EM選擇對象和操作類型啟用恢復向?qū)QL>SELECTname,2 ALTERTABLESPACE<ts_name>FLASHBACK當閃回數(shù)據(jù)庫操作完成,打開數(shù)據(jù)庫RESETLOGS“閃回”和“恢復”在下列情況下你不能使用閃回數(shù)據(jù)庫控制文件已經(jīng)恢復或重新創(chuàng)建一個表空間已經(jīng)被停止一個數(shù)據(jù)文件已經(jīng)被收縮TOBEFORERESETLOGS閃回到最后一次RESETLOGS作之前SQL>SQL>SELECT2,3 SQL>SELECT2監(jiān)測性能，以滿足你的保留對象–查看快速恢復區(qū)的磁盤限額–確定當前的閃回窗口–在數(shù)據(jù)庫閃回日志中監(jiān)測記錄SQL>SELECT RecyclebinFlashbackDB>MonitorFBDBFLASHBACKDATABASE命令FLASHBACKDATABASE