Oracle アーカイブ ログをクエリする方法

select * from v$recovery_file_dest

SQL> select * from v$recovery_file_dest;
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/u03/fast_recovery_area
 8589934592 6551817216 
 
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
CONTROL FILE                          0                         0
              0
REDO LOG                           1.83                         0
              3
ARCHIVED LOG                      74.44                         0
            159

SQL> alter system set db_recovery_file_dest_size=20G;
System altered.

 select * from v$flash_recovery_area_usage;

rman target sys/pass

crosscheck archivelog all;

delete expired archivelog all;(全部删除)
 
delete archivelog until time 'sysdate - 1';（保留当天删除，删除之前所有）