A quick emergency FRA clean up when archived logs are full.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
An Oracle Spin by Alex Lima 