ORA-00257: archiver error – FRA Clean Up emergency

A quick emergency FRA clean up when archived logs are full.

 


JDEPROD@xxxx-/cloudfs/DBA/scripts$ cat delete_arch_logs.sh
export ORACLE_SID=JDEPROD
export ORAENV_ASK=NO
. oraenv
$ORACLE_HOME/bin/rman target / << EOF
run
{
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
}
exit
EOF

view raw

gistfile1.txt

hosted with ❤ by GitHub