Enabling the 10g flash back feature of oracle

Oracle 10g flash back function 1. version number. Www.2cto.com SQL> select * from v $ version; BANNER implements Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdPL/SQL Release 10.2.0.1.0-ProductionCORE 10.2.0.1.0 Production TNS for Linux: version 10.2.0.1.0-ProductionNLSRTL Version 10.2.0.1.0-Production 2. check whether flashback SQL> select flashback_on, name from v $ database; FLASHBACK_ON NAME ------------------ --------- NO ORCL 3 is set. set the flash back function www.2cto.com to shutdown immediate startup mount alter database flashback on; alter database open; 4. check whether the setting is successful. SQL> select flashback_on, name from v $ database; FLASHBACK_ON NAME ---------------- --------- YES ORCL