The Archiver hung alerts

The Archiver hung alerts:

1. Check space in DB_RECOVERY_FILE_DEST_SIZE

2. If there is no space left, increase the size.

ALTER SYSTEM set DB_RECOVERY_FILE_DEST_SIZE = 15G;


3. Coonect catalog database

connect target /

rman/rm2n10g@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx.xxxxx.co.uk)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=xxxxx.lloydstsb.co.uk)))

4. Take the backup of archive logs

RMAN>

run {
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/u01/app/oracle/admin/tsm_rman/xxxxxx_tdpo.opt)';
backup archivelog all delete input;
}