(1)查看数据库REDOLOG情况:
SQL> conn / as sysdba
SQL> select * from v$log;
(2)查看FLASH_RECOVERY_AREA空间使用情况:
SQL> select * from v$recovery_file_dest;
(3)计算flash recovery area已经占用的空间:
SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
(4)归档日志空间已使用了多少百分比SQL> select * from v$flash_recovery_area_usage;
(5)找到recovery目录:
SQL> show parameter recover;
解决方案:
1、增大数据库的存储空间
SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=20g;
2、删除日志
C:/Documents and Settings/Administrator>RMAN TARGET SYS/sysadmin@orcl
SQL>crosscheck archivelog all;
SQL>delete expired archivelog all;
exit