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

 

 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.