Note: Technical Talk being moved to:
www.nazimcricket.com/wiki


Saturday, 6 February 2010

RMAN Archivelog Deletions

Note to self
rman nocatalog<< DATA
connect target
delete noprompt archivelog until time 'SYSDATE-n';
DATA
rman nocatalog<< DATA
connect target
delete noprompt archivelog until sequence= nnnnnnn;
DATA

A scenario where so many archivelogs are being generated, that you have to resort to using RMAN to clear out archivelogs on the fly, can also be supported by increasing the physical space for archivelog files alongwith boosting the db_recovery_file_dest_size parameter i.e. increasing the flash recovery area.

ORA-19815: WARNING: db_recovery_file_dest_size of n bytes is n% used, and has n remaining bytes available.

alter system set db_recovery_file_dest_size=nM/G scope=both;

No comments: