Oracle sys 用户登录报错 : ORA-09925 Unable to create audit trail file Linux-x86_64 Error: 28: No space
cd /var/log/mongodb
echo ''>mongod.log
rman target /
RMAN> list archivelog all;
RMAN> delete force noprompt archivelog all;
# 查询归档文件位置、大小信息
SQL> select * from v$recovery_file_dest;
# 查询归档日志文件使用情况
SQL> select * from v$flash_recovery_area_usage;
通过sys用户登录后使用如下语句进行容量设置:
SQL> alter system set db_recovery_file_dest_size=20G;
rmanclear.sh
#!/bin/bash
if [ -f ~/.bash_profile ]; then
. ~/.bash_profile
fi
ORACLE_SID=$1;
export ORACLE_SID=$ORACLE_SID
$ORACLE_HOME/bin/rman log=/data/rman.log <<EOF
connect target /
run{
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt archivelog all completed before 'sysdate - 1';
}
exit;
EOF
rmanclearcron.sh
su - oracle -c "/data/rmanclear.sh orcl"
crontab -e
0 6 * * * /data/rmanclearcron.sh