Wednesday, 12 September 2018

Archive log delete from destination location

Archive log delete from destination location:

ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

 select name, round(space_limit/1048576),round(space_used/1048576), round((round(space_used/1048576)*100)/(round(space_limit/1048576))) pct_used from  v$RECOVERY_FILE_DEST;

SELECT * FROM   V$RECOVERY_AREA_USAGE;
 rman target /
select * from v$recovery_area_usage;
 DELETE FORCE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-20';

No comments:

Post a Comment