TSM備份時因歸檔日誌丟失而導致備份失敗
問題描述:
執行資料庫完全備份時,最後提示找不到名為'2_3107_636130048.dbf' 的歸檔日誌.
Recovery Manager: Release 10.2.0.3.0 - Production on Fri Jan 18 23:58:42 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect catalog *
2> connect target *
3> run {
4> allocate channel t1 type sbt;
5> allocate channel t2 type sbt;
6> send 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
7> backup incremental level 0
8> format 'qzpoais_full_%T_%t_%U'database;
9> sql 'alter system archive log current';
10> backup format 'qzpoais_arhc_%T_%t_%U' archivelog all delete all input;
11> release channel t1;
12> release channel t2;
13> }
14>
15>
16>
connected to recovery catalog database
connected to target database: QZPOAIS (DBID=1075906752)
starting full resync of recovery catalog
full resync complete
allocated channel: t1
channel t1: sid=1000 instance=qzpoais1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0
allocated channel: t2
channel t2: sid=1035 instance=qzpoais1 devtype=SBT_TAPE
channel t2: Data Protection for Oracle: version 5.4.1.0
sent command to channel: t1
sent command to channel: t2
Starting backup at 01/18/2008 23:58:57
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00216 name=+DATA/qzpoais/datafile/sm2100001.dbf
input datafile fno=00217 name=+DATA/qzpoais/datafile/sm2100002.dbf
input datafile fno=00220 name=+DATA/qzpoais/datafile/sm2100005.dbf
input datafile fno=00223 name=+DATA/qzpoais/datafile/sm2100008.dbf
input datafile fno=00226 name=+DATA/qzpoais/datafile/sm2100011.dbf
input datafile fno=00229 name=+DATA/qzpoais/datafile/sm2100014.dbf
input datafile fno=00232 name=+DATA/qzpoais/datafile/sm2100017.dbf
input datafile fno=00236 name=+DATA/qzpoais/datafile/sm2100021.dbf
input datafile fno=00240 name=+DATA/qzpoais/datafile/sm2100025.dbf
input datafile fno=00244 name=+DATA/qzpoais/datafile/sm2100029.dbf
input datafile fno=00009 name=+DATA/qzpoais/datafile/index_data001.dbf
input datafile fno=00185 name=+DATA/qzpoais/datafile/sjzh_data052.dbf
input datafile fno=00041 name=+DATA/qzpoais/datafile/index_data004.dbf
input datafile fno=00212 name=+DATA/qzpoais/datafile/sjzh_data079.dbf
input datafile fno=00013 name=+DATA/qzpoais/datafile/sjzh_data001.dbf
input datafile fno=00017 name=+DATA/qzpoais/datafile/rk_data003.dbf
input datafile fno=00021 name=+DATA/qzpoais/datafile/rk_data007.dbf
input datafile fno=00025 name=+DATA/qzpoais/datafile/rk_data011.dbf
input datafile fno=00029 name=+DATA/qzpoais/datafile/rk_data015.dbf
input datafile fno=00033 name=+DATA/qzpoais/datafile/rk_data019.dbf
input datafile fno=00037 name=+DATA/qzpoais/datafile/jcyw_data004.dbf
input datafile fno=00045 name=+DATA/qzpoais/datafile/zfba_data004.dbf
input datafile fno=00049 name=+DATA/qzpoais/datafile/sjzh_data004.dbf
input datafile fno=00053 name=+DATA/qzpoais/datafile/sjzh_data008.dbf
input datafile fno=00057 name=+DATA/qzpoais/datafile/sjzh_data012.dbf
input datafile fno=00061 name=+DATA/qzpoais/datafile/sjzh_data016.dbf
input datafile fno=00065 name=+DATA/qzpoais/datafile/sjzh_data020.dbf
input datafile fno=00069 name=+DATA/qzpoais/datafile/rk_photo005.dbf
input datafile fno=00073 name=+DATA/qzpoais/datafile/rk_photo009.dbf
input datafile fno=00077 name=+DATA/qzpoais/datafile/rk_photo013.dbf
input datafile fno=00081 name=+DATA/qzpoais/datafile/rk_photo017.dbf
input datafile fno=00085 name=+DATA/qzpoais/datafile/rk_photo021.dbf
input datafile fno=00089 name=+DATA/qzpoais/datafile/rk_photo025.dbf
input datafile fno=00093 name=+DATA/qzpoais/datafile/rk_photo029.dbf
input datafile fno=00097 name=+DATA/qzpoais/datafile/rk_photo033.dbf
input datafile fno=00101 name=+DATA/qzpoais/datafile/rk_photo037.dbf
input datafile fno=00105 name=+DATA/qzpoais/datafile/rk_photo041.dbf
input datafile fno=00109 name=+DATA/qzpoais/datafile/rk_photo045.dbf
input datafile fno=00113 name=+DATA/qzpoais/datafile/rk_photo049.dbf
input datafile fno=00117 name=+DATA/qzpoais/datafile/rk_photo053.dbf
input datafile fno=00121 name=+DATA/qzpoais/datafile/rk_photo057.dbf
input datafile fno=00125 name=+DATA/qzpoais/datafile/rk_photo061.dbf
input datafile fno=00129 name=+DATA/qzpoais/datafile/rk_photo065.dbf
input datafile fno=00133 name=+DATA/qzpoais/datafile/rk_photo069.dbf
input datafile fno=00137 name=+DATA/qzpoais/datafile/sjzh_data023.dbf
input datafile fno=00141 name=+DATA/qzpoais/datafile/sjzh_data027.dbf
input datafile fno=00146 name=+DATA/qzpoais/datafile/rk_data022.dbf
input datafile fno=00150 name=+DATA/qzpoais/datafile/rk_data026.dbf
input datafile fno=00154 name=+DATA/qzpoais/datafile/rk_data030.dbf
input datafile fno=00158 name=+DATA/qzpoais/datafile/rk_photo073.dbf
input datafile fno=00165 name=+DATA/qzpoais/datafile/sjzh_data032.dbf
input datafile fno=00169 name=+DATA/qzpoais/datafile/sjzh_data036.dbf
input datafile fno=00173 name=+DATA/qzpoais/datafile/sjzh_data040.dbf
input datafile fno=00177 name=+DATA/qzpoais/datafile/sjzh_data044.dbf
input datafile fno=00181 name=+DATA/qzpoais/datafile/sjzh_data048.dbf
input datafile fno=00187 name=+DATA/qzpoais/datafile/sjzh_data054.dbf
input datafile fno=00192 name=+DATA/qzpoais/datafile/sjzh_data059.dbf
input datafile fno=00198 name=+DATA/qzpoais/datafile/sjzh_data065.dbf
input datafile fno=00202 name=+DATA/qzpoais/datafile/sjzh_data069.dbf
input datafile fno=00206 name=+DATA/qzpoais/datafile/sjzh_data073.dbf
input datafile fno=00211 name=+DATA/qzpoais/datafile/sjzh_data078.dbf
input datafile fno=00214 name=+DATA/qzpoais/datafile/index_data006.dbf
input datafile fno=00005 name=+DATA/qzpoais/datafile/users.267.636130077
input datafile fno=00215 name=+DATA/qzpoais/datafile/index_data007.dbf
channel t1: starting piece 1 at 01/18/2008 23:59:00
channel t2: starting incremental level 0 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00002 name=+DATA/qzpoais/datafile/undotbs1.263.636130069
input datafile fno=00234 name=+DATA/qzpoais/datafile/sm2100019.dbf
input datafile fno=00238 name=+DATA/qzpoais/datafile/sm2100023.dbf
input datafile fno=00242 name=+DATA/qzpoais/datafile/sm2100027.dbf
input datafile fno=00246 name=+DATA/qzpoais/datafile/sm2100031.dbf
input datafile fno=00040 name=+DATA/qzpoais/datafile/index_data003.dbf
input datafile fno=00188 name=+DATA/qzpoais/datafile/sjzh_data055.dbf
input datafile fno=00208 name=+DATA/qzpoais/datafile/sjzh_data075.dbf
input datafile fno=00007 name=+DATA/qzpoais/datafile/rk_photo001.dbf
input datafile fno=00011 name=+DATA/qzpoais/datafile/pub_data001.dbf
input datafile fno=00015 name=+DATA/qzpoais/datafile/jcyw_data001.dbf
input datafile fno=00019 name=+DATA/qzpoais/datafile/rk_data005.dbf
input datafile fno=00023 name=+DATA/qzpoais/datafile/rk_data009.dbf
input datafile fno=00027 name=+DATA/qzpoais/datafile/rk_data013.dbf
input datafile fno=00031 name=+DATA/qzpoais/datafile/rk_data017.dbf
input datafile fno=00035 name=+DATA/qzpoais/datafile/jcyw_data002.dbf
input datafile fno=00043 name=+DATA/qzpoais/datafile/zfba_data002.dbf
input datafile fno=00047 name=+DATA/qzpoais/datafile/sjzh_data002.dbf
input datafile fno=00051 name=+DATA/qzpoais/datafile/sjzh_data006.dbf
input datafile fno=00055 name=+DATA/qzpoais/datafile/sjzh_data010.dbf
input datafile fno=00059 name=+DATA/qzpoais/datafile/sjzh_data014.dbf
input datafile fno=00063 name=+DATA/qzpoais/datafile/sjzh_data018.dbf
input datafile fno=00067 name=+DATA/qzpoais/datafile/rk_photo003.dbf
input datafile fno=00071 name=+DATA/qzpoais/datafile/rk_photo007.dbf
input datafile fno=00075 name=+DATA/qzpoais/datafile/rk_photo011.dbf
input datafile fno=00079 name=+DATA/qzpoais/datafile/rk_photo015.dbf
input datafile fno=00083 name=+DATA/qzpoais/datafile/rk_photo019.dbf
input datafile fno=00087 name=+DATA/qzpoais/datafile/rk_photo023.dbf
input datafile fno=00091 name=+DATA/qzpoais/datafile/rk_photo027.dbf
input datafile fno=00095 name=+DATA/qzpoais/datafile/rk_photo031.dbf
input datafile fno=00099 name=+DATA/qzpoais/datafile/rk_photo035.dbf
input datafile fno=00103 name=+DATA/qzpoais/datafile/rk_photo039.dbf
input datafile fno=00107 name=+DATA/qzpoais/datafile/rk_photo043.dbf
input datafile fno=00111 name=+DATA/qzpoais/datafile/rk_photo047.dbf
input datafile fno=00115 name=+DATA/qzpoais/datafile/rk_photo051.dbf
input datafile fno=00119 name=+DATA/qzpoais/datafile/rk_photo055.dbf
input datafile fno=00123 name=+DATA/qzpoais/datafile/rk_photo059.dbf
input datafile fno=00127 name=+DATA/qzpoais/datafile/rk_photo063.dbf
input datafile fno=00131 name=+DATA/qzpoais/datafile/rk_photo067.dbf
input datafile fno=00135 name=+DATA/qzpoais/datafile/sjzh_data021.dbf
input datafile fno=00139 name=+DATA/qzpoais/datafile/sjzh_data025.dbf
input datafile fno=00144 name=+DATA/qzpoais/datafile/sjzh_data030.dbf
input datafile fno=00148 name=+DATA/qzpoais/datafile/rk_data024.dbf
input datafile fno=00152 name=+DATA/qzpoais/datafile/rk_data028.dbf
input datafile fno=00156 name=+DATA/qzpoais/datafile/rk_photo071.dbf
input datafile fno=00160 name=+DATA/qzpoais/datafile/rk_photo075.dbf
input datafile fno=00167 name=+DATA/qzpoais/datafile/sjzh_data034.dbf
input datafile fno=00171 name=+DATA/qzpoais/datafile/sjzh_data038.dbf
input datafile fno=00175 name=+DATA/qzpoais/datafile/sjzh_data042.dbf
input datafile fno=00179 name=+DATA/qzpoais/datafile/sjzh_data046.dbf
input datafile fno=00183 name=+DATA/qzpoais/datafile/sjzh_data050.dbf
input datafile fno=00190 name=+DATA/qzpoais/datafile/sjzh_data057.dbf
input datafile fno=00194 name=+DATA/qzpoais/datafile/sjzh_data061.dbf
input datafile fno=00200 name=+DATA/qzpoais/datafile/sjzh_data067.dbf
input datafile fno=00204 name=+DATA/qzpoais/datafile/sjzh_data071.dbf
input datafile fno=00209 name=+DATA/qzpoais/datafile/sjzh_data076.dbf
input datafile fno=00162 name=+DATA/qzpoais/datafile/pub_data003.dbf
input datafile fno=00001 name=+DATA/qzpoais/datafile/system.262.636130061
channel t2: starting piece 1 at 01/18/2008 23:59:00
channel t1: finished piece 1 at 01/19/2008 06:38:47
piece handle=qzpoais_full_20080118_644371140_m9j6gkm4_1_1 tag=TAG20080118T235857 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 06:39:47
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00042 name=+DATA/qzpoais/datafile/index_data005.dbf
input datafile fno=00218 name=+DATA/qzpoais/datafile/sm2100003.dbf
input datafile fno=00221 name=+DATA/qzpoais/datafile/sm2100006.dbf
input datafile fno=00224 name=+DATA/qzpoais/datafile/sm2100009.dbf
input datafile fno=00227 name=+DATA/qzpoais/datafile/sm2100012.dbf
input datafile fno=00230 name=+DATA/qzpoais/datafile/sm2100015.dbf
input datafile fno=00233 name=+DATA/qzpoais/datafile/sm2100018.dbf
input datafile fno=00237 name=+DATA/qzpoais/datafile/sm2100022.dbf
input datafile fno=00241 name=+DATA/qzpoais/datafile/sm2100026.dbf
input datafile fno=00245 name=+DATA/qzpoais/datafile/sm2100030.dbf
input datafile fno=00039 name=+DATA/qzpoais/datafile/index_data002.dbf
input datafile fno=00186 name=+DATA/qzpoais/datafile/sjzh_data053.dbf
input datafile fno=00196 name=+DATA/qzpoais/datafile/sjzh_data063.dbf
input datafile fno=00006 name=+DATA/qzpoais/datafile/rk_data001.dbf
input datafile fno=00010 name=+DATA/qzpoais/datafile/zfba_data001.dbf
input datafile fno=00014 name=+DATA/qzpoais/datafile/qty_data001.dbf
input datafile fno=00018 name=+DATA/qzpoais/datafile/rk_data004.dbf
input datafile fno=00022 name=+DATA/qzpoais/datafile/rk_data008.dbf
input datafile fno=00026 name=+DATA/qzpoais/datafile/rk_data012.dbf
input datafile fno=00030 name=+DATA/qzpoais/datafile/rk_data016.dbf
input datafile fno=00034 name=+DATA/qzpoais/datafile/rk_data020.dbf
input datafile fno=00038 name=+DATA/qzpoais/datafile/jcyw_data005.dbf
input datafile fno=00046 name=+DATA/qzpoais/datafile/zfba_data005.dbf
input datafile fno=00050 name=+DATA/qzpoais/datafile/sjzh_data005.dbf
input datafile fno=00054 name=+DATA/qzpoais/datafile/sjzh_data009.dbf
input datafile fno=00058 name=+DATA/qzpoais/datafile/sjzh_data013.dbf
input datafile fno=00062 name=+DATA/qzpoais/datafile/sjzh_data017.dbf
input datafile fno=00066 name=+DATA/qzpoais/datafile/rk_photo002.dbf
input datafile fno=00070 name=+DATA/qzpoais/datafile/rk_photo006.dbf
input datafile fno=00074 name=+DATA/qzpoais/datafile/rk_photo010.dbf
input datafile fno=00078 name=+DATA/qzpoais/datafile/rk_photo014.dbf
input datafile fno=00082 name=+DATA/qzpoais/datafile/rk_photo018.dbf
input datafile fno=00086 name=+DATA/qzpoais/datafile/rk_photo022.dbf
input datafile fno=00090 name=+DATA/qzpoais/datafile/rk_photo026.dbf
input datafile fno=00094 name=+DATA/qzpoais/datafile/rk_photo030.dbf
input datafile fno=00098 name=+DATA/qzpoais/datafile/rk_photo034.dbf
input datafile fno=00102 name=+DATA/qzpoais/datafile/rk_photo038.dbf
input datafile fno=00106 name=+DATA/qzpoais/datafile/rk_photo042.dbf
input datafile fno=00110 name=+DATA/qzpoais/datafile/rk_photo046.dbf
input datafile fno=00114 name=+DATA/qzpoais/datafile/rk_photo050.dbf
input datafile fno=00118 name=+DATA/qzpoais/datafile/rk_photo054.dbf
input datafile fno=00122 name=+DATA/qzpoais/datafile/rk_photo058.dbf
input datafile fno=00126 name=+DATA/qzpoais/datafile/rk_photo062.dbf
input datafile fno=00130 name=+DATA/qzpoais/datafile/rk_photo066.dbf
input datafile fno=00134 name=+DATA/qzpoais/datafile/rk_photo070.dbf
input datafile fno=00138 name=+DATA/qzpoais/datafile/sjzh_data024.dbf
input datafile fno=00143 name=+DATA/qzpoais/datafile/sjzh_data029.dbf
input datafile fno=00147 name=+DATA/qzpoais/datafile/rk_data023.dbf
input datafile fno=00151 name=+DATA/qzpoais/datafile/rk_data027.dbf
input datafile fno=00155 name=+DATA/qzpoais/datafile/pub_data002.dbf
input datafile fno=00159 name=+DATA/qzpoais/datafile/rk_photo074.dbf
input datafile fno=00166 name=+DATA/qzpoais/datafile/sjzh_data033.dbf
input datafile fno=00170 name=+DATA/qzpoais/datafile/sjzh_data037.dbf
input datafile fno=00174 name=+DATA/qzpoais/datafile/sjzh_data041.dbf
input datafile fno=00178 name=+DATA/qzpoais/datafile/sjzh_data045.dbf
input datafile fno=00182 name=+DATA/qzpoais/datafile/sjzh_data049.dbf
input datafile fno=00189 name=+DATA/qzpoais/datafile/sjzh_data056.dbf
input datafile fno=00193 name=+DATA/qzpoais/datafile/sjzh_data060.dbf
input datafile fno=00199 name=+DATA/qzpoais/datafile/sjzh_data066.dbf
input datafile fno=00203 name=+DATA/qzpoais/datafile/sjzh_data070.dbf
input datafile fno=00207 name=+DATA/qzpoais/datafile/sjzh_data074.dbf
input datafile fno=00213 name=+DATA/qzpoais/datafile/sjzh_data080.dbf
input datafile fno=00003 name=+DATA/qzpoais/datafile/sysaux.264.636130071
channel t1: starting piece 1 at 01/19/2008 06:38:49
channel t2: finished piece 1 at 01/19/2008 06:41:04
piece handle=qzpoais_full_20080118_644371140_maj6gkm4_1_1 tag=TAG20080118T235857 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 06:42:04
channel t2: starting incremental level 0 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00004 name=+DATA/qzpoais/datafile/undotbs2.266.636130075
input datafile fno=00219 name=+DATA/qzpoais/datafile/sm2100004.dbf
input datafile fno=00222 name=+DATA/qzpoais/datafile/sm2100007.dbf
input datafile fno=00225 name=+DATA/qzpoais/datafile/sm2100010.dbf
input datafile fno=00228 name=+DATA/qzpoais/datafile/sm2100013.dbf
input datafile fno=00231 name=+DATA/qzpoais/datafile/sm2100016.dbf
input datafile fno=00235 name=+DATA/qzpoais/datafile/sm2100020.dbf
input datafile fno=00239 name=+DATA/qzpoais/datafile/sm2100024.dbf
input datafile fno=00243 name=+DATA/qzpoais/datafile/sm2100028.dbf
input datafile fno=00247 name=+DATA/qzpoais/datafile/sm2100032.dbf
input datafile fno=00142 name=+DATA/qzpoais/datafile/sjzh_data028.dbf
input datafile fno=00195 name=+DATA/qzpoais/datafile/sjzh_data062.dbf
input datafile fno=00008 name=+DATA/qzpoais/datafile/bfgl_data001.dbf
input datafile fno=00012 name=+DATA/qzpoais/datafile/zfba_photo001.dbf
input datafile fno=00016 name=+DATA/qzpoais/datafile/rk_data002.dbf
input datafile fno=00020 name=+DATA/qzpoais/datafile/rk_data006.dbf
input datafile fno=00024 name=+DATA/qzpoais/datafile/rk_data010.dbf
input datafile fno=00028 name=+DATA/qzpoais/datafile/rk_data014.dbf
input datafile fno=00032 name=+DATA/qzpoais/datafile/rk_data018.dbf
input datafile fno=00036 name=+DATA/qzpoais/datafile/jcyw_data003.dbf
input datafile fno=00044 name=+DATA/qzpoais/datafile/zfba_data003.dbf
input datafile fno=00048 name=+DATA/qzpoais/datafile/sjzh_data003.dbf
input datafile fno=00052 name=+DATA/qzpoais/datafile/sjzh_data007.dbf
input datafile fno=00056 name=+DATA/qzpoais/datafile/sjzh_data011.dbf
input datafile fno=00060 name=+DATA/qzpoais/datafile/sjzh_data015.dbf
input datafile fno=00064 name=+DATA/qzpoais/datafile/sjzh_data019.dbf
input datafile fno=00068 name=+DATA/qzpoais/datafile/rk_photo004.dbf
input datafile fno=00072 name=+DATA/qzpoais/datafile/rk_photo008.dbf
input datafile fno=00076 name=+DATA/qzpoais/datafile/rk_photo012.dbf
input datafile fno=00080 name=+DATA/qzpoais/datafile/rk_photo016.dbf
input datafile fno=00084 name=+DATA/qzpoais/datafile/rk_photo020.dbf
input datafile fno=00088 name=+DATA/qzpoais/datafile/rk_photo024.dbf
input datafile fno=00092 name=+DATA/qzpoais/datafile/rk_photo028.dbf
input datafile fno=00096 name=+DATA/qzpoais/datafile/rk_photo032.dbf
input datafile fno=00100 name=+DATA/qzpoais/datafile/rk_photo036.dbf
input datafile fno=00104 name=+DATA/qzpoais/datafile/rk_photo040.dbf
input datafile fno=00108 name=+DATA/qzpoais/datafile/rk_photo044.dbf
input datafile fno=00112 name=+DATA/qzpoais/datafile/rk_photo048.dbf
input datafile fno=00116 name=+DATA/qzpoais/datafile/rk_photo052.dbf
input datafile fno=00120 name=+DATA/qzpoais/datafile/rk_photo056.dbf
input datafile fno=00124 name=+DATA/qzpoais/datafile/rk_photo060.dbf
input datafile fno=00128 name=+DATA/qzpoais/datafile/rk_photo064.dbf
input datafile fno=00132 name=+DATA/qzpoais/datafile/rk_photo068.dbf
input datafile fno=00136 name=+DATA/qzpoais/datafile/sjzh_data022.dbf
input datafile fno=00140 name=+DATA/qzpoais/datafile/sjzh_data026.dbf
input datafile fno=00145 name=+DATA/qzpoais/datafile/rk_data021.dbf
input datafile fno=00149 name=+DATA/qzpoais/datafile/rk_data025.dbf
input datafile fno=00153 name=+DATA/qzpoais/datafile/rk_data029.dbf
input datafile fno=00157 name=+DATA/qzpoais/datafile/rk_photo072.dbf
input datafile fno=00164 name=+DATA/qzpoais/datafile/sjzh_data031.dbf
input datafile fno=00168 name=+DATA/qzpoais/datafile/sjzh_data035.dbf
input datafile fno=00172 name=+DATA/qzpoais/datafile/sjzh_data039.dbf
input datafile fno=00176 name=+DATA/qzpoais/datafile/sjzh_data043.dbf
input datafile fno=00180 name=+DATA/qzpoais/datafile/sjzh_data047.dbf
input datafile fno=00184 name=+DATA/qzpoais/datafile/sjzh_data051.dbf
input datafile fno=00191 name=+DATA/qzpoais/datafile/sjzh_data058.dbf
input datafile fno=00197 name=+DATA/qzpoais/datafile/sjzh_data064.dbf
input datafile fno=00201 name=+DATA/qzpoais/datafile/sjzh_data068.dbf
input datafile fno=00205 name=+DATA/qzpoais/datafile/sjzh_data072.dbf
input datafile fno=00210 name=+DATA/qzpoais/datafile/sjzh_data077.dbf
input datafile fno=00163 name=+DATA/qzpoais/datafile/pub_data004.dbf
input datafile fno=00161 name=+DATA/qzpoais/datafile/tivoliorts.dbf
channel t2: starting piece 1 at 01/19/2008 06:41:05
channel t1: finished piece 1 at 01/19/2008 14:44:52
piece handle=qzpoais_full_20080119_644395128_mbj6hc3o_1_1 tag=TAG20080118T235857 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 08:06:04
channel t2: finished piece 1 at 01/19/2008 15:02:37
piece handle=qzpoais_full_20080119_644395265_mcj6hc81_1_1 tag=TAG20080118T235857 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 08:21:32
Finished backup at 01/19/2008 15:02:37
Starting Control File and SPFILE Autobackup at 01/19/2008 15:02:38
piece handle=c-1075906752-20080119-00 comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 01/19/2008 15:06:19
sql statement: alter system archive log current
Starting backup at 01/19/2008 15:06:43
current log archived
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/19/2008 15:06:58
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file +DATA/qzpoais/2_3107_636130048.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATA/qzpoais/2_3107_636130048.dbf
ORA-15173: entry '2_3107_636130048.dbf' does not exist in directory 'qzpoais'
Recovery Manager complete.
問題原因:
名為'2_3107_636130048.dbf' 的歸檔日誌檔案被誤刪除,故在備份歸檔日誌檔案時,無法檢測透過,導致後續備份中斷.
另一個關鍵是為什麼會出現歸檔日誌丟失?檢視了之前的備份日誌,發現該日誌檔案有備份成功,又因為設定了backup archivelog all delete all input;,應該是在備份完成後才刪除的,RMAN備份也會誤刪歸檔日誌嗎??
備份日誌:
channel t2: starting archive log backupset
channel t2: specifying archive log(s) in backup set
.......
input archive log thread=1 sequence=11035 recid=17400 stamp=644166462
input archive log thread=1 sequence=11036 recid=17403 stamp=644166474
input archive log thread=2 sequence=3107 recid=17404 stamp=644166585
input archive log thread=2 sequence=3108 recid=17405 stamp=644166585
input archive log thread=2 sequence=3109 recid=17406 stamp=644166585
input archive log thread=2 sequence=3110 recid=17407 stamp=644166586
......
channel t2: deleting archive log(s)
......
archive log filename=+DATA/qzpoais/1_11034_636130048.dbf recid=17399 stamp=644156475
archive log filename=+DATA/qzpoais/1_11035_636130048.dbf recid=17400 stamp=644166462
archive log filename=+DATA/qzpoais/1_11036_636130048.dbf recid=17403 stamp=644166474
archive log filename=+DATA/qzpoais/2_3107_636130048.dbf recid=17404 stamp=644166585
archive log filename=+DATA/qzpoais/2_3108_636130048.dbf recid=17405 stamp=644166585
archive log filename=+DATA/qzpoais/2_3109_636130048.dbf recid=17406 stamp=644166585
archive log filename=+DATA/qzpoais/2_3110_636130048.dbf recid=17407 stamp=644166586
......
另外儲存方式為ASM,刪除歸檔日誌只能透過RMAN命令或者ASMCMD的方式,應該不存在有人手動刪除的情況發生
解決方法:
使用RMAN將丟失的歸檔日誌標記為過期,並刪除,命令如下:
crosscheck archivelog all;
delete expired archivelog all;
執行資料庫完全備份時,最後提示找不到名為'2_3107_636130048.dbf' 的歸檔日誌.
Recovery Manager: Release 10.2.0.3.0 - Production on Fri Jan 18 23:58:42 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN> connect catalog *
2> connect target *
3> run {
4> allocate channel t1 type sbt;
5> allocate channel t2 type sbt;
6> send 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
7> backup incremental level 0
8> format 'qzpoais_full_%T_%t_%U'database;
9> sql 'alter system archive log current';
10> backup format 'qzpoais_arhc_%T_%t_%U' archivelog all delete all input;
11> release channel t1;
12> release channel t2;
13> }
14>
15>
16>
connected to recovery catalog database
connected to target database: QZPOAIS (DBID=1075906752)
starting full resync of recovery catalog
full resync complete
allocated channel: t1
channel t1: sid=1000 instance=qzpoais1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0
allocated channel: t2
channel t2: sid=1035 instance=qzpoais1 devtype=SBT_TAPE
channel t2: Data Protection for Oracle: version 5.4.1.0
sent command to channel: t1
sent command to channel: t2
Starting backup at 01/18/2008 23:58:57
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00216 name=+DATA/qzpoais/datafile/sm2100001.dbf
input datafile fno=00217 name=+DATA/qzpoais/datafile/sm2100002.dbf
input datafile fno=00220 name=+DATA/qzpoais/datafile/sm2100005.dbf
input datafile fno=00223 name=+DATA/qzpoais/datafile/sm2100008.dbf
input datafile fno=00226 name=+DATA/qzpoais/datafile/sm2100011.dbf
input datafile fno=00229 name=+DATA/qzpoais/datafile/sm2100014.dbf
input datafile fno=00232 name=+DATA/qzpoais/datafile/sm2100017.dbf
input datafile fno=00236 name=+DATA/qzpoais/datafile/sm2100021.dbf
input datafile fno=00240 name=+DATA/qzpoais/datafile/sm2100025.dbf
input datafile fno=00244 name=+DATA/qzpoais/datafile/sm2100029.dbf
input datafile fno=00009 name=+DATA/qzpoais/datafile/index_data001.dbf
input datafile fno=00185 name=+DATA/qzpoais/datafile/sjzh_data052.dbf
input datafile fno=00041 name=+DATA/qzpoais/datafile/index_data004.dbf
input datafile fno=00212 name=+DATA/qzpoais/datafile/sjzh_data079.dbf
input datafile fno=00013 name=+DATA/qzpoais/datafile/sjzh_data001.dbf
input datafile fno=00017 name=+DATA/qzpoais/datafile/rk_data003.dbf
input datafile fno=00021 name=+DATA/qzpoais/datafile/rk_data007.dbf
input datafile fno=00025 name=+DATA/qzpoais/datafile/rk_data011.dbf
input datafile fno=00029 name=+DATA/qzpoais/datafile/rk_data015.dbf
input datafile fno=00033 name=+DATA/qzpoais/datafile/rk_data019.dbf
input datafile fno=00037 name=+DATA/qzpoais/datafile/jcyw_data004.dbf
input datafile fno=00045 name=+DATA/qzpoais/datafile/zfba_data004.dbf
input datafile fno=00049 name=+DATA/qzpoais/datafile/sjzh_data004.dbf
input datafile fno=00053 name=+DATA/qzpoais/datafile/sjzh_data008.dbf
input datafile fno=00057 name=+DATA/qzpoais/datafile/sjzh_data012.dbf
input datafile fno=00061 name=+DATA/qzpoais/datafile/sjzh_data016.dbf
input datafile fno=00065 name=+DATA/qzpoais/datafile/sjzh_data020.dbf
input datafile fno=00069 name=+DATA/qzpoais/datafile/rk_photo005.dbf
input datafile fno=00073 name=+DATA/qzpoais/datafile/rk_photo009.dbf
input datafile fno=00077 name=+DATA/qzpoais/datafile/rk_photo013.dbf
input datafile fno=00081 name=+DATA/qzpoais/datafile/rk_photo017.dbf
input datafile fno=00085 name=+DATA/qzpoais/datafile/rk_photo021.dbf
input datafile fno=00089 name=+DATA/qzpoais/datafile/rk_photo025.dbf
input datafile fno=00093 name=+DATA/qzpoais/datafile/rk_photo029.dbf
input datafile fno=00097 name=+DATA/qzpoais/datafile/rk_photo033.dbf
input datafile fno=00101 name=+DATA/qzpoais/datafile/rk_photo037.dbf
input datafile fno=00105 name=+DATA/qzpoais/datafile/rk_photo041.dbf
input datafile fno=00109 name=+DATA/qzpoais/datafile/rk_photo045.dbf
input datafile fno=00113 name=+DATA/qzpoais/datafile/rk_photo049.dbf
input datafile fno=00117 name=+DATA/qzpoais/datafile/rk_photo053.dbf
input datafile fno=00121 name=+DATA/qzpoais/datafile/rk_photo057.dbf
input datafile fno=00125 name=+DATA/qzpoais/datafile/rk_photo061.dbf
input datafile fno=00129 name=+DATA/qzpoais/datafile/rk_photo065.dbf
input datafile fno=00133 name=+DATA/qzpoais/datafile/rk_photo069.dbf
input datafile fno=00137 name=+DATA/qzpoais/datafile/sjzh_data023.dbf
input datafile fno=00141 name=+DATA/qzpoais/datafile/sjzh_data027.dbf
input datafile fno=00146 name=+DATA/qzpoais/datafile/rk_data022.dbf
input datafile fno=00150 name=+DATA/qzpoais/datafile/rk_data026.dbf
input datafile fno=00154 name=+DATA/qzpoais/datafile/rk_data030.dbf
input datafile fno=00158 name=+DATA/qzpoais/datafile/rk_photo073.dbf
input datafile fno=00165 name=+DATA/qzpoais/datafile/sjzh_data032.dbf
input datafile fno=00169 name=+DATA/qzpoais/datafile/sjzh_data036.dbf
input datafile fno=00173 name=+DATA/qzpoais/datafile/sjzh_data040.dbf
input datafile fno=00177 name=+DATA/qzpoais/datafile/sjzh_data044.dbf
input datafile fno=00181 name=+DATA/qzpoais/datafile/sjzh_data048.dbf
input datafile fno=00187 name=+DATA/qzpoais/datafile/sjzh_data054.dbf
input datafile fno=00192 name=+DATA/qzpoais/datafile/sjzh_data059.dbf
input datafile fno=00198 name=+DATA/qzpoais/datafile/sjzh_data065.dbf
input datafile fno=00202 name=+DATA/qzpoais/datafile/sjzh_data069.dbf
input datafile fno=00206 name=+DATA/qzpoais/datafile/sjzh_data073.dbf
input datafile fno=00211 name=+DATA/qzpoais/datafile/sjzh_data078.dbf
input datafile fno=00214 name=+DATA/qzpoais/datafile/index_data006.dbf
input datafile fno=00005 name=+DATA/qzpoais/datafile/users.267.636130077
input datafile fno=00215 name=+DATA/qzpoais/datafile/index_data007.dbf
channel t1: starting piece 1 at 01/18/2008 23:59:00
channel t2: starting incremental level 0 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00002 name=+DATA/qzpoais/datafile/undotbs1.263.636130069
input datafile fno=00234 name=+DATA/qzpoais/datafile/sm2100019.dbf
input datafile fno=00238 name=+DATA/qzpoais/datafile/sm2100023.dbf
input datafile fno=00242 name=+DATA/qzpoais/datafile/sm2100027.dbf
input datafile fno=00246 name=+DATA/qzpoais/datafile/sm2100031.dbf
input datafile fno=00040 name=+DATA/qzpoais/datafile/index_data003.dbf
input datafile fno=00188 name=+DATA/qzpoais/datafile/sjzh_data055.dbf
input datafile fno=00208 name=+DATA/qzpoais/datafile/sjzh_data075.dbf
input datafile fno=00007 name=+DATA/qzpoais/datafile/rk_photo001.dbf
input datafile fno=00011 name=+DATA/qzpoais/datafile/pub_data001.dbf
input datafile fno=00015 name=+DATA/qzpoais/datafile/jcyw_data001.dbf
input datafile fno=00019 name=+DATA/qzpoais/datafile/rk_data005.dbf
input datafile fno=00023 name=+DATA/qzpoais/datafile/rk_data009.dbf
input datafile fno=00027 name=+DATA/qzpoais/datafile/rk_data013.dbf
input datafile fno=00031 name=+DATA/qzpoais/datafile/rk_data017.dbf
input datafile fno=00035 name=+DATA/qzpoais/datafile/jcyw_data002.dbf
input datafile fno=00043 name=+DATA/qzpoais/datafile/zfba_data002.dbf
input datafile fno=00047 name=+DATA/qzpoais/datafile/sjzh_data002.dbf
input datafile fno=00051 name=+DATA/qzpoais/datafile/sjzh_data006.dbf
input datafile fno=00055 name=+DATA/qzpoais/datafile/sjzh_data010.dbf
input datafile fno=00059 name=+DATA/qzpoais/datafile/sjzh_data014.dbf
input datafile fno=00063 name=+DATA/qzpoais/datafile/sjzh_data018.dbf
input datafile fno=00067 name=+DATA/qzpoais/datafile/rk_photo003.dbf
input datafile fno=00071 name=+DATA/qzpoais/datafile/rk_photo007.dbf
input datafile fno=00075 name=+DATA/qzpoais/datafile/rk_photo011.dbf
input datafile fno=00079 name=+DATA/qzpoais/datafile/rk_photo015.dbf
input datafile fno=00083 name=+DATA/qzpoais/datafile/rk_photo019.dbf
input datafile fno=00087 name=+DATA/qzpoais/datafile/rk_photo023.dbf
input datafile fno=00091 name=+DATA/qzpoais/datafile/rk_photo027.dbf
input datafile fno=00095 name=+DATA/qzpoais/datafile/rk_photo031.dbf
input datafile fno=00099 name=+DATA/qzpoais/datafile/rk_photo035.dbf
input datafile fno=00103 name=+DATA/qzpoais/datafile/rk_photo039.dbf
input datafile fno=00107 name=+DATA/qzpoais/datafile/rk_photo043.dbf
input datafile fno=00111 name=+DATA/qzpoais/datafile/rk_photo047.dbf
input datafile fno=00115 name=+DATA/qzpoais/datafile/rk_photo051.dbf
input datafile fno=00119 name=+DATA/qzpoais/datafile/rk_photo055.dbf
input datafile fno=00123 name=+DATA/qzpoais/datafile/rk_photo059.dbf
input datafile fno=00127 name=+DATA/qzpoais/datafile/rk_photo063.dbf
input datafile fno=00131 name=+DATA/qzpoais/datafile/rk_photo067.dbf
input datafile fno=00135 name=+DATA/qzpoais/datafile/sjzh_data021.dbf
input datafile fno=00139 name=+DATA/qzpoais/datafile/sjzh_data025.dbf
input datafile fno=00144 name=+DATA/qzpoais/datafile/sjzh_data030.dbf
input datafile fno=00148 name=+DATA/qzpoais/datafile/rk_data024.dbf
input datafile fno=00152 name=+DATA/qzpoais/datafile/rk_data028.dbf
input datafile fno=00156 name=+DATA/qzpoais/datafile/rk_photo071.dbf
input datafile fno=00160 name=+DATA/qzpoais/datafile/rk_photo075.dbf
input datafile fno=00167 name=+DATA/qzpoais/datafile/sjzh_data034.dbf
input datafile fno=00171 name=+DATA/qzpoais/datafile/sjzh_data038.dbf
input datafile fno=00175 name=+DATA/qzpoais/datafile/sjzh_data042.dbf
input datafile fno=00179 name=+DATA/qzpoais/datafile/sjzh_data046.dbf
input datafile fno=00183 name=+DATA/qzpoais/datafile/sjzh_data050.dbf
input datafile fno=00190 name=+DATA/qzpoais/datafile/sjzh_data057.dbf
input datafile fno=00194 name=+DATA/qzpoais/datafile/sjzh_data061.dbf
input datafile fno=00200 name=+DATA/qzpoais/datafile/sjzh_data067.dbf
input datafile fno=00204 name=+DATA/qzpoais/datafile/sjzh_data071.dbf
input datafile fno=00209 name=+DATA/qzpoais/datafile/sjzh_data076.dbf
input datafile fno=00162 name=+DATA/qzpoais/datafile/pub_data003.dbf
input datafile fno=00001 name=+DATA/qzpoais/datafile/system.262.636130061
channel t2: starting piece 1 at 01/18/2008 23:59:00
channel t1: finished piece 1 at 01/19/2008 06:38:47
piece handle=qzpoais_full_20080118_644371140_m9j6gkm4_1_1 tag=TAG20080118T235857 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 06:39:47
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00042 name=+DATA/qzpoais/datafile/index_data005.dbf
input datafile fno=00218 name=+DATA/qzpoais/datafile/sm2100003.dbf
input datafile fno=00221 name=+DATA/qzpoais/datafile/sm2100006.dbf
input datafile fno=00224 name=+DATA/qzpoais/datafile/sm2100009.dbf
input datafile fno=00227 name=+DATA/qzpoais/datafile/sm2100012.dbf
input datafile fno=00230 name=+DATA/qzpoais/datafile/sm2100015.dbf
input datafile fno=00233 name=+DATA/qzpoais/datafile/sm2100018.dbf
input datafile fno=00237 name=+DATA/qzpoais/datafile/sm2100022.dbf
input datafile fno=00241 name=+DATA/qzpoais/datafile/sm2100026.dbf
input datafile fno=00245 name=+DATA/qzpoais/datafile/sm2100030.dbf
input datafile fno=00039 name=+DATA/qzpoais/datafile/index_data002.dbf
input datafile fno=00186 name=+DATA/qzpoais/datafile/sjzh_data053.dbf
input datafile fno=00196 name=+DATA/qzpoais/datafile/sjzh_data063.dbf
input datafile fno=00006 name=+DATA/qzpoais/datafile/rk_data001.dbf
input datafile fno=00010 name=+DATA/qzpoais/datafile/zfba_data001.dbf
input datafile fno=00014 name=+DATA/qzpoais/datafile/qty_data001.dbf
input datafile fno=00018 name=+DATA/qzpoais/datafile/rk_data004.dbf
input datafile fno=00022 name=+DATA/qzpoais/datafile/rk_data008.dbf
input datafile fno=00026 name=+DATA/qzpoais/datafile/rk_data012.dbf
input datafile fno=00030 name=+DATA/qzpoais/datafile/rk_data016.dbf
input datafile fno=00034 name=+DATA/qzpoais/datafile/rk_data020.dbf
input datafile fno=00038 name=+DATA/qzpoais/datafile/jcyw_data005.dbf
input datafile fno=00046 name=+DATA/qzpoais/datafile/zfba_data005.dbf
input datafile fno=00050 name=+DATA/qzpoais/datafile/sjzh_data005.dbf
input datafile fno=00054 name=+DATA/qzpoais/datafile/sjzh_data009.dbf
input datafile fno=00058 name=+DATA/qzpoais/datafile/sjzh_data013.dbf
input datafile fno=00062 name=+DATA/qzpoais/datafile/sjzh_data017.dbf
input datafile fno=00066 name=+DATA/qzpoais/datafile/rk_photo002.dbf
input datafile fno=00070 name=+DATA/qzpoais/datafile/rk_photo006.dbf
input datafile fno=00074 name=+DATA/qzpoais/datafile/rk_photo010.dbf
input datafile fno=00078 name=+DATA/qzpoais/datafile/rk_photo014.dbf
input datafile fno=00082 name=+DATA/qzpoais/datafile/rk_photo018.dbf
input datafile fno=00086 name=+DATA/qzpoais/datafile/rk_photo022.dbf
input datafile fno=00090 name=+DATA/qzpoais/datafile/rk_photo026.dbf
input datafile fno=00094 name=+DATA/qzpoais/datafile/rk_photo030.dbf
input datafile fno=00098 name=+DATA/qzpoais/datafile/rk_photo034.dbf
input datafile fno=00102 name=+DATA/qzpoais/datafile/rk_photo038.dbf
input datafile fno=00106 name=+DATA/qzpoais/datafile/rk_photo042.dbf
input datafile fno=00110 name=+DATA/qzpoais/datafile/rk_photo046.dbf
input datafile fno=00114 name=+DATA/qzpoais/datafile/rk_photo050.dbf
input datafile fno=00118 name=+DATA/qzpoais/datafile/rk_photo054.dbf
input datafile fno=00122 name=+DATA/qzpoais/datafile/rk_photo058.dbf
input datafile fno=00126 name=+DATA/qzpoais/datafile/rk_photo062.dbf
input datafile fno=00130 name=+DATA/qzpoais/datafile/rk_photo066.dbf
input datafile fno=00134 name=+DATA/qzpoais/datafile/rk_photo070.dbf
input datafile fno=00138 name=+DATA/qzpoais/datafile/sjzh_data024.dbf
input datafile fno=00143 name=+DATA/qzpoais/datafile/sjzh_data029.dbf
input datafile fno=00147 name=+DATA/qzpoais/datafile/rk_data023.dbf
input datafile fno=00151 name=+DATA/qzpoais/datafile/rk_data027.dbf
input datafile fno=00155 name=+DATA/qzpoais/datafile/pub_data002.dbf
input datafile fno=00159 name=+DATA/qzpoais/datafile/rk_photo074.dbf
input datafile fno=00166 name=+DATA/qzpoais/datafile/sjzh_data033.dbf
input datafile fno=00170 name=+DATA/qzpoais/datafile/sjzh_data037.dbf
input datafile fno=00174 name=+DATA/qzpoais/datafile/sjzh_data041.dbf
input datafile fno=00178 name=+DATA/qzpoais/datafile/sjzh_data045.dbf
input datafile fno=00182 name=+DATA/qzpoais/datafile/sjzh_data049.dbf
input datafile fno=00189 name=+DATA/qzpoais/datafile/sjzh_data056.dbf
input datafile fno=00193 name=+DATA/qzpoais/datafile/sjzh_data060.dbf
input datafile fno=00199 name=+DATA/qzpoais/datafile/sjzh_data066.dbf
input datafile fno=00203 name=+DATA/qzpoais/datafile/sjzh_data070.dbf
input datafile fno=00207 name=+DATA/qzpoais/datafile/sjzh_data074.dbf
input datafile fno=00213 name=+DATA/qzpoais/datafile/sjzh_data080.dbf
input datafile fno=00003 name=+DATA/qzpoais/datafile/sysaux.264.636130071
channel t1: starting piece 1 at 01/19/2008 06:38:49
channel t2: finished piece 1 at 01/19/2008 06:41:04
piece handle=qzpoais_full_20080118_644371140_maj6gkm4_1_1 tag=TAG20080118T235857 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 06:42:04
channel t2: starting incremental level 0 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00004 name=+DATA/qzpoais/datafile/undotbs2.266.636130075
input datafile fno=00219 name=+DATA/qzpoais/datafile/sm2100004.dbf
input datafile fno=00222 name=+DATA/qzpoais/datafile/sm2100007.dbf
input datafile fno=00225 name=+DATA/qzpoais/datafile/sm2100010.dbf
input datafile fno=00228 name=+DATA/qzpoais/datafile/sm2100013.dbf
input datafile fno=00231 name=+DATA/qzpoais/datafile/sm2100016.dbf
input datafile fno=00235 name=+DATA/qzpoais/datafile/sm2100020.dbf
input datafile fno=00239 name=+DATA/qzpoais/datafile/sm2100024.dbf
input datafile fno=00243 name=+DATA/qzpoais/datafile/sm2100028.dbf
input datafile fno=00247 name=+DATA/qzpoais/datafile/sm2100032.dbf
input datafile fno=00142 name=+DATA/qzpoais/datafile/sjzh_data028.dbf
input datafile fno=00195 name=+DATA/qzpoais/datafile/sjzh_data062.dbf
input datafile fno=00008 name=+DATA/qzpoais/datafile/bfgl_data001.dbf
input datafile fno=00012 name=+DATA/qzpoais/datafile/zfba_photo001.dbf
input datafile fno=00016 name=+DATA/qzpoais/datafile/rk_data002.dbf
input datafile fno=00020 name=+DATA/qzpoais/datafile/rk_data006.dbf
input datafile fno=00024 name=+DATA/qzpoais/datafile/rk_data010.dbf
input datafile fno=00028 name=+DATA/qzpoais/datafile/rk_data014.dbf
input datafile fno=00032 name=+DATA/qzpoais/datafile/rk_data018.dbf
input datafile fno=00036 name=+DATA/qzpoais/datafile/jcyw_data003.dbf
input datafile fno=00044 name=+DATA/qzpoais/datafile/zfba_data003.dbf
input datafile fno=00048 name=+DATA/qzpoais/datafile/sjzh_data003.dbf
input datafile fno=00052 name=+DATA/qzpoais/datafile/sjzh_data007.dbf
input datafile fno=00056 name=+DATA/qzpoais/datafile/sjzh_data011.dbf
input datafile fno=00060 name=+DATA/qzpoais/datafile/sjzh_data015.dbf
input datafile fno=00064 name=+DATA/qzpoais/datafile/sjzh_data019.dbf
input datafile fno=00068 name=+DATA/qzpoais/datafile/rk_photo004.dbf
input datafile fno=00072 name=+DATA/qzpoais/datafile/rk_photo008.dbf
input datafile fno=00076 name=+DATA/qzpoais/datafile/rk_photo012.dbf
input datafile fno=00080 name=+DATA/qzpoais/datafile/rk_photo016.dbf
input datafile fno=00084 name=+DATA/qzpoais/datafile/rk_photo020.dbf
input datafile fno=00088 name=+DATA/qzpoais/datafile/rk_photo024.dbf
input datafile fno=00092 name=+DATA/qzpoais/datafile/rk_photo028.dbf
input datafile fno=00096 name=+DATA/qzpoais/datafile/rk_photo032.dbf
input datafile fno=00100 name=+DATA/qzpoais/datafile/rk_photo036.dbf
input datafile fno=00104 name=+DATA/qzpoais/datafile/rk_photo040.dbf
input datafile fno=00108 name=+DATA/qzpoais/datafile/rk_photo044.dbf
input datafile fno=00112 name=+DATA/qzpoais/datafile/rk_photo048.dbf
input datafile fno=00116 name=+DATA/qzpoais/datafile/rk_photo052.dbf
input datafile fno=00120 name=+DATA/qzpoais/datafile/rk_photo056.dbf
input datafile fno=00124 name=+DATA/qzpoais/datafile/rk_photo060.dbf
input datafile fno=00128 name=+DATA/qzpoais/datafile/rk_photo064.dbf
input datafile fno=00132 name=+DATA/qzpoais/datafile/rk_photo068.dbf
input datafile fno=00136 name=+DATA/qzpoais/datafile/sjzh_data022.dbf
input datafile fno=00140 name=+DATA/qzpoais/datafile/sjzh_data026.dbf
input datafile fno=00145 name=+DATA/qzpoais/datafile/rk_data021.dbf
input datafile fno=00149 name=+DATA/qzpoais/datafile/rk_data025.dbf
input datafile fno=00153 name=+DATA/qzpoais/datafile/rk_data029.dbf
input datafile fno=00157 name=+DATA/qzpoais/datafile/rk_photo072.dbf
input datafile fno=00164 name=+DATA/qzpoais/datafile/sjzh_data031.dbf
input datafile fno=00168 name=+DATA/qzpoais/datafile/sjzh_data035.dbf
input datafile fno=00172 name=+DATA/qzpoais/datafile/sjzh_data039.dbf
input datafile fno=00176 name=+DATA/qzpoais/datafile/sjzh_data043.dbf
input datafile fno=00180 name=+DATA/qzpoais/datafile/sjzh_data047.dbf
input datafile fno=00184 name=+DATA/qzpoais/datafile/sjzh_data051.dbf
input datafile fno=00191 name=+DATA/qzpoais/datafile/sjzh_data058.dbf
input datafile fno=00197 name=+DATA/qzpoais/datafile/sjzh_data064.dbf
input datafile fno=00201 name=+DATA/qzpoais/datafile/sjzh_data068.dbf
input datafile fno=00205 name=+DATA/qzpoais/datafile/sjzh_data072.dbf
input datafile fno=00210 name=+DATA/qzpoais/datafile/sjzh_data077.dbf
input datafile fno=00163 name=+DATA/qzpoais/datafile/pub_data004.dbf
input datafile fno=00161 name=+DATA/qzpoais/datafile/tivoliorts.dbf
channel t2: starting piece 1 at 01/19/2008 06:41:05
channel t1: finished piece 1 at 01/19/2008 14:44:52
piece handle=qzpoais_full_20080119_644395128_mbj6hc3o_1_1 tag=TAG20080118T235857 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 08:06:04
channel t2: finished piece 1 at 01/19/2008 15:02:37
piece handle=qzpoais_full_20080119_644395265_mcj6hc81_1_1 tag=TAG20080118T235857 comment=API Version 2.0,MMS Version 5.4.1.0
channel t2: backup set complete, elapsed time: 08:21:32
Finished backup at 01/19/2008 15:02:37
Starting Control File and SPFILE Autobackup at 01/19/2008 15:02:38
piece handle=c-1075906752-20080119-00 comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 01/19/2008 15:06:19
sql statement: alter system archive log current
Starting backup at 01/19/2008 15:06:43
current log archived
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/19/2008 15:06:58
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file +DATA/qzpoais/2_3107_636130048.dbf
ORA-17503: ksfdopn:2 Failed to open file +DATA/qzpoais/2_3107_636130048.dbf
ORA-15173: entry '2_3107_636130048.dbf' does not exist in directory 'qzpoais'
Recovery Manager complete.
問題原因:
名為'2_3107_636130048.dbf' 的歸檔日誌檔案被誤刪除,故在備份歸檔日誌檔案時,無法檢測透過,導致後續備份中斷.
另一個關鍵是為什麼會出現歸檔日誌丟失?檢視了之前的備份日誌,發現該日誌檔案有備份成功,又因為設定了backup archivelog all delete all input;,應該是在備份完成後才刪除的,RMAN備份也會誤刪歸檔日誌嗎??
備份日誌:
channel t2: starting archive log backupset
channel t2: specifying archive log(s) in backup set
.......
input archive log thread=1 sequence=11035 recid=17400 stamp=644166462
input archive log thread=1 sequence=11036 recid=17403 stamp=644166474
input archive log thread=2 sequence=3107 recid=17404 stamp=644166585
input archive log thread=2 sequence=3108 recid=17405 stamp=644166585
input archive log thread=2 sequence=3109 recid=17406 stamp=644166585
input archive log thread=2 sequence=3110 recid=17407 stamp=644166586
......
channel t2: deleting archive log(s)
......
archive log filename=+DATA/qzpoais/1_11034_636130048.dbf recid=17399 stamp=644156475
archive log filename=+DATA/qzpoais/1_11035_636130048.dbf recid=17400 stamp=644166462
archive log filename=+DATA/qzpoais/1_11036_636130048.dbf recid=17403 stamp=644166474
archive log filename=+DATA/qzpoais/2_3107_636130048.dbf recid=17404 stamp=644166585
archive log filename=+DATA/qzpoais/2_3108_636130048.dbf recid=17405 stamp=644166585
archive log filename=+DATA/qzpoais/2_3109_636130048.dbf recid=17406 stamp=644166585
archive log filename=+DATA/qzpoais/2_3110_636130048.dbf recid=17407 stamp=644166586
......
另外儲存方式為ASM,刪除歸檔日誌只能透過RMAN命令或者ASMCMD的方式,應該不存在有人手動刪除的情況發生
解決方法:
使用RMAN將丟失的歸檔日誌標記為過期,並刪除,命令如下:
crosscheck archivelog all;
delete expired archivelog all;
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/31344955/viewspace-2103780/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 誤刪歸檔日誌除導致備份歸檔日誌失敗
- RMAN-ERROR：因為找不到過期和丟失的歸檔日誌而備份失敗Error
- 因AIX系統目錄許可權問題導致TSM備份失敗AI
- rman備份的時候讀取v$session_longops失敗導致備份失敗SessionGo
- 【備份恢復】恢復 丟失已歸檔重做日誌檔案
- Oracle RMAN 不完全恢復（只有資料檔案備份，丟失歸檔日誌備份）Oracle
- 沒備份，歸檔日誌存在，丟失資料檔案的恢復
- sap brtools發起oracle備份失敗，tsm備份軟體備份報錯Oracle
- 利用增量備份恢復因歸檔丟失造成的DG gap
- rman備份但丟失一個資料檔案,但有歸檔備份
- 故障分析 | DDL 導致的 Xtrabackup 備份失敗
- 備份之歸檔重做日誌備份
- 備份歸檔日誌
- 使用RMAN增量備份處理Dataguard因歸檔丟失造成的gap
- 都是crosscheck惹的禍,備份歸檔失敗ROS
- dg丟失歸檔，使用rman增量備份恢復
- 利用增量備份恢復gap歸檔丟失DG
- rman全庫備份備份歸檔日誌檔案
- rman備份後為什麼要同時備份歸檔日誌
- 備份歸檔日誌檔案
- RMAN備份歸檔日誌多份 %c
- 非歸檔無備份下控制檔案丟失的恢復
- 歸檔模式無備份丟失資料檔案後恢復模式
- 歸檔模式有備份丟失資料檔案後恢復模式
- 備份恢復之redo日誌組member成員丟失
- Oracle設定多個歸檔路徑生成多份歸檔日誌，Rman備份時也只備份其中的一份歸檔日誌Oracle
- 世界備份日——如果您丟失了所有檔案
- TSM備份時提示認證失敗(Authentication failure)問題的解決AI
- gitlab自動定時備份檔案，備份失敗傳送郵件Gitlab
- 用RMAN備份歸檔日誌時檢查歸檔日誌是否存在
- 刪除歸檔物理檔案備份失敗！ORA-19625
- Mysql備份失敗案例(一)MySql
- RMAN備份歸檔日誌指令碼指令碼
- 備份恢復之資料檔案丟失
- 【備份恢復】歸檔模式下丟失系統關鍵資料檔案 利用RMAN備份恢復模式
- 【Azure 應用服務】備份網站時由於檔案太大了，導致應用服務備份失敗。如何解決？網站
- 【DB2學習】由於TSM損壞導致歸檔失敗DB2
- 冷備份+歸檔日誌的恢復