Backup & Recovery

Basic Queries for Backup & Recovery
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Check Flashback Recovery Area :

set lines 100
col name format a60
select name
, floor(space_limit / 1024 / 1024 / 1024) "Size GB"
, ceil(space_used  / 1024 / 1024 / 1024) "Used GB"
from v$recovery_file_dest
order by name;

Delete the non required Archive :

DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';

DELETE no prompt  ARCHIVELOG from logseq 482193 until logseq 483230 thread 1;

DELETE ARCHIVELOG ALL BACKED UP 1 TIMES TO DEVICE TYPE 'SBT_TAPE' COMPLETED BEFORE 'SYSDATE-2';

DELETE ARCHIVELOG ALL BACKED UP 1 TIMES TO DEVICE TYPE 'SBT_TAPE' ;

DELETE ARCHIVELOG from logseq XXXXX until logseq XXXXX  BACKED UP 1 TIMES TO DEVICE TYPE 'SBT_TAPE' ;