随笔分类 - 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
阅读全文
摘要: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
阅读全文
摘要:Oracle 10g 11g New Features OverviesASM InstanceFlashback IFlashback IIFlashback DatabaseManaging MemoryAuto SchedularMaintaincePerformanceManage DB PerformanceSQL PerformanceDiag DatabaseMoving DataManage SpaceManage Databse SpaceDUP DatabaseSupport
阅读全文

浙公网安备 33010602011771号