oracle ocm dba手冊(cè)-包括tunning等課件les flashback執(zhí)行閃回?cái)?shù)據(jù)庫(kù)到一個(gè)時(shí)間點(diǎn)上

閃回技術(shù):閃回技術(shù):閃課程目標(biāo)RecyclebinFlashbackDBConfig.FBDB截?cái)啾肀肀礤e(cuò)誤地執(zhí)行一條語(yǔ)句FLASHBACKTOBEFOREDROPTABLE回收4312DROPTABLE被重命不能被移重建被丟棄的表和從屬對(duì)象如果有多個(gè)回收站具有相同的原名當(dāng)使用原名時(shí)，表用后進(jìn)先除的方 如果名稱是當(dāng)前被使用的，就要重命名原名FLASHBACKTABLETOBEFOREDROP[RENAMETO回收站回收站2DBA_FREE_SPACE-RECYCLEBIN擴(kuò)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ù)庫(kù)閃回:數(shù)據(jù)庫(kù)閃回操作用戶產(chǎn)生錯(cuò)數(shù)據(jù)庫(kù)被損你“按下倒帶按鈕” 數(shù)據(jù)庫(kù)“口Recycle>FlashbackDBConfig.FBDBMonitorFBDBGuar.Res.Pt.重做日志緩沖器重做日志緩沖器閃回緩沖器高速緩 閃回日志重做日志1改前的圖象21.配置閃回恢復(fù)區(qū)2.設(shè)置保留對(duì)象3.啟用數(shù)據(jù)庫(kù)閃回SQL>SHUTDOWNIMMEDIATE;SQL>STARTUPMOUNTEXCLUSIVE;SQL>ALTERSYSTEMSET2DB_FLASHBACK_RETENTION_TARGET=2880SCOPE=BOTH;SQL>ALTERDATABASEFLASHBACKON;SQL>ALTERDATABASERecyclebin>Config.FBDBMonitorFBDBGuar.Res.Pt.確保該數(shù)據(jù)庫(kù)是在ARCHIVELOG模啟動(dòng)閃回日志并指定閃回區(qū)域數(shù)據(jù)庫(kù)閃回:數(shù)據(jù)庫(kù)閃回: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選擇對(duì)象和操作類型啟用恢復(fù)向?qū)QL>SELECTname,2 ALTERTABLESPACE<ts_name>FLASHBACK當(dāng)閃回?cái)?shù)據(jù)庫(kù)操作完成,打開(kāi)數(shù)據(jù)庫(kù)RESETLOGS“閃回”和“恢復(fù)”在下列情況下你不能使用閃回?cái)?shù)據(jù)庫(kù)控制文件已經(jīng)恢復(fù)或重新創(chuàng)建一個(gè)表空間已經(jīng)被停止一個(gè)數(shù)據(jù)文件已經(jīng)被收縮TOBEFORERESETLOGS閃回到最后一次RESETLOGS作之前SQL>SQL>SELECT2,3 SQL>SELECT2監(jiān)測(cè)性能，以滿足你的保留對(duì)象–查看快速恢復(fù)區(qū)的磁盤限額–確定當(dāng)前的閃回窗口–在數(shù)據(jù)庫(kù)閃回日志中監(jiān)測(cè)記錄SQL>SELECT RecyclebinFlashbackDB>MonitorFBDBFLASHBACKDATABASE命令FLASHBACKDATABASE