热门标签
热门文章
- 1flutter 文件下载及存储路径_flutter 下载文件
- 2探秘Awesome Password Cracking：密码破解的艺术与安全之道
- 3Django中的缓存机制_django5 缓存数据
- 4Ubuntu卸载软件
- 5导入别人的安卓项目方法-需要修改的配置（Androidstudio）通用解决办法_android studio导入别人的项目_studio导入项目
- 6Git和Repo管理使用简要介绍_repo的用git替代
- 72024年Java毕业设计选题大全，500道SpringBoot热门选题大全（持续更新）_java热点毕设项目
- 8论程序员加班的毒副作用
- 9【Charles】-苹果手机 IOS15.4 抓HTTPS包_charles ios
- 10Pandas03
当前位置: article > 正文
ORA-00257 错误处理
作者：很楠不爱3 | 2024-05-26 22:42:25
赞
踩
ora-00257
一、错误描述
使用plsql develop工具登录数据库时，有如下报错：
ORA-00257:archiver error. Connect internal only. unitl freed.
二、错误原因
archive log 日志已满
三、处理方法
1.用sys用户登录
$ sqlplus / as sysdba
- 1
2.查看archivlog所在位置
SQL> show parameter log_archive_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest string log_archive_dest_1 string log_archive_dest_10 string log_archive_dest_11 string log_archive_dest_12 string log_archive_dest_13 string log_archive_dest_14 string log_archive_dest_15 string log_archive_dest_16 string log_archive_dest_17 string log_archive_dest_18 string log_archive_dest_19 string log_archive_dest_2 string log_archive_dest_20 string log_archive_dest_21 string log_archive_dest_22 string log_archive_dest_23 string log_archive_dest_24 string log_archive_dest_25 string log_archive_dest_26 string log_archive_dest_27 string log_archive_dest_28 string log_archive_dest_29 string log_archive_dest_3 string log_archive_dest_30 string log_archive_dest_31 string log_archive_dest_4 string log_archive_dest_5 string log_archive_dest_6 string log_archive_dest_7 string log_archive_dest_8 string log_archive_dest_9 string log_archive_dest_state_1 string enable log_archive_dest_state_10 string enable log_archive_dest_state_11 string enable log_archive_dest_state_12 string enable log_archive_dest_state_13 string enable log_archive_dest_state_14 string enable log_archive_dest_state_15 string enable log_archive_dest_state_16 string enable log_archive_dest_state_17 string enable log_archive_dest_state_18 string enable log_archive_dest_state_19 string enable log_archive_dest_state_2 string enable log_archive_dest_state_20 string enable log_archive_dest_state_21 string enable log_archive_dest_state_22 string enable log_archive_dest_state_23 string enable log_archive_dest_state_24 string enable log_archive_dest_state_25 string enable log_archive_dest_state_26 string enable log_archive_dest_state_27 string enable log_archive_dest_state_28 string enable log_archive_dest_state_29 string enable log_archive_dest_state_3 string enable log_archive_dest_state_30 string enable log_archive_dest_state_31 string enable log_archive_dest_state_4 string enable log_archive_dest_state_5 string enable log_archive_dest_state_6 string enable log_archive_dest_state_7 string enable log_archive_dest_state_8 string enable log_archive_dest_state_9 string enable
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
3.VALUE为空时，可用archive log list;查看归档目录和log sequence
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 236
Next log sequence to archive 241
Current log sequence 241
- 1
- 2
- 3
- 4
- 5
- 6
- 7
4.查看flash recovery area的使用情况
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 91.18 0 101 BACKUP PIECE .55 0 1 IMAGE COPY 0 0 0 FLASHBACK LOG 0 0 0 FOREIGN ARCHIVED LOG 0 0 0 7 rows selected.
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
5.计算flash recovery area已经占用的空间
SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
SUM(PERCENT_SPACE_USED)*3/100
-----------------------------
2.7519
- 1
- 2
- 3
- 4
- 5
6.查看recovery目录
SQL> show parameter recover;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oracle/app/fast_recovery_area
db_recovery_file_dest_size big integer 4182M
db_unrecoverable_scn_tracking boolean TRUE
recovery_parallelism integer 0
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
7.转移或清除对应的归档日志
$ cd /oracle/app/fast_recovery_area/orcl/archivelog --orcl为实例名
然后选择删除无用的archivelog
- 1
- 2
我这里因为是用来自我学习的测试环境，所以把归档日志全部删除了：
正式环境请谨慎操作！！！
$ cd /oracle/app/fast_recovery_area/orcl/archivelog
$ du * -sh --time
0 2022-10-13 10:07 2022_10_11
3.5G 2022-10-13 10:07 2022_10_12
262M 2022-10-13 13:36 2022_10_13
$ rm -rf *
- 1
- 2
- 3
- 4
- 5
- 6
注意:
在删除归档日志后，必须用RMAN维护控制文件，否则空间显示仍然不释放。
8.rman连接
$ rman target /
- 1
9.检查无用的archivelog
RMAN> crosscheck archivelog all; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=185 device type=DISK validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_140_kndkkw3r_.arc RECID=226994 STAMP=1117889085 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_141_kndklg9l_.arc RECID=226995 STAMP=1117889102 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_142_kndklhrm_.arc RECID=226996 STAMP=1117889103 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_143_kndklk1s_.arc RECID=226997 STAMP=1117889105 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_144_kndklodn_.arc RECID=226998 STAMP=1117889109 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_145_kndklrv5_.arc RECID=226999 STAMP=1117889112 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_146_kndklvxw_.arc RECID=227000 STAMP=1117889116 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_147_kndklz26_.arc RECID=227001 STAMP=1117889119 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_148_kndkm3q0_.arc RECID=227002 STAMP=1117889124 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_149_kndkmhwl_.arc RECID=227003 STAMP=1117889135 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_150_kndkmm2m_.arc RECID=227004 STAMP=1117889139 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_151_kndkmp6q_.arc RECID=227005 STAMP=1117889142 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_152_kndkmsds_.arc RECID=227006 STAMP=1117889145 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_153_kndkmz7o_.arc RECID=227007 STAMP=1117889151 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_154_kndknc7s_.arc RECID=227008 STAMP=1117889163 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_155_knf424c7_.arc RECID=227009 STAMP=1117908036 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_156_knf6bmho_.arc RECID=227010 STAMP=1117910355 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_157_knf6bv2z_.arc RECID=227011 STAMP=1117910363 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_158_knf6bzht_.arc RECID=227012 STAMP=1117910367 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_159_knf6c2hy_.arc RECID=227013 STAMP=1117910370 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_160_knf6c6bo_.arc RECID=227014 STAMP=1117910374 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_161_knf6c98d_.arc RECID=227015 STAMP=1117910377 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_162_knf6cdhb_.arc RECID=227016 STAMP=1117910380 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_163_knf6cpj9_.arc RECID=227017 STAMP=1117910390 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_164_knf6cxj4_.arc RECID=227018 STAMP=1117910398 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_165_knf6g409_.arc RECID=227019 STAMP=1117910468 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_166_knf6hk6l_.arc RECID=227020 STAMP=1117910513 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_167_knf6hqfg_.arc RECID=227021 STAMP=1117910519 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_168_knf6hyp3_.arc RECID=227022 STAMP=1117910526 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_169_knf6jfj0_.arc RECID=227023 STAMP=1117910541 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_170_knf6jz62_.arc RECID=227024 STAMP=1117910559 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_171_knf6k3lo_.arc RECID=227025 STAMP=1117910563 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_172_knf6k9l8_.arc RECID=227026 STAMP=1117910569 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_173_knf6kgnp_.arc RECID=227027 STAMP=1117910574 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_174_knf6kqj3_.arc RECID=227028 STAMP=1117910583 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_175_knf6l5cz_.arc RECID=227029 STAMP=1117910597 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_176_knf6l8kh_.arc RECID=227030 STAMP=1117910600 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_177_knf6lgjc_.arc RECID=227031 STAMP=1117910606 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_178_knf6ll7j_.arc RECID=227032 STAMP=1117910610 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_179_knf6m117_.arc RECID=227033 STAMP=1117910625 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_180_knf6m5p5_.arc RECID=227034 STAMP=1117910629 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_181_knf6mjgt_.arc RECID=227035 STAMP=1117910640 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_182_knf6mqj1_.arc RECID=227036 STAMP=1117910647 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_183_knf6mxvh_.arc RECID=227037 STAMP=1117910654 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_184_knf6ngdr_.arc RECID=227038 STAMP=1117910670 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_185_knf6nnr5_.arc RECID=227039 STAMP=1117910676 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_186_knf6nz2j_.arc RECID=227040 STAMP=1117910687 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_187_knf6o6f3_.arc RECID=227041 STAMP=1117910694 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_188_knf6ot2q_.arc RECID=227042 STAMP=1117910714 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_189_knf6p0b5_.arc RECID=227043 STAMP=1117910720 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_190_knf6p6qs_.arc RECID=227044 STAMP=1117910726 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_191_knf6pcgg_.arc RECID=227045 STAMP=1117910732 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_192_knf6pspp_.arc RECID=227046 STAMP=1117910745 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_193_knf6px78_.arc RECID=227047 STAMP=1117910749 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_194_knf6q0mc_.arc RECID=227048 STAMP=1117910752 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_195_knf6q3wt_.arc RECID=227049 STAMP=1117910755 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_196_knf6qgj8_.arc RECID=227050 STAMP=1117910766 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_197_knf6qvrr_.arc RECID=227051 STAMP=1117910779 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_198_knf6qzll_.arc RECID=227052 STAMP=1117910783 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_199_knf6r30w_.arc RECID=227053 STAMP=1117910787 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_200_knf6r67b_.arc RECID=227054 STAMP=1117910790 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_201_knf6rhjn_.arc RECID=227055 STAMP=1117910799 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_202_knf6sbcl_.arc RECID=227056 STAMP=1117910826 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_203_knf6spfv_.arc RECID=227057 STAMP=1117910838 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_204_knf6t0pp_.arc RECID=227058 STAMP=1117910848 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_205_knf6tf2w_.arc RECID=227059 STAMP=1117910861 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_206_knf6top9_.arc RECID=227060 STAMP=1117910869 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_207_knf6v9j6_.arc RECID=227061 STAMP=1117910889 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_208_knf6vfyl_.arc RECID=227062 STAMP=1117910894 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_209_knf6vms9_.arc RECID=227063 STAMP=1117910899 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_210_knf6w8gw_.arc RECID=227064 STAMP=1117910920 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_211_knf6wpwp_.arc RECID=227065 STAMP=1117910934 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_212_knf6x3tf_.arc RECID=227066 STAMP=1117910947 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_213_knf6xbx7_.arc RECID=227067 STAMP=1117910955 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_214_knf6xrh1_.arc RECID=227068 STAMP=1117910968 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_215_knf6y3p4_.arc RECID=227069 STAMP=1117910979 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_216_knf6y8kn_.arc RECID=227070 STAMP=1117910984 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_217_knf6yb41_.arc RECID=227071 STAMP=1117910986 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_218_knf6yfxs_.arc RECID=227072 STAMP=1117910990 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_219_knf6z2j8_.arc RECID=227073 STAMP=1117911010 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_220_knf6zfgn_.arc RECID=227074 STAMP=1117911021 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_221_knf700jc_.arc RECID=227075 STAMP=1117911040 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_222_knf77wlv_.arc RECID=227076 STAMP=1117911292 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_223_knf7g5lw_.arc RECID=227077 STAMP=1117911493 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_224_knf7m7m2_.arc RECID=227078 STAMP=1117911655 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_225_knfc24md_.arc RECID=227079 STAMP=1117915204 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_226_knfglqmn_.arc RECID=227080 STAMP=1117918807 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_227_knfjdlmn_.arc RECID=227081 STAMP=1117920658 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_228_knfjkkmj_.arc RECID=227082 STAMP=1117920817 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_229_knfjmbmh_.arc RECID=227083 STAMP=1117920874 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_230_knfjodmh_.arc RECID=227084 STAMP=1117920940 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_231_knfl3fnl_.arc RECID=227085 STAMP=1117922413 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_232_kngwq193_.arc RECID=227087 STAMP=1117966051 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_233_kngwq19j_.arc RECID=227088 STAMP=1117966052 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_234_kngwq194_.arc RECID=227086 STAMP=1117966051 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_235_kngwq1pj_.arc RECID=227089 STAMP=1117966052 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_236_kngwq31v_.arc RECID=227090 STAMP=1117966054 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_237_kngwq366_.arc RECID=227091 STAMP=1117966054 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_238_knh0ghrp_.arc RECID=227092 STAMP=1117969871 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_239_knh4mssb_.arc RECID=227093 STAMP=1117974137 validation failed for archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_240_knh8y8sm_.arc RECID=227094 STAMP=1117978568 Crosschecked 101 objects
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
- 202
- 203
- 204
- 205
- 206
- 207
- 208
10.删除过期的归档
RMAN> delete expired archivelog all; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=185 device type=DISK List of Archived Log Copies for database with db_unique_name ORCL ===================================================================== Key Thrd Seq S Low Time ------- ---- ------- - --------- 226994 1 140 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_140_kndkkw3r_.arc 226995 1 141 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_141_kndklg9l_.arc 226996 1 142 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_142_kndklhrm_.arc 226997 1 143 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_143_kndklk1s_.arc 226998 1 144 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_144_kndklodn_.arc 226999 1 145 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_145_kndklrv5_.arc 227000 1 146 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_146_kndklvxw_.arc 227001 1 147 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_147_kndklz26_.arc 227002 1 148 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_148_kndkm3q0_.arc 227003 1 149 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_149_kndkmhwl_.arc 227004 1 150 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_150_kndkmm2m_.arc 227005 1 151 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_151_kndkmp6q_.arc 227006 1 152 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_152_kndkmsds_.arc 227007 1 153 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_153_kndkmz7o_.arc 227008 1 154 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_154_kndknc7s_.arc 227009 1 155 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_155_knf424c7_.arc 227010 1 156 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_156_knf6bmho_.arc 227011 1 157 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_157_knf6bv2z_.arc 227012 1 158 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_158_knf6bzht_.arc 227013 1 159 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_159_knf6c2hy_.arc 227014 1 160 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_160_knf6c6bo_.arc 227015 1 161 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_161_knf6c98d_.arc 227016 1 162 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_162_knf6cdhb_.arc 227017 1 163 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_163_knf6cpj9_.arc 227018 1 164 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_164_knf6cxj4_.arc 227019 1 165 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_165_knf6g409_.arc 227020 1 166 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_166_knf6hk6l_.arc 227021 1 167 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_167_knf6hqfg_.arc 227022 1 168 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_168_knf6hyp3_.arc 227023 1 169 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_169_knf6jfj0_.arc 227024 1 170 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_170_knf6jz62_.arc 227025 1 171 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_171_knf6k3lo_.arc 227026 1 172 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_172_knf6k9l8_.arc 227027 1 173 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_173_knf6kgnp_.arc 227028 1 174 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_174_knf6kqj3_.arc 227029 1 175 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_175_knf6l5cz_.arc 227030 1 176 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_176_knf6l8kh_.arc 227031 1 177 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_177_knf6lgjc_.arc 227032 1 178 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_178_knf6ll7j_.arc 227033 1 179 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_179_knf6m117_.arc 227034 1 180 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_180_knf6m5p5_.arc 227035 1 181 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_181_knf6mjgt_.arc 227036 1 182 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_182_knf6mqj1_.arc 227037 1 183 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_183_knf6mxvh_.arc 227038 1 184 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_184_knf6ngdr_.arc 227039 1 185 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_185_knf6nnr5_.arc 227040 1 186 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_186_knf6nz2j_.arc 227041 1 187 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_187_knf6o6f3_.arc 227042 1 188 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_188_knf6ot2q_.arc 227043 1 189 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_189_knf6p0b5_.arc 227044 1 190 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_190_knf6p6qs_.arc 227045 1 191 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_191_knf6pcgg_.arc 227046 1 192 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_192_knf6pspp_.arc 227047 1 193 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_193_knf6px78_.arc 227048 1 194 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_194_knf6q0mc_.arc 227049 1 195 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_195_knf6q3wt_.arc 227050 1 196 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_196_knf6qgj8_.arc 227051 1 197 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_197_knf6qvrr_.arc 227052 1 198 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_198_knf6qzll_.arc 227053 1 199 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_199_knf6r30w_.arc 227054 1 200 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_200_knf6r67b_.arc 227055 1 201 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_201_knf6rhjn_.arc 227056 1 202 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_202_knf6sbcl_.arc 227057 1 203 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_203_knf6spfv_.arc 227058 1 204 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_204_knf6t0pp_.arc 227059 1 205 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_205_knf6tf2w_.arc 227060 1 206 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_206_knf6top9_.arc 227061 1 207 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_207_knf6v9j6_.arc 227062 1 208 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_208_knf6vfyl_.arc 227063 1 209 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_209_knf6vms9_.arc 227064 1 210 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_210_knf6w8gw_.arc 227065 1 211 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_211_knf6wpwp_.arc 227066 1 212 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_212_knf6x3tf_.arc 227067 1 213 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_213_knf6xbx7_.arc 227068 1 214 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_214_knf6xrh1_.arc 227069 1 215 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_215_knf6y3p4_.arc 227070 1 216 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_216_knf6y8kn_.arc 227071 1 217 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_217_knf6yb41_.arc 227072 1 218 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_218_knf6yfxs_.arc 227073 1 219 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_219_knf6z2j8_.arc 227074 1 220 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_220_knf6zfgn_.arc 227075 1 221 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_221_knf700jc_.arc 227076 1 222 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_222_knf77wlv_.arc 227077 1 223 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_223_knf7g5lw_.arc 227078 1 224 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_224_knf7m7m2_.arc 227079 1 225 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_225_knfc24md_.arc 227080 1 226 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_226_knfglqmn_.arc 227081 1 227 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_227_knfjdlmn_.arc 227082 1 228 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_228_knfjkkmj_.arc 227083 1 229 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_229_knfjmbmh_.arc 227084 1 230 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_230_knfjodmh_.arc 227085 1 231 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_231_knfl3fnl_.arc 227087 1 232 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_232_kngwq193_.arc 227088 1 233 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_233_kngwq19j_.arc 227086 1 234 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_234_kngwq194_.arc 227089 1 235 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_235_kngwq1pj_.arc 227090 1 236 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_236_kngwq31v_.arc 227091 1 237 X 13-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_237_kngwq366_.arc 227092 1 238 X 13-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_238_knh0ghrp_.arc 227093 1 239 X 13-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_239_knh4mssb_.arc 227094 1 240 X 13-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_240_knh8y8sm_.arc Do you really want to delete the above objects (enter YES or NO)? yes deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_140_kndkkw3r_.arc RECID=226994 STAMP=1117889085 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_141_kndklg9l_.arc RECID=226995 STAMP=1117889102 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_142_kndklhrm_.arc RECID=226996 STAMP=1117889103 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_143_kndklk1s_.arc RECID=226997 STAMP=1117889105 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_144_kndklodn_.arc RECID=226998 STAMP=1117889109 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_145_kndklrv5_.arc RECID=226999 STAMP=1117889112 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_146_kndklvxw_.arc RECID=227000 STAMP=1117889116 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_147_kndklz26_.arc RECID=227001 STAMP=1117889119 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_148_kndkm3q0_.arc RECID=227002 STAMP=1117889124 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_149_kndkmhwl_.arc RECID=227003 STAMP=1117889135 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_150_kndkmm2m_.arc RECID=227004 STAMP=1117889139 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_151_kndkmp6q_.arc RECID=227005 STAMP=1117889142 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_152_kndkmsds_.arc RECID=227006 STAMP=1117889145 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_153_kndkmz7o_.arc RECID=227007 STAMP=1117889151 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_154_kndknc7s_.arc RECID=227008 STAMP=1117889163 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_155_knf424c7_.arc RECID=227009 STAMP=1117908036 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_156_knf6bmho_.arc RECID=227010 STAMP=1117910355 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_157_knf6bv2z_.arc RECID=227011 STAMP=1117910363 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_158_knf6bzht_.arc RECID=227012 STAMP=1117910367 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_159_knf6c2hy_.arc RECID=227013 STAMP=1117910370 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_160_knf6c6bo_.arc RECID=227014 STAMP=1117910374 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_161_knf6c98d_.arc RECID=227015 STAMP=1117910377 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_162_knf6cdhb_.arc RECID=227016 STAMP=1117910380 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_163_knf6cpj9_.arc RECID=227017 STAMP=1117910390 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_164_knf6cxj4_.arc RECID=227018 STAMP=1117910398 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_165_knf6g409_.arc RECID=227019 STAMP=1117910468 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_166_knf6hk6l_.arc RECID=227020 STAMP=1117910513 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_167_knf6hqfg_.arc RECID=227021 STAMP=1117910519 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_168_knf6hyp3_.arc RECID=227022 STAMP=1117910526 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_169_knf6jfj0_.arc RECID=227023 STAMP=1117910541 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_170_knf6jz62_.arc RECID=227024 STAMP=1117910559 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_171_knf6k3lo_.arc RECID=227025 STAMP=1117910563 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_172_knf6k9l8_.arc RECID=227026 STAMP=1117910569 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_173_knf6kgnp_.arc RECID=227027 STAMP=1117910574 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_174_knf6kqj3_.arc RECID=227028 STAMP=1117910583 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_175_knf6l5cz_.arc RECID=227029 STAMP=1117910597 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_176_knf6l8kh_.arc RECID=227030 STAMP=1117910600 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_177_knf6lgjc_.arc RECID=227031 STAMP=1117910606 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_178_knf6ll7j_.arc RECID=227032 STAMP=1117910610 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_179_knf6m117_.arc RECID=227033 STAMP=1117910625 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_180_knf6m5p5_.arc RECID=227034 STAMP=1117910629 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_181_knf6mjgt_.arc RECID=227035 STAMP=1117910640 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_182_knf6mqj1_.arc RECID=227036 STAMP=1117910647 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_183_knf6mxvh_.arc RECID=227037 STAMP=1117910654 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_184_knf6ngdr_.arc RECID=227038 STAMP=1117910670 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_185_knf6nnr5_.arc RECID=227039 STAMP=1117910676 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_186_knf6nz2j_.arc RECID=227040 STAMP=1117910687 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_187_knf6o6f3_.arc RECID=227041 STAMP=1117910694 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_188_knf6ot2q_.arc RECID=227042 STAMP=1117910714 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_189_knf6p0b5_.arc RECID=227043 STAMP=1117910720 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_190_knf6p6qs_.arc RECID=227044 STAMP=1117910726 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_191_knf6pcgg_.arc RECID=227045 STAMP=1117910732 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_192_knf6pspp_.arc RECID=227046 STAMP=1117910745 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_193_knf6px78_.arc RECID=227047 STAMP=1117910749 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_194_knf6q0mc_.arc RECID=227048 STAMP=1117910752 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_195_knf6q3wt_.arc RECID=227049 STAMP=1117910755 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_196_knf6qgj8_.arc RECID=227050 STAMP=1117910766 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_197_knf6qvrr_.arc RECID=227051 STAMP=1117910779 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_198_knf6qzll_.arc RECID=227052 STAMP=1117910783 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_199_knf6r30w_.arc RECID=227053 STAMP=1117910787 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_200_knf6r67b_.arc RECID=227054 STAMP=1117910790 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_201_knf6rhjn_.arc RECID=227055 STAMP=1117910799 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_202_knf6sbcl_.arc RECID=227056 STAMP=1117910826 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_203_knf6spfv_.arc RECID=227057 STAMP=1117910838 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_204_knf6t0pp_.arc RECID=227058 STAMP=1117910848 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_205_knf6tf2w_.arc RECID=227059 STAMP=1117910861 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_206_knf6top9_.arc RECID=227060 STAMP=1117910869 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_207_knf6v9j6_.arc RECID=227061 STAMP=1117910889 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_208_knf6vfyl_.arc RECID=227062 STAMP=1117910894 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_209_knf6vms9_.arc RECID=227063 STAMP=1117910899 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_210_knf6w8gw_.arc RECID=227064 STAMP=1117910920 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_211_knf6wpwp_.arc RECID=227065 STAMP=1117910934 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_212_knf6x3tf_.arc RECID=227066 STAMP=1117910947 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_213_knf6xbx7_.arc RECID=227067 STAMP=1117910955 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_214_knf6xrh1_.arc RECID=227068 STAMP=1117910968 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_215_knf6y3p4_.arc RECID=227069 STAMP=1117910979 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_216_knf6y8kn_.arc RECID=227070 STAMP=1117910984 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_217_knf6yb41_.arc RECID=227071 STAMP=1117910986 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_218_knf6yfxs_.arc RECID=227072 STAMP=1117910990 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_219_knf6z2j8_.arc RECID=227073 STAMP=1117911010 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_220_knf6zfgn_.arc RECID=227074 STAMP=1117911021 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_221_knf700jc_.arc RECID=227075 STAMP=1117911040 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_222_knf77wlv_.arc RECID=227076 STAMP=1117911292 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_223_knf7g5lw_.arc RECID=227077 STAMP=1117911493 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_224_knf7m7m2_.arc RECID=227078 STAMP=1117911655 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_225_knfc24md_.arc RECID=227079 STAMP=1117915204 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_226_knfglqmn_.arc RECID=227080 STAMP=1117918807 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_227_knfjdlmn_.arc RECID=227081 STAMP=1117920658 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_228_knfjkkmj_.arc RECID=227082 STAMP=1117920817 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_229_knfjmbmh_.arc RECID=227083 STAMP=1117920874 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_230_knfjodmh_.arc RECID=227084 STAMP=1117920940 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_231_knfl3fnl_.arc RECID=227085 STAMP=1117922413 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_232_kngwq193_.arc RECID=227087 STAMP=1117966051 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_233_kngwq19j_.arc RECID=227088 STAMP=1117966052 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_234_kngwq194_.arc RECID=227086 STAMP=1117966051 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_235_kngwq1pj_.arc RECID=227089 STAMP=1117966052 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_236_kngwq31v_.arc RECID=227090 STAMP=1117966054 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_237_kngwq366_.arc RECID=227091 STAMP=1117966054 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_238_knh0ghrp_.arc RECID=227092 STAMP=1117969871 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_239_knh4mssb_.arc RECID=227093 STAMP=1117974137 deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_240_knh8y8sm_.arc RECID=227094 STAMP=1117978568 Deleted 101 EXPIRED objects
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
- 202
- 203
- 204
- 205
- 206
- 207
- 208
- 209
- 210
- 211
- 212
- 213
- 214
- 215
- 216
- 217
- 218
- 219
- 220
- 221
- 222
- 223
- 224
- 225
- 226
- 227
- 228
- 229
- 230
- 231
- 232
- 233
- 234
- 235
- 236
- 237
- 238
- 239
- 240
- 241
- 242
- 243
- 244
- 245
- 246
- 247
- 248
- 249
- 250
- 251
- 252
- 253
- 254
- 255
- 256
- 257
- 258
- 259
- 260
- 261
- 262
- 263
- 264
- 265
- 266
- 267
- 268
- 269
- 270
- 271
- 272
- 273
- 274
- 275
- 276
- 277
- 278
- 279
- 280
- 281
- 282
- 283
- 284
- 285
- 286
- 287
- 288
- 289
- 290
- 291
- 292
- 293
- 294
- 295
- 296
- 297
- 298
- 299
- 300
- 301
- 302
- 303
- 304
- 305
- 306
- 307
- 308
- 309
- 310
- 311
- 312
- 313
- 314
- 315
- 316
- 317
- 318
- 319
- 320
- 321
- 322
- 323
- 324
- 325
- 326
- 327
- 328
- 329
- 330
- 331
- 332
- 333
- 334
- 335
- 336
- 337
- 338
- 339
- 340
- 341
- 342
- 343
- 344
- 345
- 346
- 347
- 348
- 349
- 350
- 351
- 352
- 353
- 354
- 355
- 356
- 357
- 358
- 359
- 360
- 361
- 362
- 363
- 364
- 365
- 366
- 367
- 368
- 369
- 370
- 371
- 372
- 373
- 374
- 375
- 376
- 377
- 378
- 379
- 380
- 381
- 382
- 383
- 384
- 385
- 386
- 387
- 388
- 389
- 390
- 391
- 392
- 393
- 394
- 395
- 396
- 397
- 398
- 399
- 400
- 401
- 402
- 403
- 404
- 405
- 406
- 407
- 408
- 409
- 410
- 411
- 412
- 413
- 414
- 415
- 416
- 417
- 418
- 419
- 420
- 421
- 422
- 423
- 424
- 425
- 426
- 427
- 428
- 429
- 430
- 431
- 432
- 433
- 434
- 435
- 436
- 437
- 438
- 439
- 440
- 441
- 442
- 443
- 444
- 445
- 446
- 447
- 448
- 449
- 450
- 451
- 452
- 453
- 454
- 455
- 456
- 457
- 458
- 459
- 460
- 461
- 462
- 463
- 464
- 465
- 466
- 467
- 468
- 469
- 470
- 471
- 472
- 473
- 474
- 475
- 476
- 477
- 478
- 479
- 480
- 481
- 482
- 483
- 484
- 485
- 486
- 487
- 488
- 489
- 490
- 491
- 492
- 493
- 494
- 495
- 496
- 497
- 498
- 499
- 500
- 501
- 502
- 503
- 504
- 505
- 506
- 507
- 508
- 509
- 510
- 511
- 512
- 513
- 514
- 515
- 516
- 517
- 518
- 再次查询，发现使用率正常，已经降到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 0 0 101 BACKUP PIECE .55 0 1 IMAGE COPY 0 0 0 FLASHBACK LOG 0 0 0 FOREIGN ARCHIVED LOG 0 0 0 7 rows selected.
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/很楠不爱3/article/detail/628729
推荐阅读
相关标签
