O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Restoring and Recovering Databases

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.

What Can Go Wrong?

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

User error

Bad code

Loss of a file, control ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required