问题描述

使用PL/SQL Developer登录数据库时显示如下错误:
在这里插入图片描述

问题分析

经查阅资料,找到了问题排查方向,可能是archive log 日志已满。

问题排查步骤如下:

(1)用sys用户登录
$ sqlplus / as sysdba
(2)看看archiv log所在位置
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为空,可以用如下命令查看归档目录和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     269
Next log sequence to archive   269
Current log sequence           272

由查询结果得知,归档位置用的是默认值,放在flash_recovery_area下。

(4)可以用如下命令查询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 4560M
db_unrecoverable_scn_tracking        boolean     TRUE
recovery_parallelism                 integer     0

由查询结果得知:
db_recovery_file_dest目录为/oracle/app/fast_recovery_area ;
该目录大小限制为4560M,即4.5G 。

(5)查看该文件当前大小
$ cd /oracle/app/fast_recovery_area
$ du * -sh --time
9.8M    2022-03-28 22:46        study
4.5G    2022-03-28 14:00        STUDY
$ cd STUDY
$ ll
total 4
drwxr-x---. 32 oracle oinstall 4096 Mar 28 05:00 archivelog
drwxr-x---.  2 oracle oinstall    6 Feb 17 22:54 onlinelog
$ du * -sh --time
4.5G    2022-03-28 14:00        archivelog
0       2022-02-17 22:54        onlinelog

由查询结果可知,该文件已大小已达上限。验证了对问题产生原因的猜测。

处理方法

转移或清除对应的归档日志, 删除一些不用的日期目录的文件,注意保留最后几个文件。

注意:
在删除归档日志后,必须用RMAN维护控制文件,否则空间显示仍然不释放。

$ rman target /
检查一些无用的archivelog
RMAN> crosscheck archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=185 device type=DISK
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_01/o1_mf_1_86_k1w9qc4l_.arc RECID=1 STAMP=1098223211
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_01/o1_mf_1_87_k1w9qk4w_.arc RECID=2 STAMP=1098223217
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_88_k1wjrt67_.arc RECID=3 STAMP=1098230426
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_89_k1x9fc98_.arc RECID=4 STAMP=1098255659
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_90_k1xft89q_.arc RECID=5 STAMP=1098260168
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_91_k1y6nfd7_.arc RECID=6 STAMP=1098285581
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_92_k1yy35f8_.arc RECID=7 STAMP=1098309605
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_93_k1yy3cfj_.arc RECID=8 STAMP=1098309611
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_94_k1yy3qfp_.arc RECID=9 STAMP=1098309623
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_95_k1zprcgo_.arc RECID=10 STAMP=1098334859
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_96_k202b3hm_.arc RECID=11 STAMP=1098346691
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_97_k20sx2ml_.arc RECID=12 STAMP=1098370850
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_98_k21lhcn0_.arc RECID=13 STAMP=1098396011
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_99_k21lhnot_.arc RECID=14 STAMP=1098396020
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_100_k227mrq7_.arc RECID=15 STAMP=1098417656
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_101_k22pt0f0_.arc RECID=16 STAMP=1098433216
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_102_k233q6rw_.arc RECID=17 STAMP=1098446438
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_103_k23rsctq_.arc RECID=18 STAMP=1098468011
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_104_k246v8wo_.arc RECID=19 STAMP=1098482409
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_105_k246vkws_.arc RECID=20 STAMP=1098482417
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_106_k24vzz5d_.arc RECID=21 STAMP=1098504063
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_107_k252zh5v_.arc RECID=22 STAMP=1098511215
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_108_k25c9wp5_.arc RECID=23 STAMP=1098519740
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_109_k25k5w73_.arc RECID=24 STAMP=1098525756
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_110_k25r3b99_.arc RECID=25 STAMP=1098532842
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_111_k25z8qbb_.arc RECID=26 STAMP=1098540183
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_112_k26fc6cs_.arc RECID=27 STAMP=1098554598
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_113_k26vfydv_.arc RECID=28 STAMP=1098569022
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_114_k27mtwgg_.arc RECID=29 STAMP=1098594012
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_115_k27tw5hw_.arc RECID=30 STAMP=1098601221
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_116_k27zss7p_.arc RECID=31 STAMP=1098606265
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_117_k285oxk9_.arc RECID=32 STAMP=1098612285
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_118_k28dhjkw_.arc RECID=33 STAMP=1098619248
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_119_k28mrhlj_.arc RECID=34 STAMP=1098626703
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_120_k291v7ly_.arc RECID=35 STAMP=1098641127
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_121_k29hxso7_.arc RECID=36 STAMP=1098655545
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_122_k2b86zqf_.arc RECID=37 STAMP=1098680415
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_123_k2bn9oo2_.arc RECID=38 STAMP=1098692789
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_124_k2c4d9tj_.arc RECID=39 STAMP=1098709257
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_125_k2cwz1xh_.arc RECID=40 STAMP=1098734433
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_126_k2d3zdyc_.arc RECID=41 STAMP=1098741613
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_127_k2d3zoyq_.arc RECID=42 STAMP=1098741622
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_128_k2ds2j0v_.arc RECID=43 STAMP=1098763216
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_129_k2f8sl0c_.arc RECID=44 STAMP=1098779314
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_130_k2flhf2l_.arc RECID=45 STAMP=1098789229
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_131_k2gd083t_.arc RECID=46 STAMP=1098815368
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_132_k2grc75p_.arc RECID=47 STAMP=1098828007
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_133_k2grcj60_.arc RECID=48 STAMP=1098828016
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_134_k2hfgm91_.arc RECID=49 STAMP=1098849619
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_135_k2hvk5bb_.arc RECID=50 STAMP=1098864037
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_136_k2jmsjc9_.arc RECID=51 STAMP=1098888880
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_137_k2kc22fy_.arc RECID=52 STAMP=1098912706
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_138_k2kdqfgg_.arc RECID=53 STAMP=1098914413
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_139_k2kj9bgl_.arc RECID=54 STAMP=1098918058
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_140_k2l8w2kp_.arc RECID=55 STAMP=1098943234
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_141_k2lj1102_.arc RECID=56 STAMP=1098950561
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_142_k2m4zjmz_.arc RECID=57 STAMP=1098972016
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_143_k2mxn4oj_.arc RECID=58 STAMP=1098997252
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_144_k2n13boq_.arc RECID=59 STAMP=1099000810
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_145_k2n13moz_.arc RECID=60 STAMP=1099000819
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_146_k2np6wp8_.arc RECID=61 STAMP=1099022428
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_147_k2ogsnr3_.arc RECID=62 STAMP=1099047604
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_148_k2p7qks5_.arc RECID=63 STAMP=1099073137
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_149_k2pohfmf_.arc RECID=64 STAMP=1099087213
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_150_k2pot6d4_.arc RECID=65 STAMP=1099087558
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_151_k2pot6sh_.arc RECID=66 STAMP=1099087558
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_152_k2q7fktd_.arc RECID=67 STAMP=1099105585
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_153_k2qkm7y6_.arc RECID=68 STAMP=1099116008
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_154_k2qkmfyb_.arc RECID=69 STAMP=1099116014
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_155_k2r02h08_.arc RECID=70 STAMP=1099130831
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_156_k2rg4y17_.arc RECID=71 STAMP=1099145246
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_157_k2rw7s2p_.arc RECID=72 STAMP=1099159673
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_158_k2sbb3mo_.arc RECID=73 STAMP=1099174083
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_159_k2sbbc3l_.arc RECID=74 STAMP=1099174091
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_160_k2sbbn3o_.arc RECID=75 STAMP=1099174100
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_161_k2t2hw61_.arc RECID=76 STAMP=1099198844
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_162_k2t5zg6m_.arc RECID=77 STAMP=1099202414
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_163_k2tnl783_.arc RECID=78 STAMP=1099217351
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_164_k2v2o28z_.arc RECID=79 STAMP=1099231778
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_165_k2vjqnbf_.arc RECID=80 STAMP=1099246196
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_166_k2vy7ccy_.arc RECID=81 STAMP=1099260011
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_167_k2vyt3d0_.arc RECID=82 STAMP=1099260611
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_168_k2vythd0_.arc RECID=83 STAMP=1099260623
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_169_k2whtpfp_.arc RECID=84 STAMP=1099278038
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_170_k2x8fggq_.arc RECID=85 STAMP=1099303214
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_171_k2y12cj8_.arc RECID=86 STAMP=1099328459
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_172_k2ylm8kt_.arc RECID=87 STAMP=1099346408
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_173_k2ylmkl2_.arc RECID=88 STAMP=1099346417
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_174_k2ymb1lo_.arc RECID=89 STAMP=1099347137
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_175_k2zc85nr_.arc RECID=90 STAMP=1099371653
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_176_k303txoz_.arc RECID=91 STAMP=1099396829
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_177_k30wfrql_.arc RECID=92 STAMP=1099422008
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_178_k316zgr8_.arc RECID=93 STAMP=1099432814
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_179_k317swm0_.arc RECID=94 STAMP=1099433660
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_180_k31ddjrv_.arc RECID=95 STAMP=1099438352
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_181_k323z6t1_.arc RECID=96 STAMP=1099462502
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_182_k32wl1vt_.arc RECID=97 STAMP=1099487681
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_183_k33nbkwz_.arc RECID=98 STAMP=1099512017
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_184_k33vc8xf_.arc RECID=99 STAMP=1099519208
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_185_k33w9tvj_.arc RECID=100 STAMP=1099520186
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_186_k34dxly4_.arc RECID=101 STAMP=1099537203
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_187_k352bq15_.arc RECID=102 STAMP=1099559127
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_188_k35txh2m_.arc RECID=103 STAMP=1099584303
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_189_k36hqd3o_.arc RECID=104 STAMP=1099605612
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_190_k36hqo3o_.arc RECID=105 STAMP=1099605621
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_191_k36jss3t_.arc RECID=106 STAMP=1099606713
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_192_k378bw56_.arc RECID=107 STAMP=1099630812
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_193_k380zj5k_.arc RECID=108 STAMP=1099656048
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_194_k38sl861_.arc RECID=109 STAMP=1099681224
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_195_k394397m_.arc RECID=110 STAMP=1099692009
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_196_k3944b7s_.arc RECID=111 STAMP=1099692042
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_197_k39wq293_.arc RECID=112 STAMP=1099717218
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_198_k3b07h99_.arc RECID=113 STAMP=1099720815
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_199_k3b8jcwk_.arc RECID=114 STAMP=1099729292
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_200_k3bgbf9v_.arc RECID=115 STAMP=1099735245
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_201_k3bgdd9y_.arc RECID=116 STAMP=1099735308
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_202_k3brwdcb_.arc RECID=117 STAMP=1099746060
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_203_k3bwh7d0_.arc RECID=118 STAMP=1099749735
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_204_k3cbkpfk_.arc RECID=119 STAMP=1099764150
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_205_k3crncgr_.arc RECID=120 STAMP=1099778571
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_206_k3dk38j2_.arc RECID=121 STAMP=1099803624
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_207_k3dnmhj3_.arc RECID=122 STAMP=1099807215
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_208_k3dx0chl_.arc RECID=123 STAMP=1099815819
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_209_k3f2wbkt_.arc RECID=124 STAMP=1099821834
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_210_k3f2wmky_.arc RECID=125 STAMP=1099821843
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_211_k3fjz5lg_.arc RECID=126 STAMP=1099836261
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_212_k3fz1nm7_.arc RECID=127 STAMP=1099850676
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_213_k3gf4hm8_.arc RECID=128 STAMP=1099865103
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_214_k3h5hkn0_.arc RECID=129 STAMP=1099890033
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_215_k3hkjd19_.arc RECID=130 STAMP=1099902348
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_216_k3hycoon_.arc RECID=131 STAMP=1099915509
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_217_k3jm6bq3_.arc RECID=132 STAMP=1099936842
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_218_k3k176rx_.arc RECID=133 STAMP=1099951206
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_219_k3k17ds7_.arc RECID=134 STAMP=1099951212
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_220_k3k17p29_.arc RECID=135 STAMP=1099951222
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_221_k3kh9w3j_.arc RECID=136 STAMP=1099965628
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_222_k3kybg4n_.arc RECID=137 STAMP=1099981006
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_223_k3l60c58_.arc RECID=138 STAMP=1099988875
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_224_k3l7yf5m_.arc RECID=139 STAMP=1099990861
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_225_k3loz676_.arc RECID=140 STAMP=1100005222
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_226_k3m8jk99_.arc RECID=141 STAMP=1100024209
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_227_k3momj9k_.arc RECID=142 STAMP=1100037616
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_228_k3momp9r_.arc RECID=143 STAMP=1100037622
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_229_k3ms40bb_.arc RECID=144 STAMP=1100041216
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_230_k3nkrncs_.arc RECID=145 STAMP=1100066452
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_231_k3ntjb63_.arc RECID=146 STAMP=1100075402
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_232_k3o6tsd7_.arc RECID=147 STAMP=1100088025
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_233_k3org1f3_.arc RECID=148 STAMP=1100106049
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_234_k3owwnft_.arc RECID=149 STAMP=1100110612
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_235_k3p9z7gh_.arc RECID=150 STAMP=1100124007
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_236_k3p9zfgm_.arc RECID=151 STAMP=1100124013
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_237_k3p9zpo2_.arc RECID=152 STAMP=1100124022
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_238_k3pz3grg_.arc RECID=153 STAMP=1100145646
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_239_k3qf7xdj_.arc RECID=154 STAMP=1100160125
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_240_k3qv6wvh_.arc RECID=155 STAMP=1100174428
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_241_k3rmsqws_.arc RECID=156 STAMP=1100199607
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_242_k3rycfyo_.arc RECID=157 STAMP=1100210414
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_243_k3rycpz2_.arc RECID=158 STAMP=1100210423
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_244_k3rycx03_.arc RECID=159 STAMP=1100210429
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_245_k3sq0g2r_.arc RECID=160 STAMP=1100235662
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_246_k3t1qxn0_.arc RECID=161 STAMP=1100246653
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_247_k3tm3w4n_.arc RECID=162 STAMP=1100264444
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_248_k3vcpn6l_.arc RECID=163 STAMP=1100289620
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_249_k3vlq874_.arc RECID=164 STAMP=1100296808
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_250_k3vlqk75_.arc RECID=165 STAMP=1100296817
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_251_k3w0to8z_.arc RECID=166 STAMP=1100311253
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_252_k3wgvg9n_.arc RECID=167 STAMP=1100325614
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_253_k3wp7xl1_.arc RECID=168 STAMP=1100333181
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_254_k3wx9gd2_.arc RECID=169 STAMP=1100340398
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_255_k3wx9qd3_.arc RECID=170 STAMP=1100340407
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_256_k3xcd9dr_.arc RECID=171 STAMP=1100354825
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_257_k3xsgvgl_.arc RECID=172 STAMP=1100369243
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_258_k3y7kmhn_.arc RECID=173 STAMP=1100383667
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_259_k3yrook0_.arc RECID=174 STAMP=1100401205
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_260_k3z378l8_.arc RECID=175 STAMP=1100412008
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_261_k3zbqxlv_.arc RECID=176 STAMP=1100419709
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_262_k3zbr0m0_.arc RECID=177 STAMP=1100419712
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_263_k3zksom1_.arc RECID=178 STAMP=1100426933
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_264_k3zrcoms_.arc RECID=179 STAMP=1100433653
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_265_k3zzw7nc_.arc RECID=180 STAMP=1100441351
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_266_k40fyznn_.arc RECID=181 STAMP=1100455775
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_267_k40w1kp8_.arc RECID=182 STAMP=1100470193
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_28/o1_mf_1_268_k41n3brs_.arc RECID=183 STAMP=1100494826
validation succeeded for archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_28/o1_mf_1_270_k42mqh7b_.arc RECID=184 STAMP=1100527215
Crosschecked 184 objects
删除归档日志

先尝试删除过期的归档日志:

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=185 device type=DISK
specification does not match any archived log in the repository

发现没有过期归档可以删。

因为这是测试机,所以我把一天前的归档日志删除掉:

正式环境请谨慎操作!!!

RMAN> delete noprompt archivelog until time  'sysdate-1';

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 STUDY
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
1       1    86      A 01-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_01/o1_mf_1_86_k1w9qc4l_.arc

2       1    87      A 01-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_01/o1_mf_1_87_k1w9qk4w_.arc

3       1    88      A 01-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_88_k1wjrt67_.arc

4       1    89      A 02-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_89_k1x9fc98_.arc

5       1    90      A 02-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_90_k1xft89q_.arc

6       1    91      A 02-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_91_k1y6nfd7_.arc

7       1    92      A 02-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_92_k1yy35f8_.arc

8       1    93      A 02-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_93_k1yy3cfj_.arc

9       1    94      A 02-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_94_k1yy3qfp_.arc

10      1    95      A 02-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_95_k1zprcgo_.arc

11      1    96      A 03-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_96_k202b3hm_.arc

12      1    97      A 03-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_97_k20sx2ml_.arc

13      1    98      A 03-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_98_k21lhcn0_.arc

14      1    99      A 03-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_99_k21lhnot_.arc

15      1    100     A 03-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_100_k227mrq7_.arc

16      1    101     A 04-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_101_k22pt0f0_.arc

17      1    102     A 04-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_102_k233q6rw_.arc

18      1    103     A 04-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_103_k23rsctq_.arc

19      1    104     A 04-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_104_k246v8wo_.arc

20      1    105     A 04-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_105_k246vkws_.arc

21      1    106     A 04-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_106_k24vzz5d_.arc

22      1    107     A 05-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_107_k252zh5v_.arc

23      1    108     A 05-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_108_k25c9wp5_.arc

24      1    109     A 05-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_109_k25k5w73_.arc

25      1    110     A 05-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_110_k25r3b99_.arc

26      1    111     A 05-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_111_k25z8qbb_.arc

27      1    112     A 05-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_112_k26fc6cs_.arc

28      1    113     A 05-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_113_k26vfydv_.arc

29      1    114     A 05-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_114_k27mtwgg_.arc

30      1    115     A 06-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_115_k27tw5hw_.arc

31      1    116     A 06-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_116_k27zss7p_.arc

32      1    117     A 06-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_117_k285oxk9_.arc

33      1    118     A 06-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_118_k28dhjkw_.arc

34      1    119     A 06-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_119_k28mrhlj_.arc

35      1    120     A 06-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_120_k291v7ly_.arc

36      1    121     A 06-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_121_k29hxso7_.arc

37      1    122     A 06-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_122_k2b86zqf_.arc

38      1    123     A 07-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_123_k2bn9oo2_.arc

39      1    124     A 07-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_124_k2c4d9tj_.arc

40      1    125     A 07-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_125_k2cwz1xh_.arc

41      1    126     A 07-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_126_k2d3zdyc_.arc

42      1    127     A 07-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_127_k2d3zoyq_.arc

43      1    128     A 07-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_128_k2ds2j0v_.arc

44      1    129     A 08-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_129_k2f8sl0c_.arc

45      1    130     A 08-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_130_k2flhf2l_.arc

46      1    131     A 08-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_131_k2gd083t_.arc

47      1    132     A 08-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_132_k2grc75p_.arc

48      1    133     A 08-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_133_k2grcj60_.arc

49      1    134     A 08-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_134_k2hfgm91_.arc

50      1    135     A 09-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_135_k2hvk5bb_.arc

51      1    136     A 09-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_136_k2jmsjc9_.arc

52      1    137     A 09-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_137_k2kc22fy_.arc

53      1    138     A 09-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_138_k2kdqfgg_.arc

54      1    139     A 09-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_139_k2kj9bgl_.arc

55      1    140     A 09-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_140_k2l8w2kp_.arc

56      1    141     A 10-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_141_k2lj1102_.arc

57      1    142     A 10-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_142_k2m4zjmz_.arc

58      1    143     A 10-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_143_k2mxn4oj_.arc

59      1    144     A 10-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_144_k2n13boq_.arc

60      1    145     A 10-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_145_k2n13moz_.arc

61      1    146     A 10-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_146_k2np6wp8_.arc

62      1    147     A 11-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_147_k2ogsnr3_.arc

63      1    148     A 11-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_148_k2p7qks5_.arc

64      1    149     A 11-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_149_k2pohfmf_.arc

65      1    150     A 11-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_150_k2pot6d4_.arc

66      1    151     A 11-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_151_k2pot6sh_.arc

67      1    152     A 11-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_152_k2q7fktd_.arc

68      1    153     A 12-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_153_k2qkm7y6_.arc

69      1    154     A 12-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_154_k2qkmfyb_.arc

70      1    155     A 12-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_155_k2r02h08_.arc

71      1    156     A 12-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_156_k2rg4y17_.arc

72      1    157     A 12-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_157_k2rw7s2p_.arc

73      1    158     A 12-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_158_k2sbb3mo_.arc

74      1    159     A 12-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_159_k2sbbc3l_.arc

75      1    160     A 12-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_160_k2sbbn3o_.arc

76      1    161     A 12-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_161_k2t2hw61_.arc

77      1    162     A 13-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_162_k2t5zg6m_.arc

78      1    163     A 13-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_163_k2tnl783_.arc

79      1    164     A 13-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_164_k2v2o28z_.arc

80      1    165     A 13-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_165_k2vjqnbf_.arc

81      1    166     A 13-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_166_k2vy7ccy_.arc

82      1    167     A 13-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_167_k2vyt3d0_.arc

83      1    168     A 13-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_168_k2vythd0_.arc

84      1    169     A 13-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_169_k2whtpfp_.arc

85      1    170     A 14-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_170_k2x8fggq_.arc

86      1    171     A 14-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_171_k2y12cj8_.arc

87      1    172     A 14-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_172_k2ylm8kt_.arc

88      1    173     A 14-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_173_k2ylmkl2_.arc

89      1    174     A 14-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_174_k2ymb1lo_.arc

90      1    175     A 14-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_175_k2zc85nr_.arc

91      1    176     A 15-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_176_k303txoz_.arc

92      1    177     A 15-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_177_k30wfrql_.arc

93      1    178     A 15-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_178_k316zgr8_.arc

94      1    179     A 15-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_179_k317swm0_.arc

95      1    180     A 15-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_180_k31ddjrv_.arc

96      1    181     A 15-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_181_k323z6t1_.arc

97      1    182     A 16-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_182_k32wl1vt_.arc

98      1    183     A 16-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_183_k33nbkwz_.arc

99      1    184     A 16-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_184_k33vc8xf_.arc

100     1    185     A 16-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_185_k33w9tvj_.arc

101     1    186     A 16-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_186_k34dxly4_.arc

102     1    187     A 17-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_187_k352bq15_.arc

103     1    188     A 17-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_188_k35txh2m_.arc

104     1    189     A 17-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_189_k36hqd3o_.arc

105     1    190     A 17-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_190_k36hqo3o_.arc

106     1    191     A 17-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_191_k36jss3t_.arc

107     1    192     A 17-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_192_k378bw56_.arc

108     1    193     A 18-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_193_k380zj5k_.arc

109     1    194     A 18-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_194_k38sl861_.arc

110     1    195     A 18-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_195_k394397m_.arc

111     1    196     A 18-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_196_k3944b7s_.arc

112     1    197     A 18-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_197_k39wq293_.arc

113     1    198     A 19-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_198_k3b07h99_.arc

114     1    199     A 19-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_199_k3b8jcwk_.arc

115     1    200     A 19-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_200_k3bgbf9v_.arc

116     1    201     A 19-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_201_k3bgdd9y_.arc

117     1    202     A 19-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_202_k3brwdcb_.arc

118     1    203     A 19-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_203_k3bwh7d0_.arc

119     1    204     A 19-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_204_k3cbkpfk_.arc

120     1    205     A 19-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_205_k3crncgr_.arc

121     1    206     A 19-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_206_k3dk38j2_.arc

122     1    207     A 20-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_207_k3dnmhj3_.arc

123     1    208     A 20-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_208_k3dx0chl_.arc

124     1    209     A 20-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_209_k3f2wbkt_.arc

125     1    210     A 20-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_210_k3f2wmky_.arc

126     1    211     A 20-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_211_k3fjz5lg_.arc

127     1    212     A 20-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_212_k3fz1nm7_.arc

128     1    213     A 20-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_213_k3gf4hm8_.arc

129     1    214     A 20-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_214_k3h5hkn0_.arc

130     1    215     A 21-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_215_k3hkjd19_.arc

131     1    216     A 21-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_216_k3hycoon_.arc

132     1    217     A 21-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_217_k3jm6bq3_.arc

133     1    218     A 21-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_218_k3k176rx_.arc

134     1    219     A 21-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_219_k3k17ds7_.arc

135     1    220     A 21-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_220_k3k17p29_.arc

136     1    221     A 21-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_221_k3kh9w3j_.arc

137     1    222     A 22-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_222_k3kybg4n_.arc

138     1    223     A 22-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_223_k3l60c58_.arc

139     1    224     A 22-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_224_k3l7yf5m_.arc

140     1    225     A 22-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_225_k3loz676_.arc

141     1    226     A 22-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_226_k3m8jk99_.arc

142     1    227     A 22-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_227_k3momj9k_.arc

143     1    228     A 22-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_228_k3momp9r_.arc

144     1    229     A 22-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_229_k3ms40bb_.arc

145     1    230     A 22-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_230_k3nkrncs_.arc

146     1    231     A 23-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_231_k3ntjb63_.arc

147     1    232     A 23-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_232_k3o6tsd7_.arc

148     1    233     A 23-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_233_k3org1f3_.arc

149     1    234     A 23-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_234_k3owwnft_.arc

150     1    235     A 23-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_235_k3p9z7gh_.arc

151     1    236     A 23-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_236_k3p9zfgm_.arc

152     1    237     A 23-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_237_k3p9zpo2_.arc

153     1    238     A 23-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_238_k3pz3grg_.arc

154     1    239     A 24-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_239_k3qf7xdj_.arc

155     1    240     A 24-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_240_k3qv6wvh_.arc

156     1    241     A 24-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_241_k3rmsqws_.arc

157     1    242     A 24-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_242_k3rycfyo_.arc

158     1    243     A 24-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_243_k3rycpz2_.arc

159     1    244     A 24-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_244_k3rycx03_.arc

160     1    245     A 24-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_245_k3sq0g2r_.arc

161     1    246     A 25-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_246_k3t1qxn0_.arc

162     1    247     A 25-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_247_k3tm3w4n_.arc

163     1    248     A 25-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_248_k3vcpn6l_.arc

164     1    249     A 25-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_249_k3vlq874_.arc

165     1    250     A 25-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_250_k3vlqk75_.arc

166     1    251     A 25-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_251_k3w0to8z_.arc

167     1    252     A 26-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_252_k3wgvg9n_.arc

168     1    253     A 26-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_253_k3wp7xl1_.arc

169     1    254     A 26-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_254_k3wx9gd2_.arc

170     1    255     A 26-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_255_k3wx9qd3_.arc

171     1    256     A 26-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_256_k3xcd9dr_.arc

172     1    257     A 26-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_257_k3xsgvgl_.arc

173     1    258     A 26-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_258_k3y7kmhn_.arc

174     1    259     A 26-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_259_k3yrook0_.arc

175     1    260     A 27-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_260_k3z378l8_.arc

176     1    261     A 27-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_261_k3zbqxlv_.arc

177     1    262     A 27-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_262_k3zbr0m0_.arc

178     1    263     A 27-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_263_k3zksom1_.arc

179     1    264     A 27-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_264_k3zrcoms_.arc

180     1    265     A 27-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_265_k3zzw7nc_.arc

181     1    266     A 27-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_266_k40fyznn_.arc

182     1    267     A 27-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_267_k40w1kp8_.arc

183     1    268     A 27-MAR-22
        Name: /oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_28/o1_mf_1_268_k41n3brs_.arc

deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_01/o1_mf_1_86_k1w9qc4l_.arc RECID=1 STAMP=1098223211
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_01/o1_mf_1_87_k1w9qk4w_.arc RECID=2 STAMP=1098223217
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_88_k1wjrt67_.arc RECID=3 STAMP=1098230426
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_89_k1x9fc98_.arc RECID=4 STAMP=1098255659
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_90_k1xft89q_.arc RECID=5 STAMP=1098260168
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_91_k1y6nfd7_.arc RECID=6 STAMP=1098285581
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_92_k1yy35f8_.arc RECID=7 STAMP=1098309605
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_93_k1yy3cfj_.arc RECID=8 STAMP=1098309611
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_02/o1_mf_1_94_k1yy3qfp_.arc RECID=9 STAMP=1098309623
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_95_k1zprcgo_.arc RECID=10 STAMP=1098334859
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_96_k202b3hm_.arc RECID=11 STAMP=1098346691
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_97_k20sx2ml_.arc RECID=12 STAMP=1098370850
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_98_k21lhcn0_.arc RECID=13 STAMP=1098396011
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_03/o1_mf_1_99_k21lhnot_.arc RECID=14 STAMP=1098396020
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_100_k227mrq7_.arc RECID=15 STAMP=1098417656
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_101_k22pt0f0_.arc RECID=16 STAMP=1098433216
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_102_k233q6rw_.arc RECID=17 STAMP=1098446438
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_103_k23rsctq_.arc RECID=18 STAMP=1098468011
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_104_k246v8wo_.arc RECID=19 STAMP=1098482409
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_04/o1_mf_1_105_k246vkws_.arc RECID=20 STAMP=1098482417
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_106_k24vzz5d_.arc RECID=21 STAMP=1098504063
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_107_k252zh5v_.arc RECID=22 STAMP=1098511215
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_108_k25c9wp5_.arc RECID=23 STAMP=1098519740
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_109_k25k5w73_.arc RECID=24 STAMP=1098525756
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_110_k25r3b99_.arc RECID=25 STAMP=1098532842
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_111_k25z8qbb_.arc RECID=26 STAMP=1098540183
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_112_k26fc6cs_.arc RECID=27 STAMP=1098554598
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_05/o1_mf_1_113_k26vfydv_.arc RECID=28 STAMP=1098569022
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_114_k27mtwgg_.arc RECID=29 STAMP=1098594012
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_115_k27tw5hw_.arc RECID=30 STAMP=1098601221
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_116_k27zss7p_.arc RECID=31 STAMP=1098606265
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_117_k285oxk9_.arc RECID=32 STAMP=1098612285
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_118_k28dhjkw_.arc RECID=33 STAMP=1098619248
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_119_k28mrhlj_.arc RECID=34 STAMP=1098626703
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_120_k291v7ly_.arc RECID=35 STAMP=1098641127
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_06/o1_mf_1_121_k29hxso7_.arc RECID=36 STAMP=1098655545
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_122_k2b86zqf_.arc RECID=37 STAMP=1098680415
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_123_k2bn9oo2_.arc RECID=38 STAMP=1098692789
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_124_k2c4d9tj_.arc RECID=39 STAMP=1098709257
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_125_k2cwz1xh_.arc RECID=40 STAMP=1098734433
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_126_k2d3zdyc_.arc RECID=41 STAMP=1098741613
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_07/o1_mf_1_127_k2d3zoyq_.arc RECID=42 STAMP=1098741622
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_128_k2ds2j0v_.arc RECID=43 STAMP=1098763216
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_129_k2f8sl0c_.arc RECID=44 STAMP=1098779314
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_130_k2flhf2l_.arc RECID=45 STAMP=1098789229
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_131_k2gd083t_.arc RECID=46 STAMP=1098815368
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_132_k2grc75p_.arc RECID=47 STAMP=1098828007
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_08/o1_mf_1_133_k2grcj60_.arc RECID=48 STAMP=1098828016
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_134_k2hfgm91_.arc RECID=49 STAMP=1098849619
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_135_k2hvk5bb_.arc RECID=50 STAMP=1098864037
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_136_k2jmsjc9_.arc RECID=51 STAMP=1098888880
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_137_k2kc22fy_.arc RECID=52 STAMP=1098912706
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_138_k2kdqfgg_.arc RECID=53 STAMP=1098914413
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_09/o1_mf_1_139_k2kj9bgl_.arc RECID=54 STAMP=1098918058
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_140_k2l8w2kp_.arc RECID=55 STAMP=1098943234
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_141_k2lj1102_.arc RECID=56 STAMP=1098950561
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_142_k2m4zjmz_.arc RECID=57 STAMP=1098972016
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_143_k2mxn4oj_.arc RECID=58 STAMP=1098997252
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_144_k2n13boq_.arc RECID=59 STAMP=1099000810
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_10/o1_mf_1_145_k2n13moz_.arc RECID=60 STAMP=1099000819
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_146_k2np6wp8_.arc RECID=61 STAMP=1099022428
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_147_k2ogsnr3_.arc RECID=62 STAMP=1099047604
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_148_k2p7qks5_.arc RECID=63 STAMP=1099073137
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_149_k2pohfmf_.arc RECID=64 STAMP=1099087213
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_150_k2pot6d4_.arc RECID=65 STAMP=1099087558
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_11/o1_mf_1_151_k2pot6sh_.arc RECID=66 STAMP=1099087558
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_152_k2q7fktd_.arc RECID=67 STAMP=1099105585
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_153_k2qkm7y6_.arc RECID=68 STAMP=1099116008
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_154_k2qkmfyb_.arc RECID=69 STAMP=1099116014
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_155_k2r02h08_.arc RECID=70 STAMP=1099130831
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_156_k2rg4y17_.arc RECID=71 STAMP=1099145246
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_157_k2rw7s2p_.arc RECID=72 STAMP=1099159673
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_158_k2sbb3mo_.arc RECID=73 STAMP=1099174083
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_159_k2sbbc3l_.arc RECID=74 STAMP=1099174091
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_12/o1_mf_1_160_k2sbbn3o_.arc RECID=75 STAMP=1099174100
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_161_k2t2hw61_.arc RECID=76 STAMP=1099198844
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_162_k2t5zg6m_.arc RECID=77 STAMP=1099202414
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_163_k2tnl783_.arc RECID=78 STAMP=1099217351
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_164_k2v2o28z_.arc RECID=79 STAMP=1099231778
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_165_k2vjqnbf_.arc RECID=80 STAMP=1099246196
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_166_k2vy7ccy_.arc RECID=81 STAMP=1099260011
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_167_k2vyt3d0_.arc RECID=82 STAMP=1099260611
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_13/o1_mf_1_168_k2vythd0_.arc RECID=83 STAMP=1099260623
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_169_k2whtpfp_.arc RECID=84 STAMP=1099278038
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_170_k2x8fggq_.arc RECID=85 STAMP=1099303214
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_171_k2y12cj8_.arc RECID=86 STAMP=1099328459
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_172_k2ylm8kt_.arc RECID=87 STAMP=1099346408
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_173_k2ylmkl2_.arc RECID=88 STAMP=1099346417
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_14/o1_mf_1_174_k2ymb1lo_.arc RECID=89 STAMP=1099347137
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_175_k2zc85nr_.arc RECID=90 STAMP=1099371653
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_176_k303txoz_.arc RECID=91 STAMP=1099396829
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_177_k30wfrql_.arc RECID=92 STAMP=1099422008
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_178_k316zgr8_.arc RECID=93 STAMP=1099432814
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_179_k317swm0_.arc RECID=94 STAMP=1099433660
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_15/o1_mf_1_180_k31ddjrv_.arc RECID=95 STAMP=1099438352
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_181_k323z6t1_.arc RECID=96 STAMP=1099462502
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_182_k32wl1vt_.arc RECID=97 STAMP=1099487681
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_183_k33nbkwz_.arc RECID=98 STAMP=1099512017
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_184_k33vc8xf_.arc RECID=99 STAMP=1099519208
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_16/o1_mf_1_185_k33w9tvj_.arc RECID=100 STAMP=1099520186
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_186_k34dxly4_.arc RECID=101 STAMP=1099537203
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_187_k352bq15_.arc RECID=102 STAMP=1099559127
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_188_k35txh2m_.arc RECID=103 STAMP=1099584303
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_189_k36hqd3o_.arc RECID=104 STAMP=1099605612
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_190_k36hqo3o_.arc RECID=105 STAMP=1099605621
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_17/o1_mf_1_191_k36jss3t_.arc RECID=106 STAMP=1099606713
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_192_k378bw56_.arc RECID=107 STAMP=1099630812
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_193_k380zj5k_.arc RECID=108 STAMP=1099656048
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_194_k38sl861_.arc RECID=109 STAMP=1099681224
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_195_k394397m_.arc RECID=110 STAMP=1099692009
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_18/o1_mf_1_196_k3944b7s_.arc RECID=111 STAMP=1099692042
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_197_k39wq293_.arc RECID=112 STAMP=1099717218
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_198_k3b07h99_.arc RECID=113 STAMP=1099720815
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_199_k3b8jcwk_.arc RECID=114 STAMP=1099729292
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_200_k3bgbf9v_.arc RECID=115 STAMP=1099735245
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_201_k3bgdd9y_.arc RECID=116 STAMP=1099735308
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_202_k3brwdcb_.arc RECID=117 STAMP=1099746060
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_203_k3bwh7d0_.arc RECID=118 STAMP=1099749735
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_204_k3cbkpfk_.arc RECID=119 STAMP=1099764150
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_19/o1_mf_1_205_k3crncgr_.arc RECID=120 STAMP=1099778571
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_206_k3dk38j2_.arc RECID=121 STAMP=1099803624
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_207_k3dnmhj3_.arc RECID=122 STAMP=1099807215
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_208_k3dx0chl_.arc RECID=123 STAMP=1099815819
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_209_k3f2wbkt_.arc RECID=124 STAMP=1099821834
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_210_k3f2wmky_.arc RECID=125 STAMP=1099821843
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_211_k3fjz5lg_.arc RECID=126 STAMP=1099836261
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_212_k3fz1nm7_.arc RECID=127 STAMP=1099850676
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_20/o1_mf_1_213_k3gf4hm8_.arc RECID=128 STAMP=1099865103
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_214_k3h5hkn0_.arc RECID=129 STAMP=1099890033
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_215_k3hkjd19_.arc RECID=130 STAMP=1099902348
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_216_k3hycoon_.arc RECID=131 STAMP=1099915509
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_217_k3jm6bq3_.arc RECID=132 STAMP=1099936842
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_218_k3k176rx_.arc RECID=133 STAMP=1099951206
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_219_k3k17ds7_.arc RECID=134 STAMP=1099951212
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_21/o1_mf_1_220_k3k17p29_.arc RECID=135 STAMP=1099951222
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_221_k3kh9w3j_.arc RECID=136 STAMP=1099965628
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_222_k3kybg4n_.arc RECID=137 STAMP=1099981006
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_223_k3l60c58_.arc RECID=138 STAMP=1099988875
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_224_k3l7yf5m_.arc RECID=139 STAMP=1099990861
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_225_k3loz676_.arc RECID=140 STAMP=1100005222
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_226_k3m8jk99_.arc RECID=141 STAMP=1100024209
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_227_k3momj9k_.arc RECID=142 STAMP=1100037616
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_228_k3momp9r_.arc RECID=143 STAMP=1100037622
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_22/o1_mf_1_229_k3ms40bb_.arc RECID=144 STAMP=1100041216
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_230_k3nkrncs_.arc RECID=145 STAMP=1100066452
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_231_k3ntjb63_.arc RECID=146 STAMP=1100075402
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_232_k3o6tsd7_.arc RECID=147 STAMP=1100088025
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_233_k3org1f3_.arc RECID=148 STAMP=1100106049
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_234_k3owwnft_.arc RECID=149 STAMP=1100110612
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_235_k3p9z7gh_.arc RECID=150 STAMP=1100124007
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_236_k3p9zfgm_.arc RECID=151 STAMP=1100124013
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_23/o1_mf_1_237_k3p9zpo2_.arc RECID=152 STAMP=1100124022
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_238_k3pz3grg_.arc RECID=153 STAMP=1100145646
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_239_k3qf7xdj_.arc RECID=154 STAMP=1100160125
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_240_k3qv6wvh_.arc RECID=155 STAMP=1100174428
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_241_k3rmsqws_.arc RECID=156 STAMP=1100199607
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_242_k3rycfyo_.arc RECID=157 STAMP=1100210414
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_243_k3rycpz2_.arc RECID=158 STAMP=1100210423
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_24/o1_mf_1_244_k3rycx03_.arc RECID=159 STAMP=1100210429
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_245_k3sq0g2r_.arc RECID=160 STAMP=1100235662
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_246_k3t1qxn0_.arc RECID=161 STAMP=1100246653
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_247_k3tm3w4n_.arc RECID=162 STAMP=1100264444
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_248_k3vcpn6l_.arc RECID=163 STAMP=1100289620
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_249_k3vlq874_.arc RECID=164 STAMP=1100296808
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_25/o1_mf_1_250_k3vlqk75_.arc RECID=165 STAMP=1100296817
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_251_k3w0to8z_.arc RECID=166 STAMP=1100311253
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_252_k3wgvg9n_.arc RECID=167 STAMP=1100325614
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_253_k3wp7xl1_.arc RECID=168 STAMP=1100333181
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_254_k3wx9gd2_.arc RECID=169 STAMP=1100340398
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_255_k3wx9qd3_.arc RECID=170 STAMP=1100340407
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_256_k3xcd9dr_.arc RECID=171 STAMP=1100354825
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_257_k3xsgvgl_.arc RECID=172 STAMP=1100369243
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_26/o1_mf_1_258_k3y7kmhn_.arc RECID=173 STAMP=1100383667
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_259_k3yrook0_.arc RECID=174 STAMP=1100401205
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_260_k3z378l8_.arc RECID=175 STAMP=1100412008
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_261_k3zbqxlv_.arc RECID=176 STAMP=1100419709
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_262_k3zbr0m0_.arc RECID=177 STAMP=1100419712
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_263_k3zksom1_.arc RECID=178 STAMP=1100426933
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_264_k3zrcoms_.arc RECID=179 STAMP=1100433653
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_265_k3zzw7nc_.arc RECID=180 STAMP=1100441351
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_266_k40fyznn_.arc RECID=181 STAMP=1100455775
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_27/o1_mf_1_267_k40w1kp8_.arc RECID=182 STAMP=1100470193
deleted archived log
archived log file name=/oracle/app/fast_recovery_area/STUDY/archivelog/2022_03_28/o1_mf_1_268_k41n3brs_.arc RECID=183 STAMP=1100494826
Deleted 183 objects
RMAN> exit;
Recovery Manager complete.
$ du * -sh
163M    archivelog
0       onlinelog

效果验证

再次登录数据库,可成功登录。


补充知识

检查flash recovery area的使用情况命令:

SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;

FILE_TYPE               PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES     CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE                             0                         0               0          0
REDO LOG                                 0                         0               0          0
ARCHIVED LOG                         99.68                         0             184          0
BACKUP PIECE                             0                         0               0          0
IMAGE COPY                               0                         0               0          0
FLASHBACK LOG                            0                         0               0          0
FOREIGN ARCHIVED LOG                     0                         0               0          0
AUXILIARY DATAFILE COPY                  0                         0               0          0

8 rows selected.

由查询结果,可以看出archivelog已经很大了,已达到99.68的使用率。

计算flash recovery area已占用空间命令:

SQL>  select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;

SUM(PERCENT_SPACE_USED)*3/100
-----------------------------
                       2.9904
Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐