PROMPT How Far Back Can We Flashback To (Time)?
PROMPT
select to_char(oldest_flashback_time,'dd-mon-yyyy hh24:mi:ss') "Oldest Flashback Time"
from v$flashback_database_log;
PROMPT
PROMPT How Far Back Can We Flashback To (SCN)?
PROMPT
col oldest_flashback_scn format 99999999999999999999999999
select oldest_flashback_scn from v$flashback_database_log;
PROMPT
PROMPT Flashback Area Usage
SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
PROMPT
col ROUND(SPACE_LIMIT/1048576) heading "Space Allocated (MB)" format 999999
col round(space_used/1048576) heading "Space Used (MB)" format 99999
col name Heading "Flashback Location" format a40
select name, round(space_limit/1048576),round(space_used/1048576)
from v$RECOVERY_FILE_DEST;
How Far Back Can We Flashback To (Time)?
Oldest Flashback Time
-----------------------------
05-jul-2009 22:53:07
How Far Back Can We Flashback To (SCN)?
OLDEST_FLASHBACK_SCN
---------------------------
15321928761
Flashback Area Usage
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 16.33 16.33 51
BACKUPPIECE 16.34 16.34 6
IMAGECOPY 0 0 0
FLASHBACKLOG 45.94 10.61 204
6 rows selected.
Flashback Location Space Allocated (MB) Space Used (MB)
---------------------------------------- -------------------- ---------------
/u05/oradata/flash_recovery_area 5120 4025
The following two tabs change content below.
Gavin Soorma
