ORA-00257 archiver error. Connect internal only, until freed

1. Change to oracle user:$su oracle
2. Log in as sys user: $sqlplus sys/password as sysdba
3. Find out flash recovery area usage info, from where we can find the archive log space usage percent: SQL>select * from V$FLASH_RECOVERY_AREA_USAGE;
4. Caculate the space used by flash recovery area:SQL>select sum(percent_space_used)*3/100 from V$FLASH_RECOVERY_AREA_USAGE;
5. Show Archive log location: SQL>show parameter log_archive_dest;
6. Show recovery area location: SQL>show parameter recover;
7. Delete or move some old archive log files: SQL>rm -rf archive_log_2011_06_0*;
Notice: After step 7, we must use RMAN to maintain the control files, otherwise, the deletion changes can not be apply.
8. Log in as RMAN: SQL>rman target sys/password;
9. Find out unused archive log: SQL>crosscheck archive log all;
10. Delete expired archive log files: SQL>delete expired archivelog all;
11. Check the flash recovery area usage info again, make sure archive log files have been deleted: SQL>select * from V$FLASH_RECOVERY_AREA_USAGE;
12. Finally, increase the recovery file destination size: SQL>alter system set db_recovery_file_dest_size=3G scope=both;

posted on 2011-06-02 22:48 *** 阅读(255) 评论(0)  编辑  收藏


只有注册用户登录后才能发表评论。


网站导航:
 
<2011年6月>
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789

导航

统计

常用链接

留言簿

随笔档案

搜索

最新评论

阅读排行榜

评论排行榜