ORA-00257 归档程序错误，在释放之前仅限于内部连接_归档程序错误,在释放之前仅限于内部连接

通过网上查找原因大部分是说归档日志空间已满，查看归档日志情况

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE      PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
CONTROL FILE       .41    0
       1

REDO LOG      4.63    0
       4

ARCHIVED LOG     94.15    0
     106

FILE_TYPE      PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
BACKUP PIECE         0    0
       0

IMAGE COPY         0    0
       0

FLASHBACK LOG         0    0
       0

FILE_TYPE      PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
FOREIGN ARCHIVED LOG        0    0
       0

 7 rows selected.

SQL> select * from v$recovery_file_dest;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
+DATA
 4621074432 4585422848         0      111

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE      PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
CONTROL FILE       .41    0
       1

REDO LOG      4.63    0
       4

ARCHIVED LOG     94.15    0
     106

FILE_TYPE      PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
BACKUP PIECE         0    0
       0

IMAGE COPY         0    0
       0

FLASHBACK LOG         0    0
       0

FILE_TYPE      PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
FOREIGN ARCHIVED LOG        0    0
       0

7 rows selected.

日志空间已满  归档日志站94.15

 

2） 列出所有归档日志

crosscheck archivelog all;

 

155     2    53      A 2015-06-09 18:54:41
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_53.473.881964017

156     2    54      A 2015-06-09 22:00:11
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_54.470.881964143

158     2    55      A 2015-06-09 22:02:22
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_55.469.881970519

159     2    56      A 2015-06-09 23:48:37
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_56.436.881979229

160     2    57      A 2015-06-10 02:13:48
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_57.466.881990773

162     2    58      A 2015-06-10 05:26:12
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_58.463.882004183

164     2    59      A 2015-06-10 09:09:42
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_59.462.882016125

共164个

删除归档日志

RMAN> delete archivelog all completed before 'sysdate-7';

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=79 instance=orcl1 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time          
------- ---- ------- - -------------------
93      1    10      A 2015-06-04 22:01:53
        Name: +DATA/orcl/archivelog/2015_06_05/thread_1_seq_10.445.881557979

99      1    12      A 2015-06-05 12:15:27
        Name: +DATA/orcl/archivelog/2015_06_05/thread_1_seq_12.439.881610851

124     2    32      A 2015-06-07 06:28:49
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_32.488.881746487

125     2    33      A 2015-06-07 09:34:46
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_33.489.881752131

127     2    34      A 2015-06-07 11:08:50
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_34.491.881762529

128     2    35      A 2015-06-07 14:02:08
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_35.492.881770573

130     2    36      A 2015-06-07 16:16:13
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_36.494.881778531

131     2    37      A 2015-06-07 18:28:49
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_37.495.881790887

132     2    38      A 2015-06-07 21:54:45
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_38.496.881794169

134     2    39      A 2015-06-07 22:49:27
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_39.498.881803579

135     2    40      A 2015-06-08 01:26:17
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_40.499.881812841

137     2    41      A 2015-06-08 04:00:39
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_41.501.881826231

138     2    42      A 2015-06-08 07:43:50
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_42.502.881838031

140     2    43      A 2015-06-08 11:00:30
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_43.504.881849629

141     2    44      A 2015-06-08 14:13:49
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_44.505.881861181

142     2    45      A 2015-06-08 17:26:19
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_45.506.881872491

145     2    46      A 2015-06-08 20:34:49
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_46.509.881884831

146     2    47      A 2015-06-09 00:00:30
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_47.510.881894127

148     2    48      A 2015-06-09 02:35:25
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_48.512.881904233

149     2    49      A 2015-06-09 05:23:52
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_49.513.881917255

151     2    50      A 2015-06-09 09:00:55
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_50.515.881928831

152     2    51      A 2015-06-09 12:13:51
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_51.476.881940471

154     2    52      A 2015-06-09 15:27:48
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_52.474.881952883

155     2    53      A 2015-06-09 18:54:41
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_53.473.881964017

156     2    54      A 2015-06-09 22:00:11
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_54.470.881964143

158     2    55      A 2015-06-09 22:02:22
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_55.469.881970519

159     2    56      A 2015-06-09 23:48:37
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_56.436.881979229

160     2    57      A 2015-06-10 02:13:48
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_57.466.881990773

162     2    58      A 2015-06-10 05:26:12
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_58.463.882004183

164     2    59      A 2015-06-10 09:09:42
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_59.462.882016125

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_32.488.881746487 RECID=124 STAMP=881746494
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_33.489.881752131 RECID=125 STAMP=881752142
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_34.491.881762529 RECID=127 STAMP=881762537
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_35.492.881770573 RECID=128 STAMP=881770581
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_36.494.881778531 RECID=130 STAMP=881778538
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_37.495.881790887 RECID=131 STAMP=881790894
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_38.496.881794169 RECID=132 STAMP=881794177
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_2_seq_39.498.881803579 RECID=134 STAMP=881803585
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_2_seq_40.499.881812841 RECID=135 STAMP=881812848
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_2_seq_41.501.881826231 RECID=137 STAMP=881826239
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_2_seq_42.502.881838031 RECID=138 STAMP=881838038
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_2_seq_43.504.881849629 RECID=140 STAMP=881849637
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_2_seq_44.505.881861181 RECID=141 STAMP=881861188
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_2_seq_45.506.881872491 RECID=142 STAMP=881872498
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_2_seq_46.509.881884831 RECID=145 STAMP=881884838
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_2_seq_47.510.881894127 RECID=146 STAMP=881894133
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_2_seq_48.512.881904233 RECID=148 STAMP=881904241
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_2_seq_49.513.881917255 RECID=149 STAMP=881917264
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_2_seq_50.515.881928831 RECID=151 STAMP=881928839
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_2_seq_51.476.881940471 RECID=152 STAMP=881940478
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_2_seq_52.474.881952883 RECID=154 STAMP=881952890
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_2_seq_53.473.881964017 RECID=155 STAMP=881964024
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_2_seq_54.470.881964143 RECID=156 STAMP=881964154
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_2_seq_55.469.881970519 RECID=158 STAMP=881970526
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_10/thread_2_seq_56.436.881979229 RECID=159 STAMP=881979237
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_10/thread_2_seq_57.466.881990773 RECID=160 STAMP=881990781
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_10/thread_2_seq_58.463.882004183 RECID=162 STAMP=882004191
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_10/thread_2_seq_59.462.882016125 RECID=164 STAMP=882016133
Deleted 28 objects

RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Archivelog      +DATA/orcl/archivelog/2015_06_05/thread_1_seq_10.445.881557979
RMAN-06214: Archivelog      +DATA/orcl/archivelog/2015_06_05/thread_1_seq_12.439.881610851

删除过期的归档日志将空间腾出来就可以了

重新登录数据库就OK了

3）我再删除过期归档日志的过程中遇到如下问题

RMAN> delete archivelog all completed before 'sysdate-7';

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=142 instance=orcl1 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time          
------- ---- ------- - -------------------
93      1    10      A 2015-06-04 22:01:53
        Name: +DATA/orcl/archivelog/2015_06_05/thread_1_seq_10.445.881557979

99      1    12      A 2015-06-05 12:15:27
        Name: +DATA/orcl/archivelog/2015_06_05/thread_1_seq_12.439.881610851

101     1    13      A 2015-06-05 19:54:09
        Name: +DATA/orcl/archivelog/2015_06_05/thread_1_seq_13.438.881618473

105     1    14      A 2015-06-05 22:01:11
        Name: +DATA/orcl/archivelog/2015_06_06/thread_1_seq_14.427.881626735

107     1    15      A 2015-06-06 00:18:51
        Name: +DATA/orcl/archivelog/2015_06_06/thread_1_seq_15.426.881647235

110     1    16      A 2015-06-06 06:00:34
        Name: +DATA/orcl/archivelog/2015_06_06/thread_1_seq_16.434.881661631

112     1    17      A 2015-06-06 10:00:30
        Name: +DATA/orcl/archivelog/2015_06_06/thread_1_seq_17.432.881676545

114     1    18      A 2015-06-06 14:09:04
        Name: +DATA/orcl/archivelog/2015_06_06/thread_1_seq_18.479.881690455

117     1    19      A 2015-06-06 18:00:54
        Name: +DATA/orcl/archivelog/2015_06_06/thread_1_seq_19.482.881705367

118     1    20      A 2015-06-06 22:09:25
        Name: +DATA/orcl/archivelog/2015_06_06/thread_1_seq_20.435.881705959

122     1    21      A 2015-06-06 22:19:16
        Name: +DATA/orcl/archivelog/2015_06_07/thread_1_seq_21.486.881733631

126     1    22      A 2015-06-07 06:00:27
        Name: +DATA/orcl/archivelog/2015_06_07/thread_1_seq_22.490.881752135

129     1    23      A 2015-06-07 11:08:52
        Name: +DATA/orcl/archivelog/2015_06_07/thread_1_seq_23.493.881773265

133     1    24      A 2015-06-07 17:01:05
        Name: +DATA/orcl/archivelog/2015_06_07/thread_1_seq_24.497.881794173

136     1    25      A 2015-06-07 22:49:29
        Name: +DATA/orcl/archivelog/2015_06_08/thread_1_seq_25.500.881823647

139     1    26      A 2015-06-08 07:00:46
        Name: +DATA/orcl/archivelog/2015_06_08/thread_1_seq_26.503.881848867

143     1    27      A 2015-06-08 14:01:06
        Name: +DATA/orcl/archivelog/2015_06_08/thread_1_seq_27.507.881872495

144     1    28      A 2015-06-08 20:34:51
        Name: +DATA/orcl/archivelog/2015_06_08/thread_1_seq_28.508.881877691

147     1    29      A 2015-06-08 22:01:31
        Name: +DATA/orcl/archivelog/2015_06_09/thread_1_seq_29.511.881897171

150     1    30      A 2015-06-09 03:26:09
        Name: +DATA/orcl/archivelog/2015_06_09/thread_1_seq_30.514.881921245

153     1    31      A 2015-06-09 10:07:25
        Name: +DATA/orcl/archivelog/2015_06_09/thread_1_seq_31.475.881946021

157     1    32      A 2015-06-09 17:00:19
        Name: +DATA/orcl/archivelog/2015_06_09/thread_1_seq_32.468.881964149

161     1    33      A 2015-06-09 22:02:25
        Name: +DATA/orcl/archivelog/2015_06_10/thread_1_seq_33.465.881990781

163     1    34      A 2015-06-10 05:26:14
        Name: +DATA/orcl/archivelog/2015_06_10/thread_1_seq_34.464.882010819

87      2    8       A 2015-06-04 16:01:52
        Name: +DATA/orcl/archivelog/2015_06_04/thread_2_seq_8.452.881519989

88      2    9       A 2015-06-04 18:39:48
        Name: +DATA/orcl/archivelog/2015_06_04/thread_2_seq_9.451.881532007

89      2    10      A 2015-06-04 22:00:06
        Name: +DATA/orcl/archivelog/2015_06_04/thread_2_seq_10.450.881532113

91      2    11      A 2015-06-04 22:01:51
        Name: +DATA/orcl/archivelog/2015_06_05/thread_2_seq_11.447.881539215

92      2    12      A 2015-06-05 00:00:13
        Name: +DATA/orcl/archivelog/2015_06_05/thread_2_seq_12.449.881550891

94      2    13      A 2015-06-05 03:14:50
        Name: +DATA/orcl/archivelog/2015_06_05/thread_2_seq_13.446.881563733

95      2    14      A 2015-06-05 06:48:51
        Name: +DATA/orcl/archivelog/2015_06_05/thread_2_seq_14.443.881577143

97      2    15      A 2015-06-05 10:32:23
        Name: +DATA/orcl/archivelog/2015_06_05/thread_2_seq_15.444.881590421

98      2    16      A 2015-06-05 14:13:41
        Name: +DATA/orcl/archivelog/2015_06_05/thread_2_seq_16.441.881601831

100     2    17      A 2015-06-05 17:23:50
        Name: +DATA/orcl/archivelog/2015_06_05/thread_2_seq_17.440.881612803

102     2    18      A 2015-06-05 20:26:41
        Name: +DATA/orcl/archivelog/2015_06_05/thread_2_seq_18.425.881619461

103     2    19      A 2015-06-05 22:17:39
        Name: +DATA/orcl/archivelog/2015_06_05/thread_2_seq_19.437.881619491

104     2    20      A 2015-06-05 22:18:08
        Name: +DATA/orcl/archivelog/2015_06_06/thread_2_seq_20.424.881626731

106     2    21      A 2015-06-06 00:18:50
        Name: +DATA/orcl/archivelog/2015_06_06/thread_2_seq_21.430.881637883

108     2    22      A 2015-06-06 03:24:42
        Name: +DATA/orcl/archivelog/2015_06_06/thread_2_seq_22.428.881648659

109     2    23      A 2015-06-06 06:24:18
        Name: +DATA/orcl/archivelog/2015_06_06/thread_2_seq_23.431.881660909

111     2    24      A 2015-06-06 09:48:28
        Name: +DATA/orcl/archivelog/2015_06_06/thread_2_seq_24.429.881671433

113     2    25      A 2015-06-06 12:43:52
        Name: +DATA/orcl/archivelog/2015_06_06/thread_2_seq_25.478.881681269

115     2    26      A 2015-06-06 15:27:49
        Name: +DATA/orcl/archivelog/2015_06_06/thread_2_seq_26.480.881691445

116     2    27      A 2015-06-06 18:17:24
        Name: +DATA/orcl/archivelog/2015_06_06/thread_2_seq_27.481.881702389

119     2    28      A 2015-06-06 21:19:48
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_28.483.881712289

120     2    29      A 2015-06-07 00:04:48
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_29.484.881722821

121     2    30      A 2015-06-07 03:00:21
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_30.485.881733625

123     2    31      A 2015-06-07 06:00:23
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_31.487.881735331

124     2    32      A 2015-06-07 06:28:49
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_32.488.881746487

125     2    33      A 2015-06-07 09:34:46
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_33.489.881752131

127     2    34      A 2015-06-07 11:08:50
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_34.491.881762529

128     2    35      A 2015-06-07 14:02:08
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_35.492.881770573

130     2    36      A 2015-06-07 16:16:13
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_36.494.881778531

131     2    37      A 2015-06-07 18:28:49
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_37.495.881790887

132     2    38      A 2015-06-07 21:54:45
        Name: +DATA/orcl/archivelog/2015_06_07/thread_2_seq_38.496.881794169

134     2    39      A 2015-06-07 22:49:27
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_39.498.881803579

135     2    40      A 2015-06-08 01:26:17
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_40.499.881812841

137     2    41      A 2015-06-08 04:00:39
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_41.501.881826231

138     2    42      A 2015-06-08 07:43:50
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_42.502.881838031

140     2    43      A 2015-06-08 11:00:30
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_43.504.881849629

141     2    44      A 2015-06-08 14:13:49
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_44.505.881861181

142     2    45      A 2015-06-08 17:26:19
        Name: +DATA/orcl/archivelog/2015_06_08/thread_2_seq_45.506.881872491

145     2    46      A 2015-06-08 20:34:49
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_46.509.881884831

146     2    47      A 2015-06-09 00:00:30
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_47.510.881894127

148     2    48      A 2015-06-09 02:35:25
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_48.512.881904233

149     2    49      A 2015-06-09 05:23:52
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_49.513.881917255

151     2    50      A 2015-06-09 09:00:55
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_50.515.881928831

152     2    51      A 2015-06-09 12:13:51
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_51.476.881940471

154     2    52      A 2015-06-09 15:27:48
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_52.474.881952883

155     2    53      A 2015-06-09 18:54:41
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_53.473.881964017

156     2    54      A 2015-06-09 22:00:11
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_54.470.881964143

158     2    55      A 2015-06-09 22:02:22
        Name: +DATA/orcl/archivelog/2015_06_09/thread_2_seq_55.469.881970519

159     2    56      A 2015-06-09 23:48:37
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_56.436.881979229

160     2    57      A 2015-06-10 02:13:48
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_57.466.881990773

162     2    58      A 2015-06-10 05:26:12
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_58.463.882004183

164     2    59      A 2015-06-10 09:09:42
        Name: +DATA/orcl/archivelog/2015_06_10/thread_2_seq_59.462.882016125

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_05/thread_1_seq_13.438.881618473 RECID=101 STAMP=881618480
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_1_seq_14.427.881626735 RECID=105 STAMP=881626743
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_1_seq_15.426.881647235 RECID=107 STAMP=881647242
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_1_seq_16.434.881661631 RECID=110 STAMP=881661639
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_1_seq_17.432.881676545 RECID=112 STAMP=881676553
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_1_seq_18.479.881690455 RECID=114 STAMP=881690463
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_1_seq_19.482.881705367 RECID=117 STAMP=881705374
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_1_seq_20.435.881705959 RECID=118 STAMP=881705969
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_1_seq_21.486.881733631 RECID=122 STAMP=881733642
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_1_seq_22.490.881752135 RECID=126 STAMP=881752143
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_1_seq_23.493.881773265 RECID=129 STAMP=881773273
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_1_seq_24.497.881794173 RECID=133 STAMP=881794181
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_1_seq_25.500.881823647 RECID=136 STAMP=881823655
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_1_seq_26.503.881848867 RECID=139 STAMP=881848875
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_1_seq_27.507.881872495 RECID=143 STAMP=881872505
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_08/thread_1_seq_28.508.881877691 RECID=144 STAMP=881877700
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_1_seq_29.511.881897171 RECID=147 STAMP=881897178
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_1_seq_30.514.881921245 RECID=150 STAMP=881921253
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_1_seq_31.475.881946021 RECID=153 STAMP=881946028
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_09/thread_1_seq_32.468.881964149 RECID=157 STAMP=881964158
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_10/thread_1_seq_33.465.881990781 RECID=161 STAMP=881990788
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_10/thread_1_seq_34.464.882010819 RECID=163 STAMP=882010828
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_04/thread_2_seq_8.452.881519989 RECID=87 STAMP=881519997
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_04/thread_2_seq_9.451.881532007 RECID=88 STAMP=881532015
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_04/thread_2_seq_10.450.881532113 RECID=89 STAMP=881532125
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_05/thread_2_seq_11.447.881539215 RECID=91 STAMP=881539222
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_05/thread_2_seq_12.449.881550891 RECID=92 STAMP=881550898
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_05/thread_2_seq_13.446.881563733 RECID=94 STAMP=881563740
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_05/thread_2_seq_14.443.881577143 RECID=95 STAMP=881577151
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_05/thread_2_seq_15.444.881590421 RECID=97 STAMP=881590429
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_05/thread_2_seq_16.441.881601831 RECID=98 STAMP=881601839
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_05/thread_2_seq_17.440.881612803 RECID=100 STAMP=881612809
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_05/thread_2_seq_18.425.881619461 RECID=102 STAMP=881619473
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_05/thread_2_seq_19.437.881619491 RECID=103 STAMP=881619501
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_2_seq_20.424.881626731 RECID=104 STAMP=881626742
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_2_seq_21.430.881637883 RECID=106 STAMP=881637890
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_2_seq_22.428.881648659 RECID=108 STAMP=881648666
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_2_seq_23.431.881660909 RECID=109 STAMP=881660917
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_2_seq_24.429.881671433 RECID=111 STAMP=881671440
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_2_seq_25.478.881681269 RECID=113 STAMP=881681277
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_2_seq_26.480.881691445 RECID=115 STAMP=881691453
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_06/thread_2_seq_27.481.881702389 RECID=116 STAMP=881702397
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_28.483.881712289 RECID=119 STAMP=881712297
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_29.484.881722821 RECID=120 STAMP=881722830
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_30.485.881733625 RECID=121 STAMP=881733636
deleted archived log
archived log file name=+DATA/orcl/archivelog/2015_06_07/thread_2_seq_31.487.881735331 RECID=123 STAMP=881735337
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 06/17/2015 14:45:34
ORA-01090: shutdown in progress - connection is not permitted

错误提示ORA-01090  ：shutdown in progress-connection is not permitted

根据提示就先将数据库关闭（两个节点数据库都关闭），

关闭后重启，重启后重新进行删除就OK了  归档日志可以正常删除，但是在

数据库关闭的过程中，关闭的时间很长才将数据库关闭掉，暂时不太清楚问题的原因是什么，先记下来，后面再慢慢查找