DB Wiki

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u03/oracle/backup/%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u03/oracle/backup/%U';

BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

DELETE ARCHIVELOG ALL;
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'sysdate -7';

-- Active RMAN Job
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
       ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM  V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
  AND OPNAME NOT LIKE '%aggregate%'
  AND TOTALWORK != 0
  AND SOFAR <> TOTALWORK
 

-- Last RMAN Operation
col object_type format a15
ALTER SESSION SET nls_date_format='DD-MON-YYYY hh24:mi:ss';
 
SELECT object_type,mbytes_processed, start_time, end_time,STATUS
FROM v$rman_status
WHERE session_recid = (SELECT MAX(session_recid) 
                         FROM v$rman_status)
AND operation !='RMAN'
ORDER BY recid;

SET linesize 120
col name format a20
SELECT name, space_limit/1024/1024 SPACE_LIMIT_MB, 
             space_used/1024/1024 SPACE_USED_MB,
             space_reclaimable/1024/1024 SPACE_RECLAIMABLE_MB,
             NUMBER_OF_FILES FROM V$RECOVERY_FILE_DEST;
 
SELECT * FROM V$RECOVERY_AREA_USAGE;