How to turn on Oracle Flash back

First check whether to turn on the flashback:sql> select flashback_on from V$database; flashback_on------------------No two if you have already turned on the flashback, you do not need to perform the following operation. Cd/u01mkdir Flashback (generate flash headings record) sql> alter system set db_recovery_file_dest_size=30g Scope=both; Sql> alter system set db_recovery_file_dest= '/u01/flashback ' Scope=both; sql> shutdown immediatesql> startup mountsql> alter DATABASE Archivelog; Sql> ALTER DATABASE flashback on; sql> ALTER DATABASE open; Third confirm:sql> select flashback_on from V$database; flashback_on------------------YES

This article is from the "My main beam margin" blog, please be sure to keep this source http://xiaocao13140.blog.51cto.com/6198256/1932939

How to turn on Oracle Flash back