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.
Thanks a lot! your blog helped me.
You’re welcome!