![](https://csdnimg.cn/release/download_crawler_static/76282272/bg12.jpg)
Tianlesoftware 学习 Oracle Blog: http://blog.csdn.net/tianlesoftware
DBA1 群:62697716(满); DBA2 群:62697977(满); DBA3 群:62697850(满); DBA 超级群:63306533
DBA4 群:83829929(满); DBA5 群:142216823 DBA6 群:158654907
2.4.2 Flashback Database ........................................................................................................... 487
2.4.2.1 Flashback Database 说明 .......................................................................................................... 487
2.4.2.2 Flashback Database 架构 .......................................................................................................... 487
2.4.2.3 启用 Flashback Database 步骤 ................................................................................................ 488
2.4.2.3.1. 配置 Flash Recovery Area ................................................................................................ 488
2.4.2.3.2. 启动 flashback database .................................................................................................. 488
2.4.2.4 Flashback Database 操作示例 ................................................................................................... 489
2.4.2.4.1. 检查是否启动了 flash recovery area .............................................................................. 489
2.4.2.4.2. 检查是否启用了归档...................................................................................................... 489
2.4.2.4.3. 检查是否启用了 flashback database .............................................................................. 489
2.4.2.4.4. 查询当前的 scn ............................................................................................................... 489
2.4.2.4.5. 查询当前的时间 ............................................................................................................. 489
2.4.2.4.6. 删除表 A .......................................................................................................................... 490
2.4.2.4.7. 重启 DB 到 mount .......................................................................................................... 490
2.4.2.4.8. 执行恢复:分 timestamp 或者 SCN 两种 ..................................................................... 490
2.4.2.4.9. 打开数据库 ..................................................................................................................... 491
2.4.2.5 和 Flashback Database 相关的 3 个视图 ................................................................................ 491
2.4.2.5.1. V$database ....................................................................................................................... 491
2.4.2.5.2. V$flashback_database_log ................................................................................................ 491
2.4.2.5.3. V$flashback_database_stat .............................................................................................. 492
2.4.3 Flashback Drop ................................................................................................................... 492
2.4.3.1. Tablespace Recycle Bin .............................................................................................................. 492
2.4.3.2. Flashback Drop 实例操作 ........................................................................................................ 495
2.4.4 Flashback Query ................................................................................................................. 497
2.4.4.1 Flashback Query ...................................................................................................................... 497
2.4.4.1.1 多版本读一致性 ............................................................................................................ 498
2.4.4.1.2 As of timestamp 的示例: ...................................................................................... 498
2.4.4.1.3. As of scn 示例 .................................................................................................................. 499
2.4.4.1.4 SCN 与 timestamp 关系 ............................................................................................... 500
2.4.4.1.5 Flashback Query 函数,存储过程,包,触发器等对象............................................. 501
2.4.4.2 Flashback version Query ......................................................................................................... 504
2.4.4.3 Flashback Transaction Query ................................................................................................... 507
2.4.5 Flashback Table .................................................................................................................. 508
2.4.6 Oracle Flashback Data Archive ........................................................................................... 510
2.4.6.1 Flashback Data Archive 说明 .................................................................................................. 511
2.4.6.2 Flashback Data Archive 的相关操作 ...................................................................................... 513
2.4.6.2.1 Creating a Flashback Data Archive ..................................................................................... 513
2.4.6.2.2 Altering a Flashback Data Archive ................................................................................... 516
2.4.6.2.3 Dropping a Flashback Data Archive ................................................................................. 518
2.4.6.2.4 Specifying the Default Flashback Data Archive ............................................................... 519
2.4.6.2.5 Enabling and Disabling Flashback Data Archive .............................................................. 519
2.4.6.2.6 DDL Statements on Tables Enabled for Flashback Data Archive ......................................... 521
2.4.6.3 一个用 Flashback Data Archive 恢复数据的测试 ................................................................. 523
2.5 各种故障恢复 ......................................................................................................................... 526