随笔分类 -  Oracle 11G新特性

摘要: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 阅读全文
posted @ 2013-05-15 18:00 ArcerZhang 阅读(264) 评论(0) 推荐(0)
摘要: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_... 阅读全文
posted @ 2013-05-15 15:50 ArcerZhang 阅读(2796) 评论(1) 推荐(0)
摘要: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 阅读全文
posted @ 2013-05-15 12:49 ArcerZhang 阅读(116) 评论(1) 推荐(0)
摘要: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 阅读全文
posted @ 2013-05-15 12:12 ArcerZhang 阅读(141) 评论(3) 推荐(0)
摘要:Oracle 10g 11g New Features OverviesASM InstanceFlashback IFlashback IIFlashback DatabaseManaging MemoryAuto SchedularMaintaincePerformanceManage DB PerformanceSQL PerformanceDiag DatabaseMoving DataManage SpaceManage Databse SpaceDUP DatabaseSupport 阅读全文
posted @ 2013-05-13 11:05 ArcerZhang 阅读(148) 评论(2) 推荐(0)