查看过期备份
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 117 01-MAR-10
Backup Piece 117 01-MAR-10 /backup/database/arch_ATYU30_3pl7egjp_121_1.dbf
Backup Set 116 01-MAR-10
Backup Piece 116 01-MAR-10 /backup/database/arch_ATYU30_3ql7egjp_122_1.dbf
Backup Set 121 02-MAR-10
Backup Piece 121 02-MAR-10 /backup/database/dbfull_ATYU30_3sl7h4ne_124_1.dbf
Backup Set 120 02-MAR-10
Backup Piece 120 02-MAR-10 /backup/database/dbfull_ATYU30_3tl7h4ne_125_1.dbf
Backup Set 119 02-MAR-10
Backup Piece 119 02-MAR-10 /backup/database/dbfull_ATYU30_3ul7h4ne_126_1.dbf
Backup Set 122 02-MAR-10
Backup Piece 122 02-MAR-10 /backup/database/ctl_ATYU30_127_1_712545206.dbf
Backup Set 125 02-MAR-10
Backup Piece 125 02-MAR-10 /backup/database/arch_ATYU30_41l7h4u8_129_1.dbf
Backup Set 124 02-MAR-10
Backup Piece 124 02-MAR-10 /backup/database/arch_ATYU30_42l7h4u8_130_1.dbf
Backup Set 133 03-MAR-10
Backup Piece 133 03-MAR-10 /backup/database/dbfull_ATYU30_48l7jp3f_136_1.dbf
Backup Set 131 03-MAR-10
Backup Piece 131 03-MAR-10 /backup/database/dbfull_ATYU30_49l7jp3f_137_1.dbf
Backup Set 132 03-MAR-10
Backup Piece 132 03-MAR-10 /backup/database/dbfull_ATYU30_4al7jp3f_138_1.dbf
Backup Set 134 03-MAR-10
Backup Piece 134 03-MAR-10 /backup/database/ctl_ATYU30_139_1_712631951.dbf
Backup Set 137 03-MAR-10
Backup Piece 137 03-MAR-10 /backup/database/arch_ATYU30_4dl7jplb_141_1.dbf
Backup Set 136 03-MAR-10
Backup Piece 136 03-MAR-10 /backup/database/arch_ATYU30_4el7jplb_142_1.dbf
Backup Set 141 04-MAR-10
Backup Piece 141 04-MAR-10 /backup/database/dbfull_ATYU30_4gl7mdfe_144_1.dbf
Backup Set 139 04-MAR-10
Backup Piece 139 04-MAR-10 /backup/database/dbfull_ATYU30_4hl7mdfe_145_1.dbf
Backup Set 140 04-MAR-10
Backup Piece 140 04-MAR-10 /backup/database/dbfull_ATYU30_4il7mdfe_146_1.dbf
Backup Set 142 04-MAR-10
Backup Piece 142 04-MAR-10 /backup/database/ctl_ATYU30_147_1_712718390.dbf
Backup Set 145 04-MAR-10
Backup Piece 145 04-MAR-10 /backup/database/arch_ATYU30_4ll7me2h_149_1.dbf
Backup Set 144 04-MAR-10
Backup Piece 144 04-MAR-10 /backup/database/arch_ATYU30_4ml7me2h_150_1.dbf
Backup Set 149 05-MAR-10
Backup Piece 149 05-MAR-10 /backup/database/dbfull_ATYU30_4ol7p1re_152_1.dbf
Backup Set 147 05-MAR-10
Backup Piece 147 05-MAR-10 /backup/database/dbfull_ATYU30_4pl7p1re_153_1.dbf
Backup Set 148 05-MAR-10
Backup Piece 148 05-MAR-10 /backup/database/dbfull_ATYU30_4ql7p1re_154_1.dbf
Backup Set 150 05-MAR-10
Backup Piece 150 05-MAR-10 /backup/database/ctl_ATYU30_155_1_712804786.dbf
Backup Set 151 05-MAR-10
Backup Piece 151 05-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_05/o1_mf_s_712804787_5rztxnb1_.bkp
Backup Set 153 05-MAR-10
Backup Piece 153 05-MAR-10 /backup/database/arch_ATYU30_4tl7p2eb_157_1.dbf
Backup Set 152 05-MAR-10
Backup Piece 152 05-MAR-10 /backup/database/arch_ATYU30_4ul7p2eb_158_1.dbf
Backup Set 154 05-MAR-10
Backup Piece 154 05-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_05/o1_mf_s_712804907_5rzv1d0f_.bkp
Backup Set 157 06-MAR-10
Backup Piece 157 06-MAR-10 /backup/database/dbfull_ATYU30_50l7rm7e_160_1.dbf
Backup Set 155 06-MAR-10
Backup Piece 155 06-MAR-10 /backup/database/dbfull_ATYU30_51l7rm7e_161_1.dbf
Backup Set 156 06-MAR-10
Backup Piece 156 06-MAR-10 /backup/database/dbfull_ATYU30_52l7rm7e_162_1.dbf
Backup Set 158 06-MAR-10
Backup Piece 158 06-MAR-10 /backup/database/ctl_ATYU30_163_1_712891207.dbf
Backup Set 159 06-MAR-10
Backup Piece 159 06-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_06/o1_mf_s_712891208_5s2hb9j9_.bkp
Backup Set 161 06-MAR-10
Backup Piece 161 06-MAR-10 /backup/database/arch_ATYU30_55l7rmr2_165_1.dbf
Backup Set 160 06-MAR-10
Backup Piece 160 06-MAR-10 /backup/database/arch_ATYU30_56l7rmr2_166_1.dbf
Backup Set 162 06-MAR-10
Backup Piece 162 06-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_06/o1_mf_s_712891361_5s2hh1xh_.bkp
Backup Set 165 07-MAR-10
Backup Piece 165 07-MAR-10 /backup/database/dbfull_ATYU30_58l7uaje_168_1.dbf
Backup Set 163 07-MAR-10
Backup Piece 163 07-MAR-10 /backup/database/dbfull_ATYU30_59l7uaje_169_1.dbf
Backup Set 164 07-MAR-10
Backup Piece 164 07-MAR-10 /backup/database/dbfull_ATYU30_5al7uaje_170_1.dbf
Backup Set 166 07-MAR-10
Backup Piece 166 07-MAR-10 /backup/database/ctl_ATYU30_171_1_712977629.dbf
Backup Set 167 07-MAR-10
Backup Piece 167 07-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_07/o1_mf_s_712977630_5s53pz60_.bkp
Backup Set 169 07-MAR-10
Backup Piece 169 07-MAR-10 /backup/database/arch_ATYU30_5dl7ub7n_173_1.dbf
Backup Set 168 07-MAR-10
Backup Piece 168 07-MAR-10 /backup/database/arch_ATYU30_5el7ub7n_174_1.dbf
Backup Set 170 07-MAR-10
Backup Piece 170 07-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_07/o1_mf_s_712977772_5s53vdtn_.bkp
Backup Set 173 08-MAR-10
Backup Piece 173 08-MAR-10 /backup/database/dbfull_ATYU30_5gl80uve_176_1.dbf
Backup Set 172 08-MAR-10
Backup Piece 172 08-MAR-10 /backup/database/dbfull_ATYU30_5hl80uve_177_1.dbf
Backup Set 171 08-MAR-10
Backup Piece 171 08-MAR-10 /backup/database/dbfull_ATYU30_5il80uve_178_1.dbf
Backup Set 174 08-MAR-10
Backup Piece 174 08-MAR-10 /backup/database/ctl_ATYU30_179_1_713064002.dbf
Backup Set 175 08-MAR-10
Backup Piece 175 08-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_08/o1_mf_s_713064004_5s7r24kp_.bkp
Backup Set 177 08-MAR-10
Backup Piece 177 08-MAR-10 /backup/database/arch_ATYU30_5ll80viq_181_1.dbf
Backup Set 176 08-MAR-10
Backup Piece 176 08-MAR-10 /backup/database/arch_ATYU30_5ml80viq_182_1.dbf
Backup Set 178 08-MAR-10
Backup Piece 178 08-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_08/o1_mf_s_713064140_5s7r6f86_.bkp
Backup Set 181 09-MAR-10
Backup Piece 181 09-MAR-10 /backup/database/dbfull_ATYU30_5ol83jbd_184_1.dbf
Backup Set 179 09-MAR-10
Backup Piece 179 09-MAR-10 /backup/database/dbfull_ATYU30_5pl83jbe_185_1.dbf
Backup Set 180 09-MAR-10
Backup Piece 180 09-MAR-10 /backup/database/dbfull_ATYU30_5ql83jbe_186_1.dbf
Backup Set 182 09-MAR-10
Backup Piece 182 09-MAR-10 /backup/database/ctl_ATYU30_187_1_713150390.dbf
Backup Set 183 09-MAR-10
Backup Piece 183 09-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_09/o1_mf_s_713150392_5sbdfs57_.bkp
Backup Set 185 09-MAR-10
Backup Piece 185 09-MAR-10 /backup/database/arch_ATYU30_5tl83ju9_189_1.dbf
Backup Set 184 09-MAR-10
Backup Piece 184 09-MAR-10 /backup/database/arch_ATYU30_5ul83jua_190_1.dbf
Backup Set 186 09-MAR-10
Backup Piece 186 09-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_09/o1_mf_s_713150506_5sbdkc21_.bkp
Backup Set 189 10-MAR-10
Backup Piece 189 10-MAR-10 /backup/database/dbfull_ATYU30_60l867ne_192_1.dbf
Backup Set 187 10-MAR-10
Backup Piece 187 10-MAR-10 /backup/database/dbfull_ATYU30_61l867nf_193_1.dbf
Backup Set 188 10-MAR-10
Backup Piece 188 10-MAR-10 /backup/database/dbfull_ATYU30_62l867nf_194_1.dbf
Backup Set 190 10-MAR-10
Backup Piece 190 10-MAR-10 /backup/database/ctl_ATYU30_195_1_713236779.dbf
Backup Set 191 10-MAR-10
Backup Piece 191 10-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_10/o1_mf_s_713236783_5sf0sjmx_.bkp
Backup Set 193 10-MAR-10
Backup Piece 193 10-MAR-10 /backup/database/arch_ATYU30_65l868a8_197_1.dbf
Backup Set 192 10-MAR-10
Backup Piece 192 10-MAR-10 /backup/database/arch_ATYU30_66l868a8_198_1.dbf
Backup Set 194 10-MAR-10
Backup Piece 194 10-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_10/o1_mf_s_713236918_5sf0xs3d_.bkp
Backup Set 197 11-MAR-10
Backup Piece 197 11-MAR-10 /backup/database/dbfull_ATYU30_68l88s3d_200_1.dbf
Backup Set 195 11-MAR-10
Backup Piece 195 11-MAR-10 /backup/database/dbfull_ATYU30_69l88s3e_201_1.dbf
Backup Set 196 11-MAR-10
Backup Piece 196 11-MAR-10 /backup/database/dbfull_ATYU30_6al88s3e_202_1.dbf
Backup Set 198 11-MAR-10
Backup Piece 198 11-MAR-10 /backup/database/ctl_ATYU30_203_1_713323190.dbf
Backup Set 199 11-MAR-10
Backup Piece 199 11-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_11/o1_mf_s_713323192_5sho5rx0_.bkp
Backup Set 201 11-MAR-10
Backup Piece 201 11-MAR-10 /backup/database/arch_ATYU30_6dl88smb_205_1.dbf
Backup Set 200 11-MAR-10
Backup Piece 200 11-MAR-10 /backup/database/arch_ATYU30_6el88smb_206_1.dbf
Control File Copy 2 11-MAR-10 /backup/controlfile/201003111529.ctl
Backup Set 202 11-MAR-10
Backup Piece 202 11-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_11/o1_mf_s_713323318_5sho9pxz_.bkp
Backup Set 205 12-MAR-10
Backup Piece 205 12-MAR-10 /backup/database/dbfull_ATYU30_6gl8bgfe_208_1.dbf
Backup Set 203 12-MAR-10
Backup Piece 203 12-MAR-10 /backup/database/dbfull_ATYU30_6hl8bgfe_209_1.dbf
Backup Set 204 12-MAR-10
Backup Piece 204 12-MAR-10 /backup/database/dbfull_ATYU30_6il8bgff_210_1.dbf
Backup Set 206 12-MAR-10
Backup Piece 206 12-MAR-10 /backup/database/ctl_ATYU30_211_1_713409569.dbf
Backup Set 207 12-MAR-10
Backup Piece 207 12-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_12/o1_mf_s_713409570_5sl9k3n5_.bkp
Backup Set 209 12-MAR-10
Backup Piece 209 12-MAR-10 /backup/database/arch_ATYU30_6ll8bh1n_213_1.dbf
Backup Set 208 12-MAR-10
Backup Piece 208 12-MAR-10 /backup/database/arch_ATYU30_6ml8bh1n_214_1.dbf
Backup Set 210 12-MAR-10
Backup Piece 210 12-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_12/o1_mf_s_713409714_5sl9om98_.bkp
Backup Set 213 13-MAR-10
Backup Piece 213 13-MAR-10 /backup/database/dbfull_ATYU30_6ol8e4re_216_1.dbf
Backup Set 212 13-MAR-10
Backup Piece 212 13-MAR-10 /backup/database/dbfull_ATYU30_6pl8e4rf_217_1.dbf
Backup Set 211 13-MAR-10
Backup Piece 211 13-MAR-10 /backup/database/dbfull_ATYU30_6ql8e4rf_218_1.dbf
Backup Set 214 13-MAR-10
Backup Piece 214 13-MAR-10 /backup/database/ctl_ATYU30_219_1_713495963.dbf
Backup Set 215 13-MAR-10
Backup Piece 215 13-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_13/o1_mf_s_713495967_5snxx0nc_.bkp
Backup Set 217 13-MAR-10
Backup Piece 217 13-MAR-10 /backup/database/arch_ATYU30_6tl8e5e2_221_1.dbf
Backup Set 216 13-MAR-10
Backup Piece 216 13-MAR-10 /backup/database/arch_ATYU30_6ul8e5e2_222_1.dbf
Backup Set 218 13-MAR-10
Backup Piece 218 13-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_13/o1_mf_s_713496131_5sny23nw_.bkp
Backup Set 221 14-MAR-10
Backup Piece 221 14-MAR-10 /backup/database/dbfull_ATYU30_70l8gp7d_224_1.dbf
Backup Set 219 14-MAR-10
Backup Piece 219 14-MAR-10 /backup/database/dbfull_ATYU30_71l8gp7d_225_1.dbf
Backup Set 220 14-MAR-10
Backup Piece 220 14-MAR-10 /backup/database/dbfull_ATYU30_72l8gp7d_226_1.dbf
Backup Set 222 14-MAR-10
Backup Piece 222 14-MAR-10 /backup/database/ctl_ATYU30_227_1_713582418.dbf
Backup Set 223 14-MAR-10
Backup Piece 223 14-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_14/o1_mf_s_713582419_5sqlbnfc_.bkp
Backup Set 225 14-MAR-10
Backup Piece 225 14-MAR-10 /backup/database/arch_ATYU30_75l8gpr9_229_1.dbf
Backup Set 224 14-MAR-10
Backup Piece 224 14-MAR-10 /backup/database/arch_ATYU30_76l8gpr9_230_1.dbf
Backup Set 226 14-MAR-10
Backup Piece 226 14-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_14/o1_mf_s_713582534_5sqlg7dr_.bkp
Backup Set 229 15-MAR-10
Backup Piece 229 15-MAR-10 /backup/database/dbfull_ATYU30_78l8jdjd_232_1.dbf
Backup Set 227 15-MAR-10
Backup Piece 227 15-MAR-10 /backup/database/dbfull_ATYU30_79l8jdjd_233_1.dbf
Backup Set 228 15-MAR-10
Backup Piece 228 15-MAR-10 /backup/database/dbfull_ATYU30_7al8jdjd_234_1.dbf
Backup Set 230 15-MAR-10
Backup Piece 230 15-MAR-10 /backup/database/ctl_ATYU30_235_1_713668759.dbf
Backup Set 231 15-MAR-10
Backup Piece 231 15-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_15/o1_mf_s_713668762_5st6nvsl_.bkp
Backup Set 233 15-MAR-10
Backup Piece 233 15-MAR-10 /backup/database/arch_ATYU30_7dl8je5l_237_1.dbf
Backup Set 232 15-MAR-10
Backup Piece 232 15-MAR-10 /backup/database/arch_ATYU30_7el8je5l_238_1.dbf
Backup Set 234 15-MAR-10
Backup Piece 234 15-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_15/o1_mf_s_713668893_5st6rxm6_.bkp
Backup Set 237 16-MAR-10
Backup Piece 237 16-MAR-10 /backup/database/dbfull_ATYU30_7gl8m1vf_240_1.dbf
Backup Set 235 16-MAR-10
Backup Piece 235 16-MAR-10 /backup/database/dbfull_ATYU30_7hl8m1vf_241_1.dbf
Backup Set 236 16-MAR-10
Backup Piece 236 16-MAR-10 /backup/database/dbfull_ATYU30_7il8m1vf_242_1.dbf
Backup Set 238 16-MAR-10
Backup Piece 238 16-MAR-10 /backup/database/ctl_ATYU30_243_1_713755181.dbf
Backup Set 239 16-MAR-10
Backup Piece 239 16-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_16/o1_mf_s_713755186_5swv1mmr_.bkp
Backup Set 241 16-MAR-10
Backup Piece 241 16-MAR-10 /backup/database/arch_ATYU30_7ll8m2il_245_1.dbf
Backup Set 240 16-MAR-10
Backup Piece 240 16-MAR-10 /backup/database/arch_ATYU30_7ml8m2im_246_1.dbf
Backup Set 242 16-MAR-10
Backup Piece 242 16-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_16/o1_mf_s_713755332_5swv64nq_.bkp
Backup Set 245 17-MAR-10
Backup Piece 245 17-MAR-10 /backup/database/dbfull_ATYU30_7ol8ombe_248_1.dbf
Backup Set 243 17-MAR-10
Backup Piece 243 17-MAR-10 /backup/database/dbfull_ATYU30_7pl8ombe_249_1.dbf
Backup Set 244 17-MAR-10
Backup Piece 244 17-MAR-10 /backup/database/dbfull_ATYU30_7ql8ombe_250_1.dbf
Backup Set 246 17-MAR-10
Backup Piece 246 17-MAR-10 /backup/database/ctl_ATYU30_251_1_713841601.dbf
Backup Set 247 17-MAR-10
Backup Piece 247 17-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_17/o1_mf_s_713841605_5szhg610_.bkp
Backup Set 249 17-MAR-10
Backup Piece 249 17-MAR-10 /backup/database/arch_ATYU30_7tl8omv8_253_1.dbf
Backup Set 248 17-MAR-10
Backup Piece 248 17-MAR-10 /backup/database/arch_ATYU30_7ul8omv8_254_1.dbf
Backup Set 250 17-MAR-10
Backup Piece 250 17-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_17/o1_mf_s_713841767_5szhm7z7_.bkp
Backup Set 253 18-MAR-10
Backup Piece 253 18-MAR-10 /backup/database/dbfull_ATYU30_80l8rane_256_1.dbf
Backup Set 251 18-MAR-10
Backup Piece 251 18-MAR-10 /backup/database/dbfull_ATYU30_81l8rane_257_1.dbf
Backup Set 252 18-MAR-10
Backup Piece 252 18-MAR-10 /backup/database/dbfull_ATYU30_82l8rane_258_1.dbf
Backup Set 254 18-MAR-10
Backup Piece 254 18-MAR-10 /backup/database/ctl_ATYU30_259_1_713927984.dbf
Backup Set 255 18-MAR-10
Backup Piece 255 18-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_18/o1_mf_s_713927986_5t23slsd_.bkp
Backup Set 257 18-MAR-10
Backup Piece 257 18-MAR-10 /backup/database/arch_ATYU30_85l8rbac_261_1.dbf
Backup Set 256 18-MAR-10
Backup Piece 256 18-MAR-10 /backup/database/arch_ATYU30_86l8rbac_262_1.dbf
Backup Set 258 18-MAR-10
Backup Piece 258 18-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_18/o1_mf_s_713928138_5t23yckj_.bkp
Backup Set 261 19-MAR-10
Backup Piece 261 19-MAR-10 /backup/database/dbfull_ATYU30_88l8tv3f_264_1.dbf
Backup Set 259 19-MAR-10
Backup Piece 259 19-MAR-10 /backup/database/dbfull_ATYU30_89l8tv3f_265_1.dbf
Backup Set 260 19-MAR-10
Backup Piece 260 19-MAR-10 /backup/database/dbfull_ATYU30_8al8tv3f_266_1.dbf
Backup Set 262 19-MAR-10
Backup Piece 262 19-MAR-10 /backup/database/ctl_ATYU30_267_1_714014370.dbf
Backup Set 263 19-MAR-10
Backup Piece 263 19-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_19/o1_mf_s_714014371_5t4r54gh_.bkp
Backup Set 265 19-MAR-10
Backup Piece 265 19-MAR-10 /backup/database/arch_ATYU30_8dl8tvmj_269_1.dbf
Backup Set 264 19-MAR-10
Backup Piece 264 19-MAR-10 /backup/database/arch_ATYU30_8el8tvmk_270_1.dbf
Backup Set 266 19-MAR-10
Backup Piece 266 19-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_19/o1_mf_s_714014556_5t4rbxfb_.bkp
Backup Set 269 20-MAR-10
Backup Piece 269 20-MAR-10 /backup/database/dbfull_ATYU30_8gl90jfe_272_1.dbf
Backup Set 267 20-MAR-10
Backup Piece 267 20-MAR-10 /backup/database/dbfull_ATYU30_8hl90jfe_273_1.dbf
Backup Set 268 20-MAR-10
Backup Piece 268 20-MAR-10 /backup/database/dbfull_ATYU30_8il90jfe_274_1.dbf
Backup Set 270 20-MAR-10
Backup Piece 270 20-MAR-10 /backup/database/ctl_ATYU30_275_1_714100762.dbf
Backup Set 271 20-MAR-10
Backup Piece 271 20-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_20/o1_mf_s_714100763_5t7djw4z_.bkp
Backup Set 273 20-MAR-10
Backup Piece 273 20-MAR-10 /backup/database/arch_ATYU30_8ll90k1v_277_1.dbf
Backup Set 272 20-MAR-10
Backup Piece 272 20-MAR-10 /backup/database/arch_ATYU30_8ml90k20_278_1.dbf
Backup Set 274 20-MAR-10
Backup Piece 274 20-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_20/o1_mf_s_714100948_5t7dpodb_.bkp
Backup Set 277 21-MAR-10
Backup Piece 277 21-MAR-10 /backup/database/dbfull_ATYU30_8ol937re_280_1.dbf
Backup Set 275 21-MAR-10
Backup Piece 275 21-MAR-10 /backup/database/dbfull_ATYU30_8pl937re_281_1.dbf
Backup Set 276 21-MAR-10
Backup Piece 276 21-MAR-10 /backup/database/dbfull_ATYU30_8ql937rf_282_1.dbf
Backup Set 278 21-MAR-10
Backup Piece 278 21-MAR-10 /backup/database/ctl_ATYU30_283_1_714187169.dbf
Backup Set 279 21-MAR-10
Backup Piece 279 21-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_21/o1_mf_s_714187171_5tb0x40p_.bkp
Backup Set 281 21-MAR-10
Backup Piece 281 21-MAR-10 /backup/database/arch_ATYU30_8tl938e7_285_1.dbf
Backup Set 280 21-MAR-10
Backup Piece 280 21-MAR-10 /backup/database/arch_ATYU30_8ul938e7_286_1.dbf
Backup Set 282 21-MAR-10
Backup Piece 282 21-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_21/o1_mf_s_714187337_5tb129op_.bkp
Backup Set 285 22-MAR-10
Backup Piece 285 22-MAR-10 /backup/database/dbfull_ATYU30_90l95s7e_288_1.dbf
Backup Set 283 22-MAR-10
Backup Piece 283 22-MAR-10 /backup/database/dbfull_ATYU30_91l95s7e_289_1.dbf
Backup Set 284 22-MAR-10
Backup Piece 284 22-MAR-10 /backup/database/dbfull_ATYU30_92l95s7e_290_1.dbf
Backup Set 286 22-MAR-10
Backup Piece 286 22-MAR-10 /backup/database/ctl_ATYU30_291_1_714273580.dbf
Backup Set 287 22-MAR-10
Backup Piece 287 22-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_22/o1_mf_s_714273582_5tdo9h2d_.bkp
Backup Set 289 22-MAR-10
Backup Piece 289 22-MAR-10 /backup/database/arch_ATYU30_95l95sql_293_1.dbf
Backup Set 288 22-MAR-10
Backup Piece 288 22-MAR-10 /backup/database/arch_ATYU30_96l95sql_294_1.dbf
Backup Set 290 22-MAR-10
Backup Piece 290 22-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_22/o1_mf_s_714273758_5tdogz8w_.bkp
Backup Set 293 23-MAR-10
Backup Piece 293 23-MAR-10 /backup/database/dbfull_ATYU30_98l98gje_296_1.dbf
Backup Set 292 23-MAR-10
Backup Piece 292 23-MAR-10 /backup/database/dbfull_ATYU30_99l98gje_297_1.dbf
Backup Set 291 23-MAR-10
Backup Piece 291 23-MAR-10 /backup/database/dbfull_ATYU30_9al98gje_298_1.dbf
Backup Set 294 23-MAR-10
Backup Piece 294 23-MAR-10 /backup/database/ctl_ATYU30_299_1_714359972.dbf
Backup Set 295 23-MAR-10
Backup Piece 295 23-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_23/o1_mf_s_714359974_5th9o6lv_.bkp
Backup Set 297 23-MAR-10
Backup Piece 297 23-MAR-10 /backup/database/arch_ATYU30_9dl98h6i_301_1.dbf
Backup Set 296 23-MAR-10
Backup Piece 296 23-MAR-10 /backup/database/arch_ATYU30_9el98h6j_302_1.dbf
Backup Set 298 23-MAR-10
Backup Piece 298 23-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_23/o1_mf_s_714360137_5th9t9z3_.bkp
Backup Set 301 24-MAR-10
Backup Piece 301 24-MAR-10 /backup/database/dbfull_ATYU30_9gl9b4vf_304_1.dbf
Backup Set 299 24-MAR-10
Backup Piece 299 24-MAR-10 /backup/database/dbfull_ATYU30_9hl9b4vf_305_1.dbf
Backup Set 300 24-MAR-10
Backup Piece 300 24-MAR-10 /backup/database/dbfull_ATYU30_9il9b4vf_306_1.dbf
Backup Set 302 24-MAR-10
Backup Piece 302 24-MAR-10 /backup/database/ctl_ATYU30_307_1_714446383.dbf
Backup Set 303 24-MAR-10
Backup Piece 303 24-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_24/o1_mf_s_714446384_5tky1k4c_.bkp
Backup Set 305 24-MAR-10
Backup Piece 305 24-MAR-10 /backup/database/arch_ATYU30_9ll9b5j0_309_1.dbf
Backup Set 304 24-MAR-10
Backup Piece 304 24-MAR-10 /backup/database/arch_ATYU30_9ml9b5j1_310_1.dbf
Backup Set 306 24-MAR-10
Backup Piece 306 24-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_24/o1_mf_s_714446572_5tky7fg8_.bkp
Backup Set 310 25-MAR-10
Backup Piece 310 25-MAR-10 /backup/database/ctl_ATYU30_315_1_714532760.dbf
Backup Set 311 25-MAR-10
Backup Piece 311 25-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_25/o1_mf_s_714532762_5tnldv0r_.bkp
Backup Set 313 25-MAR-10
Backup Piece 313 25-MAR-10 /backup/database/arch_ATYU30_9tl9dptm_317_1.dbf
RMAN>
report obsolete命令删除过期备份
RMAN> delete obsolete;
...
Backup Set 304 24-MAR-10
Backup Piece 304 24-MAR-10 /backup/database/arch_ATYU30_9ml9b5j1_310_1.dbf
Backup Set 306 24-MAR-10
Backup Piece 306 24-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_24/o1_mf_s_714446572_5tky7fg8_.bkp
Backup Set 310 25-MAR-10
Backup Piece 310 25-MAR-10 /backup/database/ctl_ATYU30_315_1_714532760.dbf
Backup Set 311 25-MAR-10
Backup Piece 311 25-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_03_25/o1_mf_s_714532762_5tnldv0r_.bkp
Backup Set 313 25-MAR-10
Backup Piece 313 25-MAR-10 /backup/database/arch_ATYU30_9tl9dptm_317_1.dbf
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/backup/database/arch_ATYU30_3pl7egjp_121_1.dbf recid=117 stamp=712458874
deleted backup piece
backup piece handle=/backup/database/arch_ATYU30_3ql7egjp_122_1.dbf recid=116 stamp=712458874
deleted backup piece
backup piece handle=/backup/database/dbfull_ATYU30_3sl7h4ne_124_1.dbf recid=121 stamp=712545010
...
RMAN> list copy;
using target database control file instead of recovery catalog
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
699 1 181 A 25-MAR-10 /opt/oracle/flash_recovery_area/ATYU30/archivelog/2010_03_25/o1_mf_1_181_5tonghly_.arc
RMAN>
同步控制文件的信息和实际物理文件的信息
RMAN>
RMAN> crosscheck archivelog all;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=121 devtype=DISK
validation succeeded for archived log
archive log filename=/opt/oracle/flash_recovery_area/ATYU30/archivelog/2010_03_25/o1_mf_1_181_5tonghly_.arc recid=699 stamp=714567669
Crosschecked 1 objects
RMAN>
