oracle之关于闪回

tail -f alert*.log查看数据库信息

1.show parameter db_recovery_file_dest 查看上回去的位置状态以及分配大小
db_recovery_file_size=3g
 alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' scope=both;设置闪回区的路径。
在mount状态下
2.alter database flashback on;打开闪回
3.select flashback_on from v$database;查看闪回是否打开，若果是no在前面的闪回区进行设置：
FLASHBACK_ON
------------------
YES
4.检查是否启动了flash recovery area
SYS@db1> show parameter db_recovery_file
NAME_COL_PLUS_SHOW_PARAM                                                        TYPE
-------------------------------------------------------------------------------- -----------
VALUE_COL_PLUS_SHOW_PARAM
----------------------------------------------------------------------------------------------------
db_recovery_file_dest                                                           string
/u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size                                                      big integer
3G
5.查看是否归档   archive log list
6.查看当前的scn
 select current_scn from v$database;
7.查看当前时间
 select to_char(sysdate,'yy-mm-dd hh24:mi:ss')tmie from dual;