oracle 10G闪回功能的打开

1.版本号。

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE10.2.0.1.0Production

TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

2.查看是否设置了闪回

SQL> select flashback_on ,name from v$database;

FLASHBACK_ON NAME
------------------ ---------
NO ORCL

3.设置闪回功能

要在mount 状态

shutdown immediate

startup mount

alter database flashback on;

alter database open;

4.查看是否设置成功

SQL> select flashback_on,name from v$database;

FLASHBACK_ON NAME
------------------ ---------
YES ORCL