RE: RMAN not behaving

  • From: "Powell, Mark" <mark.powell2@xxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 7 Apr 2014 16:18:01 +0000

1 -did you verify that the file physically exists?
2 - did you check the OS level permissions on the file?
3 - post the actual rman commands used.  Failure to allocate a channel can 
produce this error.


From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Uzzell, Stephan
Sent: Monday, April 07, 2014 11:38 AM
To: oracle-l@xxxxxxxxxxxxx
Cc: Uzzell, Stephan
Subject: RMAN not behaving

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: