RMAN> crosscheck archivelog all;
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 318 26-MAR-10
Backup Piece 318 26-MAR-10 /backup/RMAN/dbfull_ATYU30_a1l9gdnd_321_1.dbf
Backup Set 316 26-MAR-10
Backup Piece 316 26-MAR-10 /backup/RMAN/dbfull_ATYU30_a2l9gdnd_322_1.dbf
Backup Set 317 26-MAR-10
Backup Piece 317 26-MAR-10 /backup/RMAN/dbfull_ATYU30_a3l9gdnd_323_1.dbf
Backup Set 321 26-MAR-10
Backup Piece 321 26-MAR-10 /backup/RMAN/arch_ATYU30_a7l9ged3_327_1.dbf
Backup Set 335 26-MAR-10
Backup Piece 335 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_329_1_714672856
Backup Set 326 26-MAR-10
Backup Piece 326 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_330_1_714672857
Backup Set 334 26-MAR-10
Backup Piece 334 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_331_1_714672857
Backup Set 324 26-MAR-10
Backup Piece 324 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_332_1_714672857
Backup Set 325 26-MAR-10
Backup Piece 325 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_333_1_714673028
Backup Set 327 26-MAR-10
Backup Piece 327 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_334_1_714673157
Backup Set 328 26-MAR-10
Backup Piece 328 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_335_1_714673225
Backup Set 330 26-MAR-10
Backup Piece 330 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_336_1_714673261
Backup Set 329 26-MAR-10
Backup Piece 329 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_337_1_714673269
Backup Set 331 26-MAR-10
Backup Piece 331 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_338_1_714673317
Backup Set 332 26-MAR-10
Backup Piece 332 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_339_1_714673318
Backup Set 333 26-MAR-10
Backup Piece 333 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_340_1_714673385
Backup Set 336 26-MAR-10
Backup Piece 336 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_StandCtl_20100326_all9i3br_s341_p1
Backup Set 341 26-MAR-10
Backup Piece 341 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_343_1_714673541
Backup Set 340 26-MAR-10
Backup Piece 340 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_344_1_714673541
Backup Set 338 26-MAR-10
Backup Piece 338 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_345_1_714673541
Backup Set 339 26-MAR-10
Backup Piece 339 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_346_1_714673553
Control File Copy 3 26-MAR-10 /backup/RMAN/FULLBACK100326/control100326
Backup Set 345 31-MAR-10
Backup Piece 345 31-MAR-10 /backup/RMAN/dbfull_ATYU30_aul9tjjf_350_1.dbf
Backup Set 346 31-MAR-10
Backup Piece 346 31-MAR-10 /backup/RMAN/dbfull_ATYU30_avl9tjjf_351_1.dbf
Backup Set 344 31-MAR-10
Backup Piece 344 31-MAR-10 /backup/RMAN/dbfull_ATYU30_b0l9tjjf_352_1.dbf
Backup Set 347 31-MAR-10
Backup Piece 347 31-MAR-10 /backup/RMAN/ctl_ATYU30_353_1_715051228.dbf
Backup Set 352 31-MAR-10
Backup Piece 352 31-MAR-10 /backup/RMAN/arch_ATYU30_b3l9tk7s_355_1.dbf
Backup Set 350 31-MAR-10
Backup Piece 350 31-MAR-10 /backup/RMAN/arch_ATYU30_b4l9tk7s_356_1.dbf
Backup Set 349 31-MAR-10
Backup Piece 349 31-MAR-10 /backup/RMAN/arch_ATYU30_b5l9tk7s_357_1.dbf
Backup Set 353 31-MAR-10
Backup Piece 353 31-MAR-10 /backup/RMAN/arch_ATYU30_b6l9tkgc_358_1.dbf
Backup Set 351 31-MAR-10
Backup Piece 351 31-MAR-10 /backup/RMAN/arch_ATYU30_b7l9tki2_359_1.dbf
Backup Set 355 01-APR-10
Backup Piece 355 01-APR-10 /backup/RMAN/dbfull_ATYU30_b9la07ve_361_1.dbf
Backup Set 357 01-APR-10
Backup Piece 357 01-APR-10 /backup/RMAN/dbfull_ATYU30_bala07ve_362_1.dbf
Backup Set 356 01-APR-10
Backup Piece 356 01-APR-10 /backup/RMAN/dbfull_ATYU30_bbla07vf_363_1.dbf
Backup Set 358 01-APR-10
Backup Piece 358 01-APR-10 /backup/RMAN/ctl_ATYU30_364_1_715137613.dbf
Backup Set 362 01-APR-10
Backup Piece 362 01-APR-10 /backup/RMAN/arch_ATYU30_bela08j9_366_1.dbf
Backup Set 361 01-APR-10
Backup Piece 361 01-APR-10 /backup/RMAN/arch_ATYU30_bfla08j9_367_1.dbf
Backup Set 360 01-APR-10
Backup Piece 360 01-APR-10 /backup/RMAN/arch_ATYU30_bgla08j9_368_1.dbf
Backup Set 365 02-APR-10
Backup Piece 365 02-APR-10 /backup/RMAN/dbfull_ATYU30_bila2sbf_370_1.dbf
Backup Set 366 02-APR-10
Backup Piece 366 02-APR-10 /backup/RMAN/dbfull_ATYU30_bjla2sbf_371_1.dbf
Backup Set 364 02-APR-10
Backup Piece 364 02-APR-10 /backup/RMAN/dbfull_ATYU30_bkla2sbf_372_1.dbf
Backup Set 367 02-APR-10
Backup Piece 367 02-APR-10 /backup/RMAN/ctl_ATYU30_373_1_715223980.dbf
Backup Set 370 02-APR-10
Backup Piece 370 02-APR-10 /backup/RMAN/arch_ATYU30_bnla2sur_375_1.dbf
Backup Set 371 02-APR-10
Backup Piece 371 02-APR-10 /backup/RMAN/arch_ATYU30_bola2sur_376_1.dbf
Backup Set 369 02-APR-10
Backup Piece 369 02-APR-10 /backup/RMAN/arch_ATYU30_bpla2sur_377_1.dbf
Backup Set 373 03-APR-10
Backup Piece 373 03-APR-10 /backup/RMAN/dbfull_ATYU30_brla5gnf_379_1.dbf
Backup Set 375 03-APR-10
Backup Piece 375 03-APR-10 /backup/RMAN/dbfull_ATYU30_bsla5gnf_380_1.dbf
Backup Set 374 03-APR-10
Backup Piece 374 03-APR-10 /backup/RMAN/dbfull_ATYU30_btla5gnf_381_1.dbf
Backup Set 376 03-APR-10
Backup Piece 376 03-APR-10 /backup/RMAN/ctl_ATYU30_382_1_715310421.dbf
Backup Set 379 03-APR-10
Backup Piece 379 03-APR-10 /backup/RMAN/arch_ATYU30_c0la5hb8_384_1.dbf
Backup Set 380 03-APR-10
Backup Piece 380 03-APR-10 /backup/RMAN/arch_ATYU30_c1la5hb8_385_1.dbf
Backup Set 378 03-APR-10
Backup Piece 378 03-APR-10 /backup/RMAN/arch_ATYU30_c2la5hb8_386_1.dbf
Backup Set 383 04-APR-10
Backup Piece 383 04-APR-10 /backup/RMAN/dbfull_ATYU30_c4la853f_388_1.dbf
Backup Set 384 04-APR-10
Backup Piece 384 04-APR-10 /backup/RMAN/dbfull_ATYU30_c5la853f_389_1.dbf
Backup Set 382 04-APR-10
Backup Piece 382 04-APR-10 /backup/RMAN/dbfull_ATYU30_c6la853f_390_1.dbf
Backup Set 385 04-APR-10
Backup Piece 385 04-APR-10 /backup/RMAN/ctl_ATYU30_391_1_715396855.dbf
Backup Set 389 04-APR-10
Backup Piece 389 04-APR-10 /backup/RMAN/arch_ATYU30_c9la85q2_393_1.dbf
Backup Set 388 04-APR-10
Backup Piece 388 04-APR-10 /backup/RMAN/arch_ATYU30_cala85q2_394_1.dbf
Backup Set 387 04-APR-10
Backup Piece 387 04-APR-10 /backup/RMAN/arch_ATYU30_cbla85q2_395_1.dbf
Backup Set 392 05-APR-10
Backup Piece 392 05-APR-10 /backup/RMAN/dbfull_ATYU30_cdlaapfh_397_1.dbf
Backup Set 393 05-APR-10
Backup Piece 393 05-APR-10 /backup/RMAN/dbfull_ATYU30_celaapfh_398_1.dbf
Backup Set 391 05-APR-10
Backup Piece 391 05-APR-10 /backup/RMAN/dbfull_ATYU30_cflaapfh_399_1.dbf
Backup Set 394 05-APR-10
Backup Piece 394 05-APR-10 /backup/RMAN/ctl_ATYU30_400_1_715483266.dbf
Backup Set 397 05-APR-10
Backup Piece 397 05-APR-10 /backup/RMAN/arch_ATYU30_cilaaq9e_402_1.dbf
Backup Set 398 05-APR-10
Backup Piece 398 05-APR-10 /backup/RMAN/arch_ATYU30_cjlaaq9e_403_1.dbf
Backup Set 396 05-APR-10
Backup Piece 396 05-APR-10 /backup/RMAN/arch_ATYU30_cklaaq9e_404_1.dbf
Backup Set 401 06-APR-10
Backup Piece 401 06-APR-10 /backup/RMAN/dbfull_ATYU30_cmladdrf_406_1.dbf
Backup Set 402 06-APR-10
Backup Piece 402 06-APR-10 /backup/RMAN/dbfull_ATYU30_cnladdrf_407_1.dbf
Backup Set 400 06-APR-10
Backup Piece 400 06-APR-10 /backup/RMAN/dbfull_ATYU30_coladdrf_408_1.dbf
Backup Set 403 06-APR-10
Backup Piece 403 06-APR-10 /backup/RMAN/ctl_ATYU30_409_1_715569613.dbf
Backup Set 407 06-APR-10
Backup Piece 407 06-APR-10 /backup/RMAN/arch_ATYU30_crladehi_411_1.dbf
Backup Set 406 06-APR-10
Backup Piece 406 06-APR-10 /backup/RMAN/arch_ATYU30_csladehi_412_1.dbf
Backup Set 405 06-APR-10
Backup Piece 405 06-APR-10 /backup/RMAN/arch_ATYU30_ctladehi_413_1.dbf
Backup Set 409 07-APR-10
Backup Piece 409 07-APR-10 /backup/RMAN/dbfull_ATYU30_cvlag27f_415_1.dbf
Backup Set 411 07-APR-10
Backup Piece 411 07-APR-10 /backup/RMAN/dbfull_ATYU30_d0lag27f_416_1.dbf
Backup Set 410 07-APR-10
Backup Piece 410 07-APR-10 /backup/RMAN/dbfull_ATYU30_d1lag27f_417_1.dbf
Backup Set 412 07-APR-10
Backup Piece 412 07-APR-10 /backup/RMAN/ctl_ATYU30_418_1_715656064.dbf
Backup Set 416 07-APR-10
Backup Piece 416 07-APR-10 /backup/RMAN/arch_ATYU30_d4lag32f_420_1.dbf
Backup Set 415 07-APR-10
Backup Piece 415 07-APR-10 /backup/RMAN/arch_ATYU30_d5lag32f_421_1.dbf
Backup Set 414 07-APR-10
Backup Piece 414 07-APR-10 /backup/RMAN/arch_ATYU30_d6lag32f_422_1.dbf
Backup Set 418 08-APR-10
Backup Piece 418 08-APR-10 /backup/RMAN/dbfull_ATYU30_d8laimjf_424_1.dbf
Backup Set 420 08-APR-10
Backup Piece 420 08-APR-10 /backup/RMAN/dbfull_ATYU30_d9laimjf_425_1.dbf
Backup Set 419 08-APR-10
Backup Piece 419 08-APR-10 /backup/RMAN/dbfull_ATYU30_dalaimjf_426_1.dbf
Backup Set 421 08-APR-10
Backup Piece 421 08-APR-10 /backup/RMAN/ctl_ATYU30_427_1_715742466.dbf
Backup Set 425 08-APR-10
Backup Piece 425 08-APR-10 /backup/RMAN/arch_ATYU30_ddlain9o_429_1.dbf
Backup Set 424 08-APR-10
Backup Piece 424 08-APR-10 /backup/RMAN/arch_ATYU30_delain9o_430_1.dbf
Backup Set 423 08-APR-10
Backup Piece 423 08-APR-10 /backup/RMAN/arch_ATYU30_dflain9o_431_1.dbf
Backup Set 428 09-APR-10
Backup Piece 428 09-APR-10 /backup/RMAN/dbfull_ATYU30_dhlalavf_433_1.dbf
Backup Set 429 09-APR-10
Backup Piece 429 09-APR-10 /backup/RMAN/dbfull_ATYU30_dilalavf_434_1.dbf
Backup Set 427 09-APR-10
Backup Piece 427 09-APR-10 /backup/RMAN/dbfull_ATYU30_djlalavf_435_1.dbf
Backup Set 430 09-APR-10
Backup Piece 430 09-APR-10 /backup/RMAN/ctl_ATYU30_436_1_715828832.dbf
Backup Set 433 09-APR-10
Backup Piece 433 09-APR-10 /backup/RMAN/arch_ATYU30_dmlalbk0_438_1.dbf
Backup Set 434 09-APR-10
Backup Piece 434 09-APR-10 /backup/RMAN/arch_ATYU30_dnlalbk0_439_1.dbf
Backup Set 432 09-APR-10
Backup Piece 432 09-APR-10 /backup/RMAN/arch_ATYU30_dolalbk0_440_1.dbf
Backup Set 436 10-APR-10
Backup Piece 436 10-APR-10 /backup/RMAN/dbfull_ATYU30_dqlanvbg_442_1.dbf
Backup Set 438 10-APR-10
Backup Piece 438 10-APR-10 /backup/RMAN/dbfull_ATYU30_drlanvbg_443_1.dbf
Backup Set 437 10-APR-10
Backup Piece 437 10-APR-10 /backup/RMAN/dbfull_ATYU30_dslanvbh_444_1.dbf
Backup Set 439 10-APR-10
Backup Piece 439 10-APR-10 /backup/RMAN/ctl_ATYU30_445_1_715915256.dbf
Backup Set 442 10-APR-10
Backup Piece 442 10-APR-10 /backup/RMAN/arch_ATYU30_dvlao015_447_1.dbf
Backup Set 443 10-APR-10
Backup Piece 443 10-APR-10 /backup/RMAN/arch_ATYU30_e0lao015_448_1.dbf
Backup Set 441 10-APR-10
Backup Piece 441 10-APR-10 /backup/RMAN/arch_ATYU30_e1lao015_449_1.dbf
Backup Set 446 11-APR-10
Backup Piece 446 11-APR-10 /backup/RMAN/dbfull_ATYU30_e3laqjnh_451_1.dbf
Backup Set 447 11-APR-10
Backup Piece 447 11-APR-10 /backup/RMAN/dbfull_ATYU30_e4laqjni_452_1.dbf
Backup Set 445 11-APR-10
Backup Piece 445 11-APR-10 /backup/RMAN/dbfull_ATYU30_e5laqjnr_453_1.dbf
Backup Set 448 11-APR-10
Backup Piece 448 11-APR-10 /backup/RMAN/ctl_ATYU30_454_1_716001592.dbf
Backup Set 451 11-APR-10
Backup Piece 451 11-APR-10 /backup/RMAN/arch_ATYU30_e8laqkhd_456_1.dbf
Backup Set 452 11-APR-10
Backup Piece 452 11-APR-10 /backup/RMAN/arch_ATYU30_e9laqkhd_457_1.dbf
Backup Set 450 11-APR-10
Backup Piece 450 11-APR-10 /backup/RMAN/arch_ATYU30_ealaqkhd_458_1.dbf
Backup Set 453 11-APR-10
Backup Piece 453 11-APR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_04_11/o1_mf_s_716002085_5w1f96fl_.bkp
Backup Set 457 12-APR-10
Backup Piece 457 12-APR-10 /backup/RMAN/ctl_ATYU30_463_1_716088081.dbf
Backup Set 458 12-APR-10
Backup Piece 458 12-APR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_04_12/o1_mf_s_716088082_5w418m28_.bkp
Backup Set 460 12-APR-10
Backup Piece 460 12-APR-10 /backup/RMAN/arch_ATYU30_ehlat8sm_465_1.dbf
Backup Set 461 12-APR-10
Backup Piece 461 12-APR-10 /backup/RMAN/arch_ATYU30_eilat8sm_466_1.dbf
RMAN> delete noprompt backup of archivelog all completed before 'sysdate-7' device type disk;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=431 devtype=DISK
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
321 321 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_a7l9ged3_327_1.dbf
338 338 1 1 AVAILABLE DISK /backup/RMAN/FULLBACK100326/bk_345_1_714673541
339 339 1 1 AVAILABLE DISK /backup/RMAN/FULLBACK100326/bk_346_1_714673553
340 340 1 1 AVAILABLE DISK /backup/RMAN/FULLBACK100326/bk_344_1_714673541
341 341 1 1 AVAILABLE DISK /backup/RMAN/FULLBACK100326/bk_343_1_714673541
349 349 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_b5l9tk7s_357_1.dbf
350 350 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_b4l9tk7s_356_1.dbf
351 351 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_b7l9tki2_359_1.dbf
352 352 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_b3l9tk7s_355_1.dbf
353 353 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_b6l9tkgc_358_1.dbf
360 360 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_bgla08j9_368_1.dbf
361 361 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_bfla08j9_367_1.dbf
362 362 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_bela08j9_366_1.dbf
369 369 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_bpla2sur_377_1.dbf
370 370 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_bnla2sur_375_1.dbf
371 371 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_bola2sur_376_1.dbf
378 378 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_c2la5hb8_386_1.dbf
379 379 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_c0la5hb8_384_1.dbf
380 380 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_c1la5hb8_385_1.dbf
387 387 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_cbla85q2_395_1.dbf
388 388 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_cala85q2_394_1.dbf
389 389 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_c9la85q2_393_1.dbf
396 396 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_cklaaq9e_404_1.dbf
397 397 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_cilaaq9e_402_1.dbf
398 398 1 1 AVAILABLE DISK /backup/RMAN/arch_ATYU30_cjlaaq9e_403_1.dbf
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_a7l9ged3_327_1.dbf recid=321 stamp=714619299
deleted backup piece
backup piece handle=/backup/RMAN/FULLBACK100326/bk_345_1_714673541 recid=338 stamp=714673541
deleted backup piece
backup piece handle=/backup/RMAN/FULLBACK100326/bk_346_1_714673553 recid=339 stamp=714673554
deleted backup piece
backup piece handle=/backup/RMAN/FULLBACK100326/bk_344_1_714673541 recid=340 stamp=714673541
deleted backup piece
backup piece handle=/backup/RMAN/FULLBACK100326/bk_343_1_714673541 recid=341 stamp=714673541
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_b5l9tk7s_357_1.dbf recid=349 stamp=715051261
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_b4l9tk7s_356_1.dbf recid=350 stamp=715051261
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_b7l9tki2_359_1.dbf recid=351 stamp=715051586
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_b3l9tk7s_355_1.dbf recid=352 stamp=715051261
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_b6l9tkgc_358_1.dbf recid=353 stamp=715051537
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_bgla08j9_368_1.dbf recid=360 stamp=715137642
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_bfla08j9_367_1.dbf recid=361 stamp=715137642
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_bela08j9_366_1.dbf recid=362 stamp=715137642
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_bpla2sur_377_1.dbf recid=369 stamp=715224028
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_bnla2sur_375_1.dbf recid=370 stamp=715224028
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_bola2sur_376_1.dbf recid=371 stamp=715224028
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_c2la5hb8_386_1.dbf recid=378 stamp=715310441
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_c0la5hb8_384_1.dbf recid=379 stamp=715310441
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_c1la5hb8_385_1.dbf recid=380 stamp=715310441
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_cbla85q2_395_1.dbf recid=387 stamp=715396931
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_cala85q2_394_1.dbf recid=388 stamp=715396931
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_c9la85q2_393_1.dbf recid=389 stamp=715396931
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_cklaaq9e_404_1.dbf recid=396 stamp=715483438
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_cilaaq9e_402_1.dbf recid=397 stamp=715483438
deleted backup piece
backup piece handle=/backup/RMAN/arch_ATYU30_cjlaaq9e_403_1.dbf recid=398 stamp=715483438
Deleted 25 objects
RMAN>
RMAN> delete noprompt backup of controlfile completed before 'sysdate-7' device type disk;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=431 devtype=DISK
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
336 336 1 1 AVAILABLE DISK /backup/RMAN/FULLBACK100326/bk_StandCtl_20100326_all9i3br_s341_p1
347 347 1 1 AVAILABLE DISK /backup/RMAN/ctl_ATYU30_353_1_715051228.dbf
358 358 1 1 AVAILABLE DISK /backup/RMAN/ctl_ATYU30_364_1_715137613.dbf
367 367 1 1 AVAILABLE DISK /backup/RMAN/ctl_ATYU30_373_1_715223980.dbf
376 376 1 1 AVAILABLE DISK /backup/RMAN/ctl_ATYU30_382_1_715310421.dbf
385 385 1 1 AVAILABLE DISK /backup/RMAN/ctl_ATYU30_391_1_715396855.dbf
394 394 1 1 AVAILABLE DISK /backup/RMAN/ctl_ATYU30_400_1_715483266.dbf
deleted backup piece
backup piece handle=/backup/RMAN/FULLBACK100326/bk_StandCtl_20100326_all9i3br_s341_p1 recid=336 stamp=714673532
deleted backup piece
backup piece handle=/backup/RMAN/ctl_ATYU30_353_1_715051228.dbf recid=347 stamp=715051229
deleted backup piece
backup piece handle=/backup/RMAN/ctl_ATYU30_364_1_715137613.dbf recid=358 stamp=715137614
deleted backup piece
backup piece handle=/backup/RMAN/ctl_ATYU30_373_1_715223980.dbf recid=367 stamp=715223980
deleted backup piece
backup piece handle=/backup/RMAN/ctl_ATYU30_382_1_715310421.dbf recid=376 stamp=715310422
deleted backup piece
backup piece handle=/backup/RMAN/ctl_ATYU30_391_1_715396855.dbf recid=385 stamp=715396856
deleted backup piece
backup piece handle=/backup/RMAN/ctl_ATYU30_400_1_715483266.dbf recid=394 stamp=715483266
Deleted 7 objects
RMAN>
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 318 26-MAR-10
Backup Piece 318 26-MAR-10 /backup/RMAN/dbfull_ATYU30_a1l9gdnd_321_1.dbf
Backup Set 316 26-MAR-10
Backup Piece 316 26-MAR-10 /backup/RMAN/dbfull_ATYU30_a2l9gdnd_322_1.dbf
Backup Set 317 26-MAR-10
Backup Piece 317 26-MAR-10 /backup/RMAN/dbfull_ATYU30_a3l9gdnd_323_1.dbf
Backup Set 335 26-MAR-10
Backup Piece 335 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_329_1_714672856
Backup Set 326 26-MAR-10
Backup Piece 326 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_330_1_714672857
Backup Set 334 26-MAR-10
Backup Piece 334 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_331_1_714672857
Backup Set 324 26-MAR-10
Backup Piece 324 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_332_1_714672857
Backup Set 325 26-MAR-10
Backup Piece 325 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_333_1_714673028
Backup Set 327 26-MAR-10
Backup Piece 327 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_334_1_714673157
Backup Set 328 26-MAR-10
Backup Piece 328 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_335_1_714673225
Backup Set 330 26-MAR-10
Backup Piece 330 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_336_1_714673261
Backup Set 329 26-MAR-10
Backup Piece 329 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_337_1_714673269
Backup Set 331 26-MAR-10
Backup Piece 331 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_338_1_714673317
Backup Set 332 26-MAR-10
Backup Piece 332 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_339_1_714673318
Backup Set 333 26-MAR-10
Backup Piece 333 26-MAR-10 /backup/RMAN/FULLBACK100326/bk_340_1_714673385
Control File Copy 3 26-MAR-10 /backup/RMAN/FULLBACK100326/control100326
Backup Set 345 31-MAR-10
Backup Piece 345 31-MAR-10 /backup/RMAN/dbfull_ATYU30_aul9tjjf_350_1.dbf
Backup Set 346 31-MAR-10
Backup Piece 346 31-MAR-10 /backup/RMAN/dbfull_ATYU30_avl9tjjf_351_1.dbf
Backup Set 344 31-MAR-10
Backup Piece 344 31-MAR-10 /backup/RMAN/dbfull_ATYU30_b0l9tjjf_352_1.dbf
Backup Set 355 01-APR-10
Backup Piece 355 01-APR-10 /backup/RMAN/dbfull_ATYU30_b9la07ve_361_1.dbf
Backup Set 357 01-APR-10
Backup Piece 357 01-APR-10 /backup/RMAN/dbfull_ATYU30_bala07ve_362_1.dbf
Backup Set 356 01-APR-10
Backup Piece 356 01-APR-10 /backup/RMAN/dbfull_ATYU30_bbla07vf_363_1.dbf
Backup Set 365 02-APR-10
Backup Piece 365 02-APR-10 /backup/RMAN/dbfull_ATYU30_bila2sbf_370_1.dbf
Backup Set 366 02-APR-10
Backup Piece 366 02-APR-10 /backup/RMAN/dbfull_ATYU30_bjla2sbf_371_1.dbf
Backup Set 364 02-APR-10
Backup Piece 364 02-APR-10 /backup/RMAN/dbfull_ATYU30_bkla2sbf_372_1.dbf
Backup Set 373 03-APR-10
Backup Piece 373 03-APR-10 /backup/RMAN/dbfull_ATYU30_brla5gnf_379_1.dbf
Backup Set 375 03-APR-10
Backup Piece 375 03-APR-10 /backup/RMAN/dbfull_ATYU30_bsla5gnf_380_1.dbf
Backup Set 374 03-APR-10
Backup Piece 374 03-APR-10 /backup/RMAN/dbfull_ATYU30_btla5gnf_381_1.dbf
Backup Set 383 04-APR-10
Backup Piece 383 04-APR-10 /backup/RMAN/dbfull_ATYU30_c4la853f_388_1.dbf
Backup Set 384 04-APR-10
Backup Piece 384 04-APR-10 /backup/RMAN/dbfull_ATYU30_c5la853f_389_1.dbf
Backup Set 382 04-APR-10
Backup Piece 382 04-APR-10 /backup/RMAN/dbfull_ATYU30_c6la853f_390_1.dbf
Backup Set 392 05-APR-10
Backup Piece 392 05-APR-10 /backup/RMAN/dbfull_ATYU30_cdlaapfh_397_1.dbf
Backup Set 393 05-APR-10
Backup Piece 393 05-APR-10 /backup/RMAN/dbfull_ATYU30_celaapfh_398_1.dbf
Backup Set 391 05-APR-10
Backup Piece 391 05-APR-10 /backup/RMAN/dbfull_ATYU30_cflaapfh_399_1.dbf
Backup Set 401 06-APR-10
Backup Piece 401 06-APR-10 /backup/RMAN/dbfull_ATYU30_cmladdrf_406_1.dbf
Backup Set 402 06-APR-10
Backup Piece 402 06-APR-10 /backup/RMAN/dbfull_ATYU30_cnladdrf_407_1.dbf
Backup Set 400 06-APR-10
Backup Piece 400 06-APR-10 /backup/RMAN/dbfull_ATYU30_coladdrf_408_1.dbf
Backup Set 403 06-APR-10
Backup Piece 403 06-APR-10 /backup/RMAN/ctl_ATYU30_409_1_715569613.dbf
Backup Set 407 06-APR-10
Backup Piece 407 06-APR-10 /backup/RMAN/arch_ATYU30_crladehi_411_1.dbf
Backup Set 406 06-APR-10
Backup Piece 406 06-APR-10 /backup/RMAN/arch_ATYU30_csladehi_412_1.dbf
Backup Set 405 06-APR-10
Backup Piece 405 06-APR-10 /backup/RMAN/arch_ATYU30_ctladehi_413_1.dbf
Backup Set 409 07-APR-10
Backup Piece 409 07-APR-10 /backup/RMAN/dbfull_ATYU30_cvlag27f_415_1.dbf
Backup Set 411 07-APR-10
Backup Piece 411 07-APR-10 /backup/RMAN/dbfull_ATYU30_d0lag27f_416_1.dbf
Backup Set 410 07-APR-10
Backup Piece 410 07-APR-10 /backup/RMAN/dbfull_ATYU30_d1lag27f_417_1.dbf
Backup Set 412 07-APR-10
Backup Piece 412 07-APR-10 /backup/RMAN/ctl_ATYU30_418_1_715656064.dbf
Backup Set 416 07-APR-10
Backup Piece 416 07-APR-10 /backup/RMAN/arch_ATYU30_d4lag32f_420_1.dbf
Backup Set 415 07-APR-10
Backup Piece 415 07-APR-10 /backup/RMAN/arch_ATYU30_d5lag32f_421_1.dbf
Backup Set 414 07-APR-10
Backup Piece 414 07-APR-10 /backup/RMAN/arch_ATYU30_d6lag32f_422_1.dbf
Backup Set 418 08-APR-10
Backup Piece 418 08-APR-10 /backup/RMAN/dbfull_ATYU30_d8laimjf_424_1.dbf
Backup Set 420 08-APR-10
Backup Piece 420 08-APR-10 /backup/RMAN/dbfull_ATYU30_d9laimjf_425_1.dbf
Backup Set 419 08-APR-10
Backup Piece 419 08-APR-10 /backup/RMAN/dbfull_ATYU30_dalaimjf_426_1.dbf
Backup Set 421 08-APR-10
Backup Piece 421 08-APR-10 /backup/RMAN/ctl_ATYU30_427_1_715742466.dbf
Backup Set 425 08-APR-10
Backup Piece 425 08-APR-10 /backup/RMAN/arch_ATYU30_ddlain9o_429_1.dbf
Backup Set 424 08-APR-10
Backup Piece 424 08-APR-10 /backup/RMAN/arch_ATYU30_delain9o_430_1.dbf
Backup Set 423 08-APR-10
Backup Piece 423 08-APR-10 /backup/RMAN/arch_ATYU30_dflain9o_431_1.dbf
Backup Set 428 09-APR-10
Backup Piece 428 09-APR-10 /backup/RMAN/dbfull_ATYU30_dhlalavf_433_1.dbf
Backup Set 429 09-APR-10
Backup Piece 429 09-APR-10 /backup/RMAN/dbfull_ATYU30_dilalavf_434_1.dbf
Backup Set 427 09-APR-10
Backup Piece 427 09-APR-10 /backup/RMAN/dbfull_ATYU30_djlalavf_435_1.dbf
Backup Set 430 09-APR-10
Backup Piece 430 09-APR-10 /backup/RMAN/ctl_ATYU30_436_1_715828832.dbf
Backup Set 433 09-APR-10
Backup Piece 433 09-APR-10 /backup/RMAN/arch_ATYU30_dmlalbk0_438_1.dbf
Backup Set 434 09-APR-10
Backup Piece 434 09-APR-10 /backup/RMAN/arch_ATYU30_dnlalbk0_439_1.dbf
Backup Set 432 09-APR-10
Backup Piece 432 09-APR-10 /backup/RMAN/arch_ATYU30_dolalbk0_440_1.dbf
Backup Set 436 10-APR-10
Backup Piece 436 10-APR-10 /backup/RMAN/dbfull_ATYU30_dqlanvbg_442_1.dbf
Backup Set 438 10-APR-10
Backup Piece 438 10-APR-10 /backup/RMAN/dbfull_ATYU30_drlanvbg_443_1.dbf
Backup Set 437 10-APR-10
Backup Piece 437 10-APR-10 /backup/RMAN/dbfull_ATYU30_dslanvbh_444_1.dbf
Backup Set 439 10-APR-10
Backup Piece 439 10-APR-10 /backup/RMAN/ctl_ATYU30_445_1_715915256.dbf
Backup Set 442 10-APR-10
Backup Piece 442 10-APR-10 /backup/RMAN/arch_ATYU30_dvlao015_447_1.dbf
Backup Set 443 10-APR-10
Backup Piece 443 10-APR-10 /backup/RMAN/arch_ATYU30_e0lao015_448_1.dbf
Backup Set 441 10-APR-10
Backup Piece 441 10-APR-10 /backup/RMAN/arch_ATYU30_e1lao015_449_1.dbf
Backup Set 446 11-APR-10
Backup Piece 446 11-APR-10 /backup/RMAN/dbfull_ATYU30_e3laqjnh_451_1.dbf
Backup Set 447 11-APR-10
Backup Piece 447 11-APR-10 /backup/RMAN/dbfull_ATYU30_e4laqjni_452_1.dbf
Backup Set 445 11-APR-10
Backup Piece 445 11-APR-10 /backup/RMAN/dbfull_ATYU30_e5laqjnr_453_1.dbf
Backup Set 448 11-APR-10
Backup Piece 448 11-APR-10 /backup/RMAN/ctl_ATYU30_454_1_716001592.dbf
Backup Set 451 11-APR-10
Backup Piece 451 11-APR-10 /backup/RMAN/arch_ATYU30_e8laqkhd_456_1.dbf
Backup Set 452 11-APR-10
Backup Piece 452 11-APR-10 /backup/RMAN/arch_ATYU30_e9laqkhd_457_1.dbf
Backup Set 450 11-APR-10
Backup Piece 450 11-APR-10 /backup/RMAN/arch_ATYU30_ealaqkhd_458_1.dbf
Backup Set 453 11-APR-10
Backup Piece 453 11-APR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_04_11/o1_mf_s_716002085_5w1f96fl_.bkp
Backup Set 457 12-APR-10
Backup Piece 457 12-APR-10 /backup/RMAN/ctl_ATYU30_463_1_716088081.dbf
Backup Set 458 12-APR-10
Backup Piece 458 12-APR-10 /opt/oracle/flash_recovery_area/ATYU30/autobackup/2010_04_12/o1_mf_s_716088082_5w418m28_.bkp
Backup Set 460 12-APR-10
Backup Piece 460 12-APR-10 /backup/RMAN/arch_ATYU30_ehlat8sm_465_1.dbf
Backup Set 461 12-APR-10
Backup Piece 461 12-APR-10 /backup/RMAN/arch_ATYU30_eilat8sm_466_1.dbf
RMAN>
阅读(2982) | 评论(0) | 转发(0) |
