Oracle Flashback
Oracle Flashback 技术总结3(转载David Dai )2.4.3.1. Tablespace Recycle Bin
从Oracle 10g 开始, 每个表空间都会有一个叫作回收站的逻辑区域,当用户执行drop命令时, 被删除的表和表的关联对象( 包括索引, 约束,触发器,LOB段,LOB index 段) 不会被物理删除, 这些对象先转移到回收站中,这就给用户提供了一个恢复的可能。
When you drop a table, the database does not immediately remove the space associated with the table. The database renames the table and places it and any associated objects in a recycle bin, where, in case the table was dropped in error, it can be recovered at a later time. This feature is called Flashback Drop, and the FLASHBACK TABLE statement is used to restore the table. Before discussing the use of the FLASHBACK TABLE statement for this purpose, it is important to understand how the recycle bin works, and how you manage its contents.
The recycle bin is actually a data dictionary table containing information about dropped objects. Dropped tables and any associated objects such as indexes, constraints, nested tables, and the likes are not removed and still occupy space. They continue to count against user space quotas, until specifically purged from the recycle bin or the unlikely situation where they must be purged by the database because of tablespace space constraints.
From:
doc.guandang.net
初始化参数recyclebin 用于控制是否启用recyclebin功能,缺省是ON, 可以使用OFF关闭。
SQL> show parameter recycle
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_recycle string
db_recycle_cache_size big integer 0
recyclebin string on
禁用该功能:
SQL> alter system set recyclebin=off;
SQL> alter system set recyclebin=on;
SQL> alter session set recyclebin=off;
SQL> alter session set recyclebin=on;
禁用后删除的对象将直接删除,不会写到Recycle中,当然在删除时,指定purge 参数,表也将直接删除,不会写到recyclebin中。
SQL> drop table name purge;
查看recyclebin中的对象列表:
SQL> select * from A;
ID
----------
1
2
3
SQL> drop table A;
表已删除。
SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ----------------------------- ------------
A BIN$RWXQQcTPRde0ws4h9ewJcg==$0 TABLE 2009-10-15:12:44:33
查看recyclebin中对象:
SQL> select original_name,object_name from recyclebin;
ORIGINAL_NAME OBJECT_NAME
-------------------------------- ------------------------------
A BIN$RWXQQcTPRde0ws4h9ewJcg==$0
Oracle Flashback 技术 总结Oracle Flashback 技术 总结隐藏>> Oracle Flashback 技术 总结 Flashback 技术是以 Undo segment 中的内容为基础的, 因此受限于 UNDO_...
Oracle Flashback 4页 1下载券 Oracle数据库命令速查手... 10页 1下载券 ...Flashback Flashback query(undo) select * from table_name as of timestamp ...
Oracle10g Flashback 实践 一、概述 Flashback 是 ORACLE 自 9i 就开始提供的一项特性,在 9i 中利用 oracle 查询多版本一致的 特点,实现从回滚段中读取表一定...
Oracle Flashback 技术 总结_计算机软件及应用_IT/计算机_专业资料。Oracle Flashback 技术 总结分类: Oracle Basic Knowledge 2009-10-15 21:41 20104 人阅读 ...
Understand how to use Flashback Technology. ? ? Overview ? ? ? ? Flashback Flashback Flashback Flashback Query Table Drop Database Flashback Query ? ...
在 Oracle 11g 里又出了一个新特性:Oracle Flashback Data Archive. FDA 通过将变化数据另外存储到创建的闪回归档区(Flashback Archive)中,以和 undo 区别开来,...
Oracle 利用 flashback 恢复数据 海量 Oracle 资料下载,请收藏 http://www.database8.com 1 / 21 在 Oracle9i 之后,数据库闪回技术逐渐成熟。到 10g 时,数据...
一:oracle falshback table oracle flashback table即回闪表可以进行的操作:操作1>flashback table tablename to befor drop;对于误drop的table此可以使用本操作,...
SQL>flashback database to time to_timestamp(xxx); SQL>flashback database to scn xxx 2、Flashback Table Oracle Flashback Table特性允许利用Flashback Table...
oracle中使用FLASHBACK_TABLE_恢复被删除表_计算机软件及应用_IT/计算机_专业...与闪回查询类似,您还可以使 用它将表恢复到不同的时间点,形如 flashback ...
热门文档