Oracle报错:ORA-00257 错误处理

一、错误描述

使用plsql develop工具登录数据库时,有如下报错:

ORA-00257:archiver error. Connect internal only. unitl freed.

二、错误原因

archive log 日志已满

三、处理方法

1.用sys用户登录

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 13 13:52:09 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

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

7.转移或清除对应的归档日志

$ cd /oracle/app/fast_recovery_area/test/archivelog  --test未实例名
 然后选择删除无用的archivelog

8.rman连接

$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 13 14:11:12 2022

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: WIND (DBID=860882744)

9.检查无用的archivelog

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=196 device type=DISK
validation failed for archived log
archived log file name=/oracle/app/fast_recovery_area/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/archivelog/2022_10_13/o1_mf_1_240_knh8y8sm_.arc RECID=227094 STAMP=1117978568
Crosschecked 101 objects

10.删除过期的归档

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=196 device type=DISK
List of Archived Log Copies for database with db_unique_name WIND
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
226994  1    140     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_140_kndkkw3r_.arc

226995  1    141     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_141_kndklg9l_.arc

226996  1    142     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_142_kndklhrm_.arc

226997  1    143     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_143_kndklk1s_.arc

226998  1    144     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_144_kndklodn_.arc

226999  1    145     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_145_kndklrv5_.arc

227000  1    146     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_146_kndklvxw_.arc

227001  1    147     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_147_kndklz26_.arc

227002  1    148     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_148_kndkm3q0_.arc

227003  1    149     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_149_kndkmhwl_.arc

227004  1    150     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_150_kndkmm2m_.arc

227005  1    151     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_151_kndkmp6q_.arc

227006  1    152     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_152_kndkmsds_.arc

227007  1    153     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_153_kndkmz7o_.arc

227008  1    154     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_154_kndknc7s_.arc

227009  1    155     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_155_knf424c7_.arc

227010  1    156     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_156_knf6bmho_.arc

227011  1    157     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_157_knf6bv2z_.arc

227012  1    158     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_158_knf6bzht_.arc

227013  1    159     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_159_knf6c2hy_.arc

227014  1    160     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_160_knf6c6bo_.arc

227015  1    161     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_161_knf6c98d_.arc

227016  1    162     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_162_knf6cdhb_.arc

227017  1    163     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_163_knf6cpj9_.arc

227018  1    164     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_164_knf6cxj4_.arc

227019  1    165     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_165_knf6g409_.arc

227020  1    166     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_166_knf6hk6l_.arc

227021  1    167     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_167_knf6hqfg_.arc

227022  1    168     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_168_knf6hyp3_.arc

227023  1    169     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_169_knf6jfj0_.arc

227024  1    170     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_170_knf6jz62_.arc

227025  1    171     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_171_knf6k3lo_.arc

227026  1    172     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_172_knf6k9l8_.arc

227027  1    173     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_173_knf6kgnp_.arc

227028  1    174     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_174_knf6kqj3_.arc

227029  1    175     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_175_knf6l5cz_.arc

227030  1    176     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_176_knf6l8kh_.arc

227031  1    177     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_177_knf6lgjc_.arc

227032  1    178     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_178_knf6ll7j_.arc

227033  1    179     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_179_knf6m117_.arc

227034  1    180     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_180_knf6m5p5_.arc

227035  1    181     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_181_knf6mjgt_.arc

227036  1    182     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_182_knf6mqj1_.arc

227037  1    183     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_183_knf6mxvh_.arc

227038  1    184     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_184_knf6ngdr_.arc

227039  1    185     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_185_knf6nnr5_.arc

227040  1    186     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_186_knf6nz2j_.arc

227041  1    187     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_187_knf6o6f3_.arc

227042  1    188     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_188_knf6ot2q_.arc

227043  1    189     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_189_knf6p0b5_.arc

227044  1    190     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_190_knf6p6qs_.arc

227045  1    191     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_191_knf6pcgg_.arc

227046  1    192     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_192_knf6pspp_.arc

227047  1    193     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_193_knf6px78_.arc

227048  1    194     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_194_knf6q0mc_.arc

227049  1    195     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_195_knf6q3wt_.arc

227050  1    196     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_196_knf6qgj8_.arc

227051  1    197     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_197_knf6qvrr_.arc

227052  1    198     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_198_knf6qzll_.arc

227053  1    199     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_199_knf6r30w_.arc

227054  1    200     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_200_knf6r67b_.arc

227055  1    201     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_201_knf6rhjn_.arc

227056  1    202     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_202_knf6sbcl_.arc

227057  1    203     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_203_knf6spfv_.arc

227058  1    204     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_204_knf6t0pp_.arc

227059  1    205     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_205_knf6tf2w_.arc

227060  1    206     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_206_knf6top9_.arc

227061  1    207     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_207_knf6v9j6_.arc

227062  1    208     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_208_knf6vfyl_.arc

227063  1    209     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_209_knf6vms9_.arc

227064  1    210     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_210_knf6w8gw_.arc

227065  1    211     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_211_knf6wpwp_.arc

227066  1    212     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_212_knf6x3tf_.arc

227067  1    213     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_213_knf6xbx7_.arc

227068  1    214     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_214_knf6xrh1_.arc

227069  1    215     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_215_knf6y3p4_.arc

227070  1    216     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_216_knf6y8kn_.arc

227071  1    217     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_217_knf6yb41_.arc

227072  1    218     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_218_knf6yfxs_.arc

227073  1    219     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_219_knf6z2j8_.arc

227074  1    220     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_220_knf6zfgn_.arc

227075  1    221     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_221_knf700jc_.arc

227076  1    222     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_222_knf77wlv_.arc

227077  1    223     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_223_knf7g5lw_.arc

227078  1    224     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_224_knf7m7m2_.arc

227079  1    225     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_225_knfc24md_.arc

227080  1    226     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_226_knfglqmn_.arc

227081  1    227     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_227_knfjdlmn_.arc

227082  1    228     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_228_knfjkkmj_.arc

227083  1    229     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_229_knfjmbmh_.arc

227084  1    230     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_230_knfjodmh_.arc

227085  1    231     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_12/o1_mf_1_231_knfl3fnl_.arc

227087  1    232     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_13/o1_mf_1_232_kngwq193_.arc

227088  1    233     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_13/o1_mf_1_233_kngwq19j_.arc

227086  1    234     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_13/o1_mf_1_234_kngwq194_.arc

227089  1    235     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_13/o1_mf_1_235_kngwq1pj_.arc

227090  1    236     X 12-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_13/o1_mf_1_236_kngwq31v_.arc

227091  1    237     X 13-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_13/o1_mf_1_237_kngwq366_.arc

227092  1    238     X 13-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_13/o1_mf_1_238_knh0ghrp_.arc

227093  1    239     X 13-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/archivelog/2022_10_13/o1_mf_1_239_knh4mssb_.arc

227094  1    240     X 13-OCT-22
        Name: /oracle/app/fast_recovery_area/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/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/WIND/archivelog/2022_10_13/o1_mf_1_240_knh8y8sm_.arc RECID=227094 STAMP=1117978568
Deleted 101 EXPIRED objects

11.删除过期的归档

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://www.cnaaa.net,转载请注明出处:https://www.cnaaa.net/archives/7760

(0)
杰斯的头像杰斯
上一篇 2023年3月25日 下午2:54
下一篇 2023年3月27日 下午4:11

相关推荐

  • root用户无法访问Mysql数据库问题的解决

    在使用Centos系统远程访问Mysql数据库的时候,系统提示报如下错误: 经过验证以下方案可以解决问题: 1.首先停止mysql服务器 2.无权限启动mysql服务 3..登录mysql 4..重新载入权限 5.. 选择系统数据库mysql 6..查询系统表user中的用户 7.向root用户赋值权限

    2023年6月20日
    23900
  • Mysql5.5中文乱码问题

    查看MySQL的字符集 发现有部分不是utf-8 一(推荐,本人实验有用) 修改MySQL配置文件,来到mysql安装目录,找到my.ini文件(可能没有此文件,没有就自己建一个,本人就是没有该文件) 若有my.ini文件 进去之后,在三个地方增加配置 第一个 第二个 第三个 若没有my.ini文件,则添加一个,内容为: 注意!!! 记得重启mysql服务 …

    2022年8月21日
    46700
  • MySQL InnoDB调试死锁

    前提 1、在RR隔离级别下。2、查看间隙锁是否关闭区间锁(间隙锁,临键锁)是InnoDB特有施加在索引记录区间的锁,MySQL5.6可以手动关闭区间锁,它由innodb_locks_unsafe_for_binlog参数控制: show global variables like “innodb_locks%”; 3、show glo…

    2023年10月23日
    22300
  • MySQL 如何查找删除重复行?

    如何查找重复行 第一步是定义什么样的行才是重复行。多数情况下很简单:它们某一列具有相同的值。本文采用这一定义,或许你对“重复”的定义比这复杂,你需要对sql做些修改。本文要用到的数据样本: 前面两行在day字段具有相同的值,因此如何我将他们当做重复行,这里有一查询语句可以查找。查询语句使用GROUP BY子句把具有相同字段值的行归为一组,然后计算组的大小。 …

    2023年4月25日
    23000
  • 内存耗尽后Redis会发生什么

    前言 作为一台服务器来说,内存并不是无限的,所以总会存在内存耗尽的情况,那么当 Redis 服务器的内存耗尽后,如果继续执行请求命令,Redis 会如何处理呢? 内存回收 使用Redis 服务时,很多情况下某些键值对只会在特定的时间内有效,为了防止这种类型的数据一直占有内存,我们可以给键值对设置有效期。Redis 中可以通过 4 个独立的命令来给一个键设置过…

    2023年7月17日
    20200

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注

在线咨询: QQ交谈

邮件:712342017@qq.com

工作时间:周一至周五,8:30-17:30,节假日休息

关注微信