ORA-00257归档日志写满的解决记录

1. 登陆oracle

SecureCRT登录服务器，切换用户oracle,连接oracle

[root@userbeta~]# su - oracle

[oracle@userbeta~]$ sqlplus /nolog

SQL> connect /as sysdba

2. 计算flash recovery area已经占用的空间

SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;

3. 查看db_recovery_file_dest_size大小

SQL> show parameter db_recovery_file_dest_size;

4. 扩容

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=20g;

5. 关闭归档日志

shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
archive log list;

参考链接：