因发现 flash area 不多了，通过 select * from v$flash_recovery_area_usage ； 发现是备份集占用空间太多。于是delete obsolet
因发现 flash area 不多了，通过 select * from v$flash_recovery_area_usage ； 发现是备份集占用空间太多。
于是delete obsolete; 发现出现报错 ora-19606: cannot copy or restore to snapshot control file
rman> delete obsolete;
rman retention policy will be applied to the command
rman retention policy is set to redundancy 1
allocated channel: ora_disk_1
channel ora_disk_1: sid=174 device type=disk
deleting the following obsolete backups and copies:
type key completion time filename/handle
-------------------- ------ ------------------ --------------------
control file copy 1 23-aug-13 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_finaprim.f
backup set 560 20-sep-13
backup piece 560 20-sep-13 +datadg/finaprim/backupset/2013_09_20/annnf0_tag20130920t233259_0.1829.826673579
backup set 561 20-sep-13
backup piece 561 20-sep-13 +datadg/finaprim/autobackup/2013_09_20/s_826673580.945.826673581
backup set 562 21-sep-13
backup piece 562 21-sep-13 +datadg/finaprim/backupset/2013_09_21/annnf0_tag20130921t233004_0.623.826759805
backup set 563 21-sep-13
backup piece 563 21-sep-13 +datadg/finaprim/backupset/2013_09_21/nnndf0_tag20130921t233011_0.693.826759813
backup set 564 21-sep-13
backup piece 564 21-sep-13 +datadg/finaprim/backupset/2013_09_21/annnf0_tag20130921t233257_0.807.826759977
backup set 565 21-sep-13
backup piece 565 21-sep-13 +datadg/finaprim/autobackup/2013_09_21/s_826759979.743.826759979
backup set 566 22-sep-13
backup piece 566 22-sep-13 +datadg/finaprim/backupset/2013_09_22/annnf0_tag20130922t233005_0.1800.826846207
backup set 567 22-sep-13
backup piece 567 22-sep-13 +datadg/finaprim/backupset/2013_09_22/nnndf0_tag20130922t233021_0.624.826846223
backup set 568 22-sep-13
backup piece 568 22-sep-13 +datadg/finaprim/backupset/2013_09_22/annnf0_tag20130922t233307_0.1887.826846387
backup set 569 22-sep-13
backup piece 569 22-sep-13 +datadg/finaprim/autobackup/2013_09_22/s_826846388.1891.826846389
backup set 570 23-sep-13
backup piece 570 23-sep-13 +datadg/finaprim/backupset/2013_09_23/annnf0_tag20130923t233004_0.1041.826932605
backup set 571 23-sep-13
backup piece 571 23-sep-13 +datadg/finaprim/backupset/2013_09_23/nnndf0_tag20130923t233020_0.776.826932621
backup set 572 23-sep-13
backup piece 572 23-sep-13 +datadg/finaprim/backupset/2013_09_23/annnf0_tag20130923t233306_0.1895.826932787
backup set 573 23-sep-13
backup piece 573 23-sep-13 +datadg/finaprim/autobackup/2013_09_23/s_826932787.1061.826932789
backup set 574 24-sep-13
backup piece 574 24-sep-13 +datadg/finaprim/backupset/2013_09_24/annnf0_tag20130924t233005_0.1082.827019005