闪回是在10g之后才有的,他与undo中的前影像数据不同,闪回日志是以数据块为单位的,而undo是以行为单位的
开启闪回
http://blog.csdn.net/zhuxiaoliao/article/details/41076109
查询闪回日志的基本信息
SQL> select NAME,LOG#,THREAD# ,SEQUENCE#, BYTES,FIRST_CHANGE# ,FIRST_TIME from v$flashback_database_logfile;
NAME LOG# THREAD# SEQUENCE# BYTES FIRST_CHANGE# FIRST_TIME
-------------------------------------------------- ---------- ---------- ---------- ---------- ---------------- -----------------
/u01/app/oracle/db_recover_flashback_file/orcl/fl 1 1 1 8192000 1103446979190 20141028 16:15:14
ashback/o1_mf_b4yn4kyx_.flb
在视图v$flashback_database_log中也可以查询到闪回日志的信息,但是不靠谱
闪回日志的参数
db_recovery_file_dest:闪回日志的存放路径
db_recovery_file_dest_size:闪回日志的大小
db_flashback_retention_target:闪回日志保留的时间
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/db_recover_flashback_file
db_recovery_file_dest_size big in
开启闪回
http://blog.csdn.net/zhuxiaoliao/article/details/41076109
查询闪回日志的基本信息
SQL> select NAME,LOG#,THREAD# ,SEQUENCE#, BYTES,FIRST_CHANGE# ,FIRST_TIME from v$flashback_database_logfile;
NAME LOG# THREAD# SEQUENCE# BYTES FIRST_CHANGE# FIRST_TIME
-------------------------------------------------- ---------- ---------- ---------- ---------- ---------------- -----------------
/u01/app/oracle/db_recover_flashback_file/orcl/fl 1 1 1 8192000 1103446979190 20141028 16:15:14
ashback/o1_mf_b4yn4kyx_.flb
在视图v$flashback_database_log中也可以查询到闪回日志的信息,但是不靠谱
闪回日志的参数
db_recovery_file_dest:闪回日志的存放路径
db_recovery_file_dest_size:闪回日志的大小
db_flashback_retention_target:闪回日志保留的时间
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/db_recover_flashback_file
db_recovery_file_dest_size big in