We couldn??™t get a restore of the database without
setting off SUSPECT mode. In the end, we had to create a new database and use the emergency startup
mode for the database to extract as much data as possible. Had they tested their restore process just once,
they could have prevented the entire problem.
CHAPTER 5 n CREATING A BACKUP/RECOVERY PLAN 112
Maintenance and Troubleshooting
Even once you design, test, and automate the plan, you??™ll still need to perform maintenance
or spend time troubleshooting unexpected behavior (automated does not mean
automatic). Problems will still arise even with a perfectly designed BRP created and
tested by a guru-level DBA. Ultimately, everything is created by humans, and, as we
know, to err is human. Any automated system simply does what a human tells it to do,
often without regard to the consequences.
Some issues are unforeseeable and have no place (directly) in human error. In
World War II, pilots blamed odd hardware malfunctions on ???gremlins.??? The technology
world is no different. Systems have become so complex that it??™s practically impossible
to identify the exact state of any system at a specific point in time.
Pages:
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240