Many, but many times the people have problems with the archivelogs. And call our team to save you…. The FRA its full.
So… we discovered that they not take policys and controls about the databases , when they have 100 o more database to admin.
Here… the scritp to clean… but remember… this is not the solution.
The solution its planning and automatization. Happy delete !
delete archivelog all;
The Last Day:
delete archivelog until time 'SYSDATE-1';
Specific Sequence or Between Sequence:
delete archivelog until sequence 456; delete archivelog from sequence 456 until sequence 1000;
delete archivelog until time "to_date('SEP 21 2018 20:00:00','Mon DD YYYY HH24:MI:SS')";