oracle 数据库开启闪回,开启Oracle闪回功能（二）

[oracle@rhel5 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 30 22:56:46 2010

Copyright (c) 1982, , .  All rights reserved.

Connected to:Oracle   Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options

SQL>

查看能到的最早的scn，如果数据库没有开闪回功能是没有记录返回的。SQL> select oldest_flashback_scn from v$flashback_database_log;

no rows selected

查看数据库是否开闪回SQL> select flashback_on from v$database;

FLASHBACK_ON------------------NO

数据库open状态尝试开启数据库的闪回功能，返回报错信息说明需要在mount状态下来操作。SQL> alter database  on;alter database flashback on*ERROR at line 1:ORA-38759: Database must be mounted by only one instance and not open.

关闭数据库SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.

打开数据库到mount状态SQL> startup mountORACLE instance started.

Total System Global Area  184549376 bytesFixed Size                  1218412 bytesVariable Size              83888276 bytesDatabase Buffers           96468992 bytesRedo Buffers                2973696 bytesDatabase mounted.

数据库在mount状态下再次尝试开启数据库的闪回功能，又返回错误信息说明数据库在非归档状态下不支持数据库的闪回。SQL> alter database flashback on;alter database flashback on*ERROR at line 1:ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38707: Media recovery is not enabled.

开归档SQL> alter database archivelog;

Database altered.

开闪回成功SQL> alter database flashback on;

Database altered.

打开数据库SQL> alter database open;

Database altered.

开启归档，默认的归档目录：USE_DB_RECOVERY_FILE_DEST ，与9i不同10g开启归档很要简单一些。以后可以自行修改归档目录的位置，在此暂时保留默认。SQL>  log listDatabase log mode              Archive ModeAutomatic archival             EnabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     59Next log sequence to archive   61Current log sequence           61

检验数据库闪回是否开启SQL> select flashback_on from v$database;

FLASHBACK_ON------------------YES

查看闪回区信息，默认大小为2G，根据数据库的具体情况作修改。SQL> show parameter recover_file_dest

NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest                string      /u01/app/oracle/flash_recovery_areadb_recovery_file_dest_size           big integer 20G数据库可以恢复到多少分钟以前，默认1440分钟(一天)SQL> show parameter flash

NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------db_flashback_retention_target        integer     1440

查看数据库能恢复到最早的scn，和最早的时间SQL> select oldest_flashback_scn,oldest_flashback_time from v$flashback_database_log;

OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TIME-------------------- ---------------------             1021372     20101130 23:07:18