FLASH RECOVERY AREA options

DB_RECOVERY_FILE_DEST_SIZE;
DB_RECOVERY_FILE_DEST;

SELECT * FROM V$RECOVERY_FILE_DEST;
SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE= ;
RMAN> backup device type ‘sbt_tape’ recovery area;
RMAN> configure retention policy to recovery window of 5 days;
RMAN> cONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO SBT;
RMAN> DELETE EXPIRED ARCHIVELOG ALL;
RMAN> DELETE OBSOLETE ARCHIVELOG ALL;

SELECT object_type, message_type, message_level, reason, suggested_action FROM dba_outstanding_alerts;

backup recovery area;

RMAN> delete expired archivelog all;

=================
SELECT * FROM V$RECOVERY_FILE_DEST;
NAME——————————————————————
SPACE_LIMIT
SPACE_USED  SPACE_RECLAIMABLE NUMBER_OF_FILES
———– ———- —————– —————
/opt/oracle/product/1010/dbs/ora_flash_area
1073741824  633155072         0               8

RMAN> DELETE BACKUPSET 45;
using channel ORA_DISK_1
using channel ORA_SBT_TAPE_1
List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
——- ———- — ———– ———– ———-
52      45      1   1   AVAILABLE   DISK        opt/oracle/product/1010/dbs/ora_flash_area/DB10G/backupset/2005_06_15/o1_mf_ncsnf_TAG20050615T215053_1c0odcbg_.bkp
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/opt/oracle/product/1010/dbs/ora_flash_area/DB10G/backupset/2005_06_15/o1_mf_ncsnf_TAG20050615T215053_1c0odcbg_.bkp
recid=52 stamp=561073891
Deleted 1 objects
SQL>
==================

Disk Quota =
Size of a copy of database +
Size of an incremental backup +
Size of (n+1) days of archived redo logs +
Size of (y+1) days of foreign archived redo logs (for logical standby) +
Size of control file +
Size of an online redo log member * number of log groups +
Size of flashback logs (based on DB_FLASHBACK_RETENTION_TARGET value)