Category: RMAN

Oracle Database: Remove old archive files from RMAN

rman target / CROSSCHECK BACKUP; CROSSCHECK COPY; CROSSCHECK ARCHIVELOG; DELETE EXPIRED BACKUP; DELETE EXPIRED COPY; DELETE EXPIRED ARCHIVELOG; RMAN> report obsolete; RMAN> delete obsolete; recent commands: delete archivelog all completed before 'sysdate -1'; backup archivelog all; crosscheck backupset; crosscheck archivelog all;...

Oracle Database: flash_recovery_area full?

SELECT NAME, TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT, TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE, '999,999,999,999') AS SPACE_AVAILABLE, ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1) AS PERCENT_FULL FROM V$RECOVERY_FILE_DEST; Resize flash_recovery_area: SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 180G; [ad#ad-post]...
(adsbygoogle = window.adsbygoogle || []).push({});