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

botang

（52-31）上完1Z0-053第11章

1. select  * from dba_flashback_archive;
   
2. 
   
3. select  * from dba_flashback_archive_tables;
   
4. 
   
5. select  * from dba_flashback_archive_ts;
   
6. 
   
7. alter system checkpoint;
   
8. 
   
9. grant flashback archive on fda1 to sh ;
   
10. 
    
11. ----
    
12. 
    
13. 
    
14. 
    
15. alter user sh identified by oracle_4U account unlock;
    
16. 
    
17. create tablespace fda2 datafile size 5M  autoextend on;
    
18. 
    
19. alter tablespace fda2 rename to tbsfda2;
    
20. 
    
21. alter flashback archive fda1 add tablespace tbsfda2 quota 4M  ;
    
22. 
    
23. ---
    
24. 
    
25. create flashback archive    fda2
    
26. tablespace tbsfda1 quota  5M retention    5 year;
    
27. 
    
28. ---
    
29. alter flashback archive fda2 set default;
    
30. 
    
31. ---
    
32. 
    
33. alter flashback archive fda1 modify retention 1 year;
    
34. 
    
35. ---
    
36. 
    
37. alter flashback archive fda1  purge before  timestamp  
    
38.     systimestamp -1/1440;
    
39. 
    
40. select  * from hr.SYS_FBA_HIST_73953;
    
41. 
    
42. ---
    
43. 
    
44. alter system flush buffer_cache;
    
45. 
    
46. 
    
47. drop flashback archive fda1;
    
48. 
    
49. ---
    
50. 
    
51. alter system checkpoint;
    
52. 
    
53. 
    
54. --
    
55. 
    
56. grant flashback archive on fda2 to hr;
    
57. 
    
58. ---
    
59. select  * from hr.SYS_FBA_HIST_73953;
    
60. 
    
61. alter system checkpoint;
    
62. 
    
63. select  * from  hr.SYS_FBA_HIST_80724;
    
64. 
    
65. update hr.SYS_FBA_HIST_80724  set  aa=2 where  endscn=2267466;
    
66. 
    
67. ---
    
68. 
    
69. select  * from  hr.SYS_FBA_HIST_80739;

复制代码