ORACLE清理归档日志

《ORACLE清理归档日志》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、清理归档日志：archivelog日志已满ORA-00257:archivererror.Connectinternalonly,untilfreed错误的处理方法1.用sys用户登录 sqlplussys/pass@ttassysdba2.看看archivlog所在位置SQL>showparameterlog_archive_dest;NAME                                    TYPE       VALUE-------------------------------------------------------------------

2、----------log_archive_dest                  stringlog_archive_dest_1              stringlog_archive_dest_10            string3.一般VALUE为空时，可以用archiveloglist;检查一下归档目录和logsequenceSQL>archiveloglist;Databaselogmode                ArchiveModeAutomaticarchival                  EnabledArchivedestina

3、tion                 USE_DB_RECOVERY_FILE_DESTOldestonlinelogsequence    360Nextlogsequencetoarchive 360Currentlogsequence             3624.检查flashrecoveryarea的使用情况,可以看见archivelog已经很大了，达到96.62SQL>select*fromV$FLASH_RECOVERY_AREA_USAGE;FILE_TYPE   PERCENT_SPACE_USEDPERCENT_SPACE_RECLAIMABLENUM

4、BER_OF_FILES----------------------------------------------------------------------CONTROLFILE                .13                       0              1ONLINELOG                 2.93                       0              3ARCHIVELOG               96.62                      0             141BACK

5、UPPIECE                  0                        0              0IMAGECOPY                     0                        0              0FLASHBACKLOG               0                        0              05.计算flashrecoveryarea已经占用的空间SQL>selectsum(percent_space_used)*3/100fromv$flash_recovery_

6、area_usage;SUM(PERCENT_SPACE_USED)*3/100-----------------------------                      2.9904                      6.找到recovery目录,showparameterrecoverSQL>showparameterrecover;NAME                                TYPE       VALUE--------------------------------------------------------------

7、---------------db_recovery_file_dest               string          /u01/app/oracle/flash_recovery_areadb_recovery_file_dest_size       biginteger  5Grecovery_parallelism                  integer        0                      7上述结果告诉我们，归档位置用的是