Database Backup and Recovery (MOSC)

MOSC Banner

Datafiles Missing from RMAN Level 0 backup

I was trying to restore a database to a new server using the latest level 0 backup taken on 11/14/2020 and the latest level 1 backup, taken on 11/16/2020. The process ended with the following error:


RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 11/17/2020 10:52:38

RMAN-06026: some targets not found - aborting restore

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

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



I then listed the backups of those data files:


RMAN> LIST BACKUP OF DATAFILE 10;

List of Backup Sets

===================



BS Key Type LV Size      Device Type Elapsed Time Completion Time

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center