Database Backup and Recovery (MOSC)

MOSC Banner

Restoring datafile from full backup - I can't see what I am missing

edited Oct 18, 2011 8:44PM in Database Backup and Recovery (MOSC) 12 commentsAnswered
Hi,

I allegedly have a full backup of my database - I have the output from list backup of database comleted after 'sysdate-1'; and crosscheck to ensure that they are there and available but when I do a restore, I get datafiles from 11 to being not found. This is confusing me because it seems to be there but it doesn't want to work. 

This bothers me because the backup is available and is a full backup according to the RMAN list command. My understanding of full is that it should have everything required whcih makes me think I am either missing a crucial step or RMAN tells lies!

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