Archiver Hung in Oracle database
Summary
1. check how much space is used by archiver
2. check the last good backup of the database
3. delete archive log files older than last good backup
4. crosscheck archive log
1. check how much space is used by archiver
Sql> select count(*),sum(blocks*block_size) from v$archived_log where backup_count=0 and deleted=’NO’;
Sql> select * from v$flash_recovery_area_usage;
2. check the last good backup of the database
set pages 999 lines 120
col STATUS format a9col hrs format 999.99col start_time format a15col end_time format a15col dev format a5col inbytes format a10col outbytes format a10selectINPUT_TYPE, STATUS,to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time,to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time,elapsed_seconds/3600 hrs,output_device_type dev,input_bytes_display inbytes,output_bytes_display outbytesfrom V$RMAN_BACKUP_JOB_DETAILSorder by session_key;
3. delete archive log files older than last good backup
rman target / nocatalog
allocate channel for maintenance device type disk;
crosscheck archivelog all;
delete noprompt archivelog until time ‘sysdate – 1’;
delete noprompt expired archivelog all;
delete noprompt obsolete device type disk;
4. crosscheck archive log
crosscheck archivelog all;
release channel;
exit;
release channel;
exit;
Thank you
Osama mustafa
Technology Geek 