随笔分类 - Oracle 11G新特性
摘要：查看包的结构内容[oracle@arcerzhang ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Sun May 19 20:15:32 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn /as sysdbaConnected.SQL> desc dbms_flashback_archive;PROCEDURE DISASSOCIATE_FBA Argument Name Type ...
阅读全文
摘要：闪回数据版本查询->闪回数据归档查询，前者不可以跨越DDL操作，后者可以跨越.SQL> l 1 select versions_xid,to_char(versions_starttime,'yyyy-mm-dd hh24:mi:ss') versions_starttime,versions_endtime,empno,sal 2 from emp 3 versions between timestamp to_timestamp('2013-05-18 14:13:07','yyyy-mm-dd hh24:mi:ss') and
阅读全文
摘要：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
阅读全文
摘要：/*********************************************************************************/实验目的: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
阅读全文
摘要：/************************************************************************************/实验目的:在存在事务级联的条件下，使用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也查询不到
阅读全文
摘要：Flashback Version Query/******************************************/实验：跟踪数据不同版本之间的事物变化目的：利用flashback query data,使用dml进行数据恢复/******************************************/SQL> show userUSER is "U2"SQL> create table m(id int,name varchar2(10));Table created.SQL> insert into m values(0,&
阅读全文
摘要：Guaranteeing Unod RetentionSQL> select ts#,name,included_in_database_backup,bigfile,flashback_on,encrypt_in_backup from v$tablespace; TS# NAME INCLUDED_IN_DATABASE_BACKUP BIGFILE FLASHBACK_ON ENCRYPT_IN_BACKUP---------- --------------- ------------------------------ -------...
阅读全文
摘要：ObjectivesAfter completing this lesson,you should be able to :Describe Flashback technologyPerform Flashback QueryUse Flashback Version QueryEnable row movement on a tablePerform Flashback Table operationsUse Flashback Transaction QueryUse Flashback TransactionPreparing Your Database for FlashbackCr
阅读全文
摘要：使用恢复点，闪回数据:恢复点或者叫做还原点，实际上就是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...
阅读全文
浙公网安备 33010602011771号