Skip to content

How to Resolve RMAN-06023: no backup or copy of datafile found to restore

RMAN-06026 and RMAN-06023

Found errors RMAN-06026 and RMAN-06023 after several hours of database restore.

RMAN> restore database;
...
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/16/2021 22:07:53
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore

After doing some investigations, I found those data files all belong to pdbseed. The big hint reminded me that I forgot to create the directory for pdbseed in ASM.

Solution

1. Make a Directory

So the solution is simple, just like I did in How to Resolve ORA-15173, I make a directory for the target PDB pdbseed.

[grid@primary01 ~]$ asmcmd mkdir +DATA/ORCLCDB/pdbseed

2. Restore Datafiles

RMAN> restore datafile 5; RMAN> restore datafile 6; RMAN> restore datafile 8;

Now we can safely recover the database.

2 thoughts on “How to Resolve RMAN-06023: no backup or copy of datafile found to restore”

Leave a Reply

Your email address will not be published. Required fields are marked *