闪回目录空间不足导致drop user cascade报错
imp数据的过程中出错,所有drop user gspx cascade,但一直无法执行完毕,无奈的关闭终端,重新连接数据库后,
再次执行drop user gspx cascade ,这次报错如下:
第1 行出现错误:
ORA-01940: cannot drop a user that is currently connected
从v$session中查看,没有与gspx用户相关的session
conn gspx/gspx 又报错如下:
普通连接报错:
ORA-00257: archiver error. Connect internal only,until freed
系统不能进行归档:
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ---------------
1 1 10 52428800 1 NO INACTIVE
15711794 31-MAY-07
2 1 11 52428800 1 NO CURRENT
15730194 31-MAY-07
3 1 9 52428800 1 NO INACTIVE
ARC字段的值都是NO,表明数据库无法自动归档。
检查归档空间使用情况:
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 99.99 0 527
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0
查看闪回目录的路径以及空间配额
SQL> show parameter db_recovery_file_dest
NAME TYPE V ALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /opt/oracle/flash_recovery_are
a
db_recovery_file_dest_size big integer 2G