N/APosted on - 10/25/2011
I lost one data file on my database that is running in Archivelog mode. I made a full backup of my database a week ago and made a partial backup on the said data file a day ago. Now I am confused on which backup should I restore the lost data file? Please help me.
How to restore lost data file?
Full backups include all data within the backup scope. A full database backup will include all data in the database regardless of when it was last created or modified. Similarly, a full partial backup will include the entire contents of every file and file group within the scope of that partial backup.
If you do some changes in your database after performing the full backup, the partial backup will only save the portion of the data that has changed since the last full backup and will be a much smaller file. I suggest that you restore the full backup.
Good Luck to you!