My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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

Attempt to restore datafile failed as follows:

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

But there appears to be a backup available for use:


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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.