Thursday, May 5, 2011

Delete Archived Logs - Oracle

If you have not enough space in your disk and make sure you have recent backup of your database and archive log is not needed then you can use.


Delete more than 2 days old log files:

RMAN TARGET /
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-2';
Delete all log files:

RMAN TARGET /
STARTUP MOUNT;
DELETE ARCHIVELOG ALL;
ALTER DATABASE OPEN;

No comments:

Post a Comment