1. 版本信息:
SQL> select * from v$version;
2闪回区路径及最大大小
SQL> set linesize 1000
SQL> show parameter db_recover
NAME TYPE VALUE
------------------------------------ ---------------------- -----------------------------
db_recovery_file_dest string D:/oracle/flash_recovery_area
db_recovery_file_dest_size big integer 2G
------------------------------------ ---------------------- -----------------------------
db_recovery_file_dest string D:/oracle/flash_recovery_area
db_recovery_file_dest_size big integer 2G
3 闪回区数据保持时间(分钟)
SQL> show parameter flash
NAME TYPE VALUE
------------------------------------ ---------------------- ------
db_flashback_retention_target integer 1440
SQL> select 1440/60 hours from dual;
------------------------------------ ---------------------- ------
db_flashback_retention_target integer 1440
SQL> select 1440/60 hours from dual;
HOURS
----------
24
----------
24
4 最早恢复到的事件点
SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
会话已更改。
SQL> select * from v$flashback_database_log;
OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TI RETENTION_TARGET FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE
-------------------- ------------------- ---------------- -------------- ------------------------
464604298 2008-03-11 16:51:50 1440 8192000 0
-------------------- ------------------- ---------------- -------------- ------------------------
464604298 2008-03-11 16:51:50 1440 8192000 0