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 ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
