ITPub博客

首页 > 数据库 > Oracle > ORA-00257: archiver error. Connect internal only, until freed

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

原创 Oracle 作者:sepulcrum 时间:2009-01-19 09:05:31 0 删除 编辑

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED
------------------------------------------------------------ ------------------
PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------- ---------------
CONTROL FILE 0
0 0

REDO LOG 0
0 0

ARCHIVED LOG 92.64
0 229


FILE_TYPE PERCENT_SPACE_USED
------------------------------------------------------------ ------------------
PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------- ---------------
BACKUP PIECE 7.29
0 2

IMAGE COPY 0
0 0

FLASHBACK LOG 0
0 0


FILE_TYPE PERCENT_SPACE_USED
------------------------------------------------------------ ------------------
PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------- ---------------
FOREIGN ARCHIVED LOG 0
0 0


7 rows selected.

1.alter system set DB_RECOVERY_FILE_DEST_SIZE=20g;

2.delete in OS, then

crosscheck archivelog all;
delete noprompt expired archivelog all;

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/10897379/viewspace-1016295/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: sql优化
请登录后发表评论 登录
全部评论
  • 博文量
    26
  • 访问量
    174263