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

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

When trying to delete obsolete backups, rman includes the snapshot control file, and so spits out
ORA-19606: Cannot copy or restore to snapshot control file


RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/flash/flashback_recovery_area/CCHPRD/snapcf_cchprd1.f';

RMAN> show all;
RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 53 08-MAY-10 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_cchprd1.f
deleted control file copy control file copy
file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_cchprd1.f RECID=53 STAMP=718455816
Deleted 1 objects

Advertisements
Categories: Oracle
  1. GabrielNar
    October 6, 2012 at 3:29 pm

    I had the similar problem and tried Long Path Tool, available at
    http://www.pathtoodeep.com/. It helped me to solve this problem easily.
    Try it, and you will definitely love this tool. Its free.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: