摘要：
Oracle Total Recall ScenarioUsing Flashback Data Archive to access historical data:--create the flashback data archivecreate flashback archive default fla1 tablespace tbs1 quota 10g retention 5 year;--specifiy the default flashback data archive alter flashback archive fla1 set default;--enable flash 阅读全文
摘要：
本章节为实验课，具体实验内容参看上节视频[bbk5102] 第38集 - 第四章 Flashback Database 02 阅读全文
摘要：
1、trace文件SQL> show parameter user_dump_destNAME TYPE VALUE------------------------------------ ----------- ----------------------------------------------------------------------------------------user_dump_dest string /RealData/diag/rd... 阅读全文
摘要：
/*********************************************************************************/实验目的:1、create tablespace--->fdba_tbs2、create user ---administer--fbda_amdin3、grant4、grant ---ARCER5、create flashback archive6、transaction--flashback version query7、drop undo8、enable--emp--flashback archive/******** 阅读全文
摘要：
数据归档区管理员(FLASHBACK ARCHIVE ADMINISTER)在日常管理中，可以安排一个专门人员负责数据归档区的管理.DBA分配FLASHBACK ARCHIVE ADMINISTER权限给此用户.空间 TABLESPACE权限 |-SELECT ANY TRANSACTION |-FALASHBACK ARCHI |-DBMS_FLASHBACK(PACKAGE EXECUTE PRIVES)How Total Recall WorksHistory data:Row captured asynchronously by background processes at ... 阅读全文
摘要：
ObjectivesAfter completing this lesson,you should be be able to :Describe and use Oracle Total RecallCreating and enabling a Flashback Data Archive(FDA)Manageing FDAsViewing metadataDescribe and use flashback recycle binsRestore dropped tables from the recycle binManage space usage in the recycle bi 阅读全文