RMAN-06023 during restore of a plugged in datafile (Doc ID 1453090.1)

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious
data from the Oracle sample schema(s),Public Documentation delivered with an Oracle database product or other training material.
Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example
to describe the procedure:

Directory = /opt/app/oracle

RMAN> restore datafile 6;

Starting restore at 27 APR 2012 15:55:28
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/27/2012 15:55:28
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore

RMAN> list backup of datafile 6;

specification does not match any backup in the repository

RMAN> list copy of datafile 6;

specification does not match any datafile copy in the repository

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
44      Full    1.33G      DISK        00:01:10     26 APR 2012 15:05:50
        BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20120426T150440
        Piece Name: /opt/app/oracle/fast_recovery_area/<PATH>/<PIECE_NAME>.bkp
  List of Datafiles in backup set 44
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 3804449    26 APR 2012 15:04:40 /<PATH>/<FILE_NAME>.dbf
  2       Full 3804449    26 APR 2012 15:04:40 /<PATH>/<FILE_NAME>.dbf
  3       Full 3804449    26 APR 2012 15:04:40 /<PATH>/<FILE_NAME>.dbf
  4       Full 3804449    26 APR 2012 15:04:40 /<PATH>/<FILE_NAME>.dbf
  5       Full 3804449    26 APR 2012 15:04:40 /<PATH>/<FILE_NAME>.dbf
  6         Full 3804449      26 APR 2012 15:04:40