Home > TroubleShooting > ORA-19505: failed to identify file “/export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat”

ORA-19505: failed to identify file “/export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat”

Symptoms

When duplicate a database by RMAN,
channel ORA_AUX_DISK_1: reading from backup piece /export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat
ORA-19505: failed to identify file “/export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat”
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Fixed
RMAN> list backupset

RMAN> crosscheck backup;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=492 instance=cviqa1 device type=DISK
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat RECID=647 STAMP=709021876
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/cviqa/bkup_CVIQA_649_1_709022294.dat RECID=648 STAMP=709022294
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/cviqa/ctlfile_c-188335673-20100123-00.dat RECID=649 STAMP=709022296
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/bkuppool/oracle/bkup/databases/cviqa/bkup_CVIQA_765_1_721395939.dat RECID=750 STAMP=721395939
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/bkuppool/oracle/bkup/databases/cviqa/bkup_CVIQA_766_1_721397036.dat RECID=751 STAMP=721397036
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/bkuppool/oracle/bkup/databases/cviqa/bkup_ctl_c-188335673-20100611-01.dat RECID=752 STAMP=721397038
Crosschecked 6 objects
RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
——- ——- — — ———– ———– ———-
647     647     1   1   EXPIRED     DISK        /export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat
648     648     1   1   EXPIRED     DISK        /export/home/oracle/bkup/cviqa/bkup_CVIQA_649_1_709022294.dat
649     649     1   1   EXPIRED     DISK        /export/home/oracle/bkup/cviqa/ctlfile_c-188335673-20100123-00.dat

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat RECID=647 STAMP=709021876
deleted backup piece
backup piece handle=/export/home/oracle/bkup/cviqa/bkup_CVIQA_649_1_709022294.dat RECID=648 STAMP=709022294
deleted backup piece
backup piece handle=/export/home/oracle/bkup/cviqa/ctlfile_c-188335673-20100123-00.dat RECID=649 STAMP=709022296
Deleted 3 EXPIRED objects

Advertisements
Categories: TroubleShooting
  1. July 19, 2015 at 7:32 am

    Hello there! Your websites are running slowly , it consumed just like a
    minute or two to reload, I do not know whether it is just
    me or perhaps your web page then again facebook performed for me.
    Around the other hand thank you for creating splendid article.
    I’m assuming it really has been helpful to plenty
    of people who arrived at this point. I ought to say that you have done wonderful job with this and wish to find out many more wonderful stuff through you.
    I ‘ve got your site saved to bookmarks to see new stuff you post.

  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: