show parameter recovery
SQL> show parameter recovery ;
发现 db_recovery_file_dest_size 值太小了, 当归档超过这个值之后就会报错
ERROR: ORA-00257: archiver error. Connect internal only, until freed.
show archive list
原因:
The database is running in archive log mode with automatic archiving turned on. When the archive log destination diskspace becomes full the automatic archiving will stop. This is expected to happen. At this point a message should appear on the screen: ORACLE Instance v816 - Can not allocate log, archival required When all of the online redo logs are filled up, the database will be in a hang state. After freeing up diskspace the online redo logs are still not archiving. In most cases this is the CORRECT behaviour.
解决方法如下
方法一 :
1. 直接删除 物理数据 rm
2. 通过 rman 删除:
rman target
alter system set DB_RECOVERY_FILE_DEST_SIZE=50g scope=both;