ITPub博客

首页 > 数据库 > 数据库开发技术 > Flashback Database logs里的内容是什么?

Flashback Database logs里的内容是什么?

原创 数据库开发技术 作者:warehouse 时间:2010-08-07 11:52:37 0 删除 编辑
按照oracle的说法是before images of data blocks[@more@]

Flashback Database is implemented using a type of log file called Flashback Database logs. The
Oracle database periodically logs before images of data blocks in the Flashback Database logs.
Block images can be reused to quickly back out the data file changes to any time at which
flashback logs were captured just before the desired target time. Then, changes from the redo log
files are applied to fill in the gap. The Flashback Database logs are automatically created and
managed in the flash recovery area.

oracle说flashback log的内容记录的是before images of data blocks,所以直观的感觉到flashback logfile的大小应该是block大小的证书倍,验证了一下确实是8k的整数倍

SQL> show parameter db_block_size

NAME TYPE VALUE
------------------------------------ ----------- --------------------
db_block_size integer 8192
SQL>

SQL> select bytes/8192 from v$flashback_database_logfile;

BYTES/8192
----------
1000
681

SQL>

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/19602/viewspace-1036378/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: block corruption type
请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    717
  • 访问量
    5366321