摘要：
使用恢复点，闪回数据:恢复点或者叫做还原点，实际上就是SCN号的别名.V$FLASHBACK_DATABASE_STAT;config restore point1、create restore point2、flashback database/***************************************************************************************************************************************/创建restore point，恢复数据库；/***************** 阅读全文
摘要：
Monitoring Flashback DatabaseTo monitor the ability to meet your retention target:View the Fast Recovery Area disk quota:SQL> select estimated_flashback_size,flashback_size FROM V$FLASHBACK_DATABASE_LOG;ESTIMATED_FLASHBACK_SIZE FLASHBACK_SIZE------------------------ -------------- 2369... 阅读全文
摘要：
Flashback Database:ExamplesTo flashback:Mounted(in exlusive mode)databseRMAN>FLASHBACK DATABASE TO TIME = "TO_DATE('2009-05-27 16:00:00','YYYY-MM-DD HH24:MI:SS')";RMAN>FLASHBACK DATABASE TO SCN=23536;RMAN>FLASHBACK DATABASE TO SEQUENCE=223 TRHRED=1;Monitor progress 阅读全文
摘要：
Configuring Flashback Database如何查看数据库是否处于归档模式？mount database之后，执行如下命令SQL> select log_mode from v$database;LOG_MODE------------ARCHIVELOGconn as sysdba后，执行如下命令:SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_... 阅读全文
摘要：
Flashback DatabaseThe Flashdback Database operation:Works like a rewind button for the database.Can be used in cases of logical data corruptions madeb by usersFlashsback Database:Reducing Restore TimeFlashback Database Architecture 阅读全文
摘要：
ObjectivesAfter completing this lesson,you should be able to:Describe FlashbacktechnologyConfigure Flashback DatabasePerform Flashback Database operationsMonitor Flashback DatabaseFlashback Technolog:BenefitsTe Flashback technology is a revolutionary advantage in recovery.Traditional recovery techni 阅读全文