大家好，欢迎来到IT知识分享网。
一、错误描述
使用plsql develop工具登录数据库时，有如下报错：
ORA-00257:archiver error. Connect internal only. unitl freed.
二、错误原因
archive log 日志已满
三、处理方法
1.用sys用户登录
$ sqlplus / as sysdba 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 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 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. 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 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 $ rman target / RMAN> delete noprompt archivelog until time 'sysdate-3'; 本次因为服务器空间不足导致rman连接不成功，由于是自己搭建的学习环境，所以选择直接从OS删除文件：
$ cd /oracle/app/fast_recovery_area/orcl/archivelog --orcl为实例名 然后选择删除无用的archivelog 注意：正式环境请谨慎操作！！！
$ 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 * 8.rman连接
$ rman target / 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= 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= STAMP= Crosschecked 101 objects 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 ------- ---- ------- - --------- 1 140 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_140_kndkkw3r_.arc 1 141 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_141_kndklg9l_.arc 1 142 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_142_kndklhrm_.arc 1 143 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_143_kndklk1s_.arc 1 144 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_144_kndklodn_.arc 1 145 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_145_kndklrv5_.arc 1 146 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_146_kndklvxw_.arc 1 147 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_147_kndklz26_.arc 1 148 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_148_kndkm3q0_.arc 1 149 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_149_kndkmhwl_.arc 1 150 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_150_kndkmm2m_.arc 1 151 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_151_kndkmp6q_.arc 1 152 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_152_kndkmsds_.arc 1 153 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_153_kndkmz7o_.arc 1 154 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_154_kndknc7s_.arc 1 155 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_155_knf424c7_.arc 1 156 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_156_knf6bmho_.arc 1 157 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_157_knf6bv2z_.arc 1 158 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_158_knf6bzht_.arc 1 159 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_159_knf6c2hy_.arc 1 160 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_160_knf6c6bo_.arc 1 161 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_161_knf6c98d_.arc 1 162 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_162_knf6cdhb_.arc 1 163 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_163_knf6cpj9_.arc 1 164 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_164_knf6cxj4_.arc 1 165 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_165_knf6g409_.arc 1 166 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_166_knf6hk6l_.arc 1 167 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_167_knf6hqfg_.arc 1 168 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_168_knf6hyp3_.arc 1 169 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_169_knf6jfj0_.arc 1 170 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_170_knf6jz62_.arc 1 171 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_171_knf6k3lo_.arc 1 172 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_172_knf6k9l8_.arc 1 173 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_173_knf6kgnp_.arc 1 174 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_174_knf6kqj3_.arc 1 175 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_175_knf6l5cz_.arc 1 176 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_176_knf6l8kh_.arc 1 177 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_177_knf6lgjc_.arc 1 178 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_178_knf6ll7j_.arc 1 179 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_179_knf6m117_.arc 1 180 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_180_knf6m5p5_.arc 1 181 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_181_knf6mjgt_.arc 1 182 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_182_knf6mqj1_.arc 1 183 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_183_knf6mxvh_.arc 1 184 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_184_knf6ngdr_.arc 1 185 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_185_knf6nnr5_.arc 1 186 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_186_knf6nz2j_.arc 1 187 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_187_knf6o6f3_.arc 1 188 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_188_knf6ot2q_.arc 1 189 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_189_knf6p0b5_.arc 1 190 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_190_knf6p6qs_.arc 1 191 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_191_knf6pcgg_.arc 1 192 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_192_knf6pspp_.arc 1 193 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_193_knf6px78_.arc 1 194 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_194_knf6q0mc_.arc 1 195 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_195_knf6q3wt_.arc 1 196 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_196_knf6qgj8_.arc 1 197 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_197_knf6qvrr_.arc 1 198 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_198_knf6qzll_.arc 1 199 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_199_knf6r30w_.arc 1 200 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_200_knf6r67b_.arc 1 201 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_201_knf6rhjn_.arc 1 202 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_202_knf6sbcl_.arc 1 203 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_203_knf6spfv_.arc 1 204 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_204_knf6t0pp_.arc 1 205 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_205_knf6tf2w_.arc 1 206 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_206_knf6top9_.arc 1 207 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_207_knf6v9j6_.arc 1 208 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_208_knf6vfyl_.arc 1 209 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_209_knf6vms9_.arc 1 210 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_210_knf6w8gw_.arc 1 211 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_211_knf6wpwp_.arc 1 212 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_212_knf6x3tf_.arc 1 213 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_213_knf6xbx7_.arc 1 214 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_214_knf6xrh1_.arc 1 215 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_215_knf6y3p4_.arc 1 216 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_216_knf6y8kn_.arc 1 217 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_217_knf6yb41_.arc 1 218 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_218_knf6yfxs_.arc 1 219 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_219_knf6z2j8_.arc 1 220 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_220_knf6zfgn_.arc 1 221 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_221_knf700jc_.arc 1 222 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_222_knf77wlv_.arc 1 223 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_223_knf7g5lw_.arc 1 224 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_224_knf7m7m2_.arc 1 225 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_225_knfc24md_.arc 1 226 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_226_knfglqmn_.arc 1 227 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_227_knfjdlmn_.arc 1 228 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_228_knfjkkmj_.arc 1 229 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_229_knfjmbmh_.arc 1 230 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_230_knfjodmh_.arc 1 231 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_231_knfl3fnl_.arc 1 232 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_232_kngwq193_.arc 1 233 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_233_kngwq19j_.arc 1 234 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_234_kngwq194_.arc 1 235 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_235_kngwq1pj_.arc 1 236 X 12-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_236_kngwq31v_.arc 1 237 X 13-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_237_kngwq366_.arc 1 238 X 13-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_238_knh0ghrp_.arc 1 239 X 13-OCT-22 Name: /oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_239_knh4mssb_.arc 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= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_141_kndklg9l_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_142_kndklhrm_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_143_kndklk1s_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_144_kndklodn_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_145_kndklrv5_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_146_kndklvxw_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_147_kndklz26_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_148_kndkm3q0_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_149_kndkmhwl_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_150_kndkmm2m_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_151_kndkmp6q_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_152_kndkmsds_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_153_kndkmz7o_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_154_kndknc7s_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_155_knf424c7_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_156_knf6bmho_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_157_knf6bv2z_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_158_knf6bzht_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_159_knf6c2hy_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_160_knf6c6bo_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_161_knf6c98d_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_162_knf6cdhb_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_163_knf6cpj9_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_164_knf6cxj4_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_165_knf6g409_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_166_knf6hk6l_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_167_knf6hqfg_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_168_knf6hyp3_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_169_knf6jfj0_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_170_knf6jz62_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_171_knf6k3lo_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_172_knf6k9l8_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_173_knf6kgnp_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_174_knf6kqj3_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_175_knf6l5cz_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_176_knf6l8kh_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_177_knf6lgjc_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_178_knf6ll7j_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_179_knf6m117_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_180_knf6m5p5_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_181_knf6mjgt_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_182_knf6mqj1_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_183_knf6mxvh_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_184_knf6ngdr_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_185_knf6nnr5_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_186_knf6nz2j_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_187_knf6o6f3_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_188_knf6ot2q_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_189_knf6p0b5_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_190_knf6p6qs_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_191_knf6pcgg_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_192_knf6pspp_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_193_knf6px78_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_194_knf6q0mc_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_195_knf6q3wt_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_196_knf6qgj8_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_197_knf6qvrr_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_198_knf6qzll_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_199_knf6r30w_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_200_knf6r67b_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_201_knf6rhjn_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_202_knf6sbcl_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_203_knf6spfv_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_204_knf6t0pp_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_205_knf6tf2w_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_206_knf6top9_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_207_knf6v9j6_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_208_knf6vfyl_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_209_knf6vms9_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_210_knf6w8gw_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_211_knf6wpwp_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_212_knf6x3tf_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_213_knf6xbx7_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_214_knf6xrh1_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_215_knf6y3p4_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_216_knf6y8kn_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_217_knf6yb41_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_218_knf6yfxs_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_219_knf6z2j8_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_220_knf6zfgn_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_221_knf700jc_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_222_knf77wlv_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_223_knf7g5lw_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_224_knf7m7m2_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_225_knfc24md_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_226_knfglqmn_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_227_knfjdlmn_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_228_knfjkkmj_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_229_knfjmbmh_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_230_knfjodmh_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_12/o1_mf_1_231_knfl3fnl_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_232_kngwq193_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_233_kngwq19j_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_234_kngwq194_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_235_kngwq1pj_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_236_kngwq31v_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_237_kngwq366_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_238_knh0ghrp_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_239_knh4mssb_.arc RECID= STAMP= deleted archived log archived log file name=/oracle/app/fast_recovery_area/ORCL/archivelog/2022_10_13/o1_mf_1_240_knh8y8sm_.arc RECID= STAMP= Deleted 101 EXPIRED objects - 再次查询，发现使用率正常，已经降到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. 免责声明：本站所有文章内容,图片，视频等均是来源于用户投稿和互联网及文摘转载整编而成，不代表本站观点，不承担相关法律责任。其著作权各归其原作者或其出版社所有。如发现本站有涉嫌抄袭侵权/违法违规的内容,侵犯到您的权益，请在线联系站长,一经查实,本站将立刻删除。 本文来自网络,若有侵权，请联系删除，如若转载，请注明出处：https://haidsoft.com/120350.html
