摘要：
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 阅读全文
摘要：
/************************************************************************************/实验目的:在存在事务级联的条件下，使用DBMS_FLASHBACK.TRANSACTION_BACKOUT回退事务实验步骤:/************************************************************************************/ 阅读全文
摘要：
/************************************************************************************/实验目的:使用DBMS_FLASHBACK.TRANSACTION_BACKOUT回退事务实验步骤: 1、emp-insert into-empno=1 2、emp-insert into-empno=2 3、flashback transaction query--定位 4、flashback transaction--recover/****************************************... 阅读全文
摘要：
SQL> select table_name,operation,undo_sql from flashback_transaction_query where xid='06001D00D9080000';TABLE_NAME OPERATION UNDO_SQL---------- ------------ ----------------------------------------EMP1 UNKNOWNDEPT1 UNKNOWNEMP1 UNKNOWN BEGINOracle 11g排查上述操作不正常原因0、前提条件，是当... 阅读全文
摘要：
QuizSelect all correct statements:The database can remain open when a table is flashed back.Flashback Table is executed as a single transaction.Flashback Table is requies backups to be available.(flashback table 操作，是不依赖于backup的)Flashback Table is based on undo data.Flashback Transaction Query/****** 阅读全文
摘要：
/*************************************************************************/实验目的:Flashback table : Cannot span DDL operations实验步骤：见下图实验结论:Cannot span DDL operations/*************************************************************************/1、建表->查询数据->记录时间戳SQL> create table emp1 as select * f 阅读全文
摘要：
/*********************************************************************/实验目的：验证在sys用户下创建的表，无法实现flashback table功能实验步骤： 1、sys->create table emp -> 7369 900 2、error->update --7369 900-1900 3、定位错误--flashback version query 4、recover->flashback table/******************************************** 阅读全文
摘要：
实现Flashback table操作的前提条件权限及及开启movement row功能/*************************************************************************/实验:flashback table操作1、emp1-7369-9002、emp1-7369-900-1000 error where deptno=20---7369-19003、flashback version query4、flashback table---recover总结: 1、比incomplete recovery 影响返回小，保证数据库o. 阅读全文
摘要：
Quiz1、Flashback Query compares current data with data from the past.To do so,it uses both undo and redo data.TrueFalse2、Select the correct statementFlashback Version Query uses undo data and modifies data.Flashback Version Query uses undo data and does not modify data.Flashback Version Query uses bo 阅读全文
摘要：
Flashback Version Query:ConsiderationsThe VERSIONS clause cannot be used to query:External tablesTemporary tablesFixed tablesViewsThe VERSIONS clause cannot span DDL commands.Segment shrink operations are filtered out.在哪种情况下可以使用flashback versions query只能是commited以后的数据只能是dml语句，ddl不行；ddl以后，前面的dml也查询不到 阅读全文