Friday, 4 November 2011

Czyszczenie REDO logów

run {
crosscheck archivelog all;
delete expired archivelog all;
}

run {
BACKUP ARCHIVELOG ALL;
DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
}

run {
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE
'sysdate-10/24'; ---kasuje wszystkie z przed 13h
}

No comments:

Post a Comment