RMAN not behaving

  • From: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 7 Apr 2014 15:37:32 +0000

I'm having a slightly weird situation here that I don't fully know how to 
troubleshoot.

We ran a one-off backup to refresh a test environment, transferred the pieces 
to the test environment, cataloged, all the normal steps.

The restore is failing with errors like:
RMAN-03002: failure of restore command at 04/04/2014 20:54:22
RMAN-12009: command aborted because some backup pieces could not be located
RMAN-12008: could not locate backup piece 
D:\LATESTBACKUP\MHGPMS_FULL_20140404_C5P4S87E_1_1

But listing the backup pieces, RMAN seems to know about it and thinks it is 
available:
  Backup Set Copy #1 of backup set 17760
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:14:59     04-APR-14       YES        MHGPMS_FULL_2014-04-04

    List of Backup Pieces for backup set 17760 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    17900   1   AVAILABLE   D:\LATESTBACKUP\MHGPMS_FULL_20140404_C5P4S87E_1_1

Oracle 10.2.0.4 on Windows. Any ideas where I should begin looking?

Thanks!


Stephan Uzzell

Other related posts: