Category: 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;...

In the rare event that you lose all copies of the control file.     Start the database instance with the nomount option and issue the following RMAN command (start RMAN after starting the db instance). If using a recovery catalog:...

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]...

I found this site, and I think these cheatsheets are pretty nice: http://cheatsheet4oracledba.blogspot.com/2011/09/rman-commands-cheatsheet.html [ad#ad-post]...

I found this handy when I was working with two databases at work: http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/backrest003.htm [ad#ad-post]...