Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

13

积分

0

好友

1

主题
1#
发表于 2012-4-1 10:49:07 | 查看: 4927| 回复: 2
通常情况下:
1.drop table t1 purge;
2.mount
3.flashback database ;可以找回t1

(可能由于受到flashback table to beore drop 的影响,进了思维的死胡同了)

问题1:
如果第一步和第二步期间,t1表空间的其他表有大量insert,t1删除前的所占的块,被其他表填充了能闪回吗?如果能,是什么原理?

问题2:
第一步和第二步之间,我把原t1的表空间和数据文件删除了
2#
发表于 2012-4-1 19:40:31
Oracle Database 10g features Flashback Database, a unique database point-in-time recovery capability, which allows the database to be ‘rewound’ to a prior point-in-time within seconds or minutes. Because only the affected data blocks are restored and recovered, it’s faster than traditional recovery methods. The command is simply ‘flashback database to my point-in-time’

We accomplish this fast recovery by utilizing flashback logs which record old block versions. When writes are issued to disk and flashback database is enabled, the old block version is written to the flashback log while the new block version is written to datafiles. When a flashback database command is issued, only the changed blocks are retrieved from the flashback logs and then recovered with appropriate archived logs to the required point-in-time. You control how far back to retain flashback logging to support your recovery requirements. For example you might enable flashback database for 24 hrs, and then rely on backups for recovery past 24 hrs.

回复 只看该作者 道具 举报

3#
发表于 2012-4-1 20:01:40
"如果第一步和第二步期间,t1表空间的其他表有大量insert,t1删除前的所占的块,被其他表填充了能闪回吗?如果能,是什么原理?"

可以 , 因为flashback logs闪回日志记录了 旧版本的 数据块。

"第一步和第二步之间,我把原t1的表空间和数据文件删除了"

闪回数据库 无法恢复 物理讹误 或者 介质丢失 , 因为闪回数据库仅仅可以从闪回日志中获得哪些发生过修改的块的 旧景象(而非数据文件或表空间上的所有数据块都可以得到恢复),它无法绕过 常规的介质恢复 来解决问题。

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-24 04:03 , Processed in 0.044757 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569