Bo's Oracle Station

查看: 2197|回复: 0

(52-31)第53/54次:2016-01-29星期五,2016-02-01星期一闪回数据库

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2016-1-31 21:24:03 | 显示全部楼层 |阅读模式
本帖最后由 botang 于 2016-2-3 11:14 编辑

(52-31)上完1Z0-053第11章
  1. select  * from dba_flashback_archive;

  2. select  * from dba_flashback_archive_tables;

  3. select  * from dba_flashback_archive_ts;

  4. alter system checkpoint;

  5. grant flashback archive on fda1 to sh ;

  6. ----



  7. alter user sh identified by oracle_4U account unlock;

  8. create tablespace fda2 datafile size 5M  autoextend on;

  9. alter tablespace fda2 rename to tbsfda2;

  10. alter flashback archive fda1 add tablespace tbsfda2 quota 4M  ;

  11. ---

  12. create flashback archive    fda2
  13. tablespace tbsfda1 quota  5M retention    5 year;

  14. ---
  15. alter flashback archive fda2 set default;

  16. ---

  17. alter flashback archive fda1 modify retention 1 year;

  18. ---

  19. alter flashback archive fda1  purge before  timestamp  
  20.     systimestamp -1/1440;

  21. select  * from hr.SYS_FBA_HIST_73953;

  22. ---

  23. alter system flush buffer_cache;


  24. drop flashback archive fda1;

  25. ---

  26. alter system checkpoint;


  27. --

  28. grant flashback archive on fda2 to hr;

  29. ---
  30. select  * from hr.SYS_FBA_HIST_73953;

  31. alter system checkpoint;

  32. select  * from  hr.SYS_FBA_HIST_80724;

  33. update hr.SYS_FBA_HIST_80724  set  aa=2 where  endscn=2267466;

  34. ---

  35. select  * from  hr.SYS_FBA_HIST_80739;
复制代码



回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-28 21:14 , Processed in 0.033420 second(s), 24 queries .

快速回复 返回顶部 返回列表