Heim  >  Artikel  >  Datenbank  >  ORA-19606: Cannot copy or restore to snapshot control file

ORA-19606: Cannot copy or restore to snapshot control file

WBOY
WBOYOriginal
2016-06-07 17:32:221253Durchsuche

因发现 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

Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn