启动数据库flashback特性

     在oracle 12C 的环境下开启和关闭数据库闪回（flashbackup）功能。以下是简单的操作过程，但是在生产环境下不建议开启该功能。

点击(此处)折叠或打开

1. [oracle@localhost ~]$ sqlplus / as sysdba
4. SQL*Plus: Release 12.1.0.1.0 Production on Mon Dec 14 15:15:35 2015
7. Copyright (c) 1982, 2013, Oracle. All rights reserved.
12. Connected to:
13. Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
14. With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
17. SQL> set linesize 200
18. SQL> set pagesize 999
19. SQL> SELECT flashback_on, log_mode FROM v$database;
22. FLASHBACK_ON LOG_MODE
23. ------------------ ------------
24. NO ARCHIVELOG
27. SQL>
28. SQL>
29. SQL>
30. SQL> shutdown immediate;
31. Database closed.
32. Database dismounted.
33. ORACLE instance shut down.
34. SQL> startup mount;
35. ORACLE instance started.
38. Total System Global Area 835104768 bytes
39. Fixed Size 2293880 bytes
40. Variable Size 562040712 bytes
41. Database Buffers 264241152 bytes
42. Redo Buffers 6529024 bytes
43. Database mounted.
44. SQL> alter database flashback on;
45. Database altered.
46. SQL> alter database open;
47. Database altered.
48. SQL>
49. SQL>
50. SQL> SELECT flashback_on, log_mode FROM v$database;
51. FLASHBACK_ON LOG_MODE
52. ------------------ ------------
53. YES ARCHIVELOG
55. SQL> show parameter recovery
56. NAME TYPE VALUE
57. ------------------------------------ ----------- ------------------------------
58. db_recovery_file_dest string /u01/app/oracle/fast_recovery_
59. area
60. db_recovery_file_dest_size big integer 4800M
61. recovery_parallelism integer 0
62. SQL> show parameter flashback
64. NAME TYPE VALUE
65. ------------------------------------ ----------- ------------------------------
66. db_flashback_retention_target integer 1440
67. 
    
68. SQL> alter system set db_flashback_retention_target=2880;
69. System altered.
70. 
    
71. SQL> show parameter flashback
72. NAME TYPE VALUE
73. ------------------------------------ ----------- ------------------------------
74. db_flashback_retention_target integer 2880
75. SQL> shutdown immedaite
76. SP2-0717: illegal SHUTDOWN option
77. SQL> shutdown immediate;
78. Database closed.
79. Database dismounted.
80. ORACLE instance shut down.
81. SQL> startup mount;
82. ORACLE instance started.
85. Total System Global Area 835104768 bytes
86. Fixed Size 2293880 bytes
87. Variable Size 562040712 bytes
88. Database Buffers 264241152 bytes
89. Redo Buffers 6529024 bytes
90. Database mounted.
91. SQL> alter database flashback off;
93. Database altered.
95. SQL> alter database open;
97. Database altered.
99. SQL> SELECT flashback_on, log_mode FROM v$database;
101. FLASHBACK_ON LOG_MODE
102. ------------------ ------------
103. NO ARCHIVELOG
105. SQL> show parameter recovery
108. NAME TYPE VALUE
109. ------------------------------------ ----------- ------------------------------
110. db_recovery_file_dest string /u01/app/oracle/fast_recovery_
111. area
112. db_recovery_file_dest_size big integer 4800M
113. recovery_parallelism integer 0
114. SQL> show parameter flashback
117. NAME TYPE VALUE
118. ------------------------------------ ----------- ------------------------------
119. db_flashback_retention_target integer 2880
120. SQL>

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

转载于:http://blog.itpub.net/27039319/viewspace-1871988/