What good are backups if you can’t use them to restore the database? Oracle provides several ways to restore all or parts of a database. But before we look at the various restore methods, let’s consider why you might need to use them. We’ll examine some of the failures and consider ways to recover the database. I say “recover,” rather than “restore,” because in recovery, the system needs to go back to where it was, and this might not mean restoring the entire database.
Understanding the different ways a database can fail and reasons for a restore can help in planning a backup strategy. So, what can go wrong?
Hardware failures/firmware issues
Loss of a file, control ...