How to restore lost data file?

Asked By edcasey 0 points N/A Posted 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.

• Status: Open
• Question Views: 873
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Clair griffin 10 points N/A #93689

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!

About Clair griffin

Questions
1

Answers
132

Best Answers
38

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: Database