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

Source: Internet
Author: User

Because there are not many flash areas, select * from v $ flash_recovery_area_usage and find that the backup set occupies too much space.
So delete obsolete; found the error 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_fin1_m.f
Backup Set 560 20-SEP-13
Backup Piece 560 20-SEP-13 + DATADG/finerem/backupset/2013_09_20/annnf0_tag20130920t233259_0.1829.826673579
Backup Set 561 20-SEP-13
Backup Piece 561 20-SEP-13 + DATADG/finerem/autobackup/2013_09_20/s_826673580.945.826673581
Backup Set 562 21-SEP-13
Backup Piece 562 21-SEP-13 + DATADG/finerem/backupset/2013_09_21/annnf0_tag20130921t233004_0.623.826759805
Backup Set 563 21-SEP-13
Backup Piece 563 21-SEP-13 + DATADG/finerem/backupset/2013_09_21/nnndf0_tag20130921t233011_0.693.826759813
Backup Set 564 21-SEP-13
Backup Piece 564 21-SEP-13 + DATADG/finerem/backupset/2013_09_21/annnf0_tag20130921t233257_0.807.826759977
Backup Set 565 21-SEP-13
Backup Piece 565 21-SEP-13 + DATADG/finerem/autobackup/2013_09_21/s_826759979.743.826759979
Backup Set 566 22-SEP-13
Backup Piece 566 22-SEP-13 + DATADG/finerem/backupset/2013_09_22/annnf0_tag20130922t233005_0.1800.826846207
Backup Set 567 22-SEP-13
Backup Piece 567 22-SEP-13 + DATADG/finerem/backupset/2013_09_22/nnndf0_tag20130922t233021_0.624.826846223
Backup Set 568 22-SEP-13
Backup Piece 568 22-SEP-13 + DATADG/finerem/backupset/2013_09_22/annnf0_tag20130922t233307_0.1887.826846387
Backup Set 569 22-SEP-13
Backup Piece 569 22-SEP-13 + DATADG/finerem/autobackup/2013_09_22/s_826846388.1891.826846389
Backup Set 570 23-SEP-13
Backup Piece 570 23-SEP-13 + DATADG/finerem/backupset/2013_09_23/annnf0_tag20130923t233004_0.20.1.826932605
Backup Set 571 23-SEP-13
Backup Piece 571 23-SEP-13 + DATADG/finerem/backupset/2013_09_23/nnndf0_tag20130923t233020_0.776.826932621
Backup Set 572 23-SEP-13
Backup Piece 572 23-SEP-13 + DATADG/finerem/backupset/2013_09_23/annnf0_tag20130923t233306_0.1895.826932787
Backup Set 573 23-SEP-13
Backup Piece 573 23-SEP-13 + DATADG/finerem/autobackup/2013_09_23/s_826932787.20.1.826932789
Backup Set 574 24-SEP-13
Backup Piece 574 24-SEP-13 + DATADG/finerem/backupset/2013_09_24/annnf0_tag20130924t233005_0.20.2.827019005

Do you really want to delete the above objects (enter YES or NO )? Yes
RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 09/25/2013 09:16:59
ORA-19606: Cannot copy or restore to snapshot control file


Solution:
Changes the configuration path of the snapshot controlfile and then deletes the SNAPSHOT of the control file.
--- Rename the SNAPSHOT File
RMAN> configure snapshot controlfile name to '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_fin1_m.f_bak ';

New RMAN configuration parameters:
Configure snapshot controlfile name to '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_fin1_m.f_bak ';
New RMAN configuration parameters are successfully stored


---- Crosscheck
RMAN> crosscheck controlfilecopy '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_fin1_m.f ';

Released channel: ORA_DISK_1
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: SID = 174 device type = DISK
Validation failed for control file copy
Control file copy file name =/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_fin1_m.f RECID = 1 STAMP = 824231734
Crosschecked 1 objects

SPFILE error causing database startup failure (ORA-01565)

ORA-01172, ORA-01151 error handling

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

Solution to ORA-00257 archive logs being too large to store

  • 1
  • 2
  • Next Page

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.