Database Backup and Recovery (MOSC)

MOSC Banner

RMAN 06023 no backup or copy of datafile 1 found to restore, data file 5,6,7,8 will be created autom

edited Jul 11, 2013 3:45AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
I am trying to restore production DB to UAT.
Production DB Backups are moved to UAT to a location on UAT that has the same name as of Production.

Control File restored fine on UAT.
List Backup of Datafile 1 shows the backupset and file used for restoring.

But Restore Database Preview shows errors RMAN 06023.

I do not understand why this happens.

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