Many, but many times people have problems with the archive logs. And call our team to save you…. The FRA is full.
So… we discovered that they did not take policies and controls about the databases when they have 100 o more databases to admin.
Here… the script to clean… but remember… this is not the solution.
The solution is planning and automatization. Happy delete!
All:
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;
Specific Time:
delete archivelog until time "to_date('SEP 21 2018 20:00:00','Mon DD YYYY HH24:MI:SS')";