DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE '(SYSDATE-时间)';
DELETE noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-时间';
保留1天 sysdate -1
保留12小时 sysdate - 1/2
保留1小时 sysdate - 1/24
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE '(SYSDATE-时间)';
DELETE noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-时间';
保留1天 sysdate -1
保留12小时 sysdate - 1/2
保留1小时 sysdate - 1/24