| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Disaster Recovery
Sean - I could probably be of more help if you could describe something
about how you propose to recover the system. Do you have a recovery site?
Have assurance from your vendor that they could provide a comparable system
somewhere in a reasonable frame of time?
Another item to consider would be a listing from Oracle of where all data files are placed (select file_name from dba_data_files). Also, since a lot of the items you list will change over time (scheduled jobs?) you need to have a procedure that will ensure these are updated frequently.
Any backup plan is only good if it is tested from time to time. What is your plan to test?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, February 06, 2003 9:10 AM
To: Multiple recipients of list ORACLE-L
We're in the process of updating our DR plan and adding some more detail <G>!. So I've been racking the auld grey matter and trying to identify a list of useful hardcopy documents which would be really useful for DR. The type of documents you store in a folder at home and bring along should the sh#t hit the fan. What I've come up with so far is:
[1] Over view diagram of server showing disk config details and locations
of various key database files. This doc also includes high level server
spec and IP info.
[2] Relevant Technical Operating Procedures.
[3] Log forms for DB restore and backup.
[4] List of dirs per server included in tape backup schedule.
[5] List of backups per server including info on backup dirs and locations
of log files.
[6] List of scheduled jobs on each server, time, freq, command line to
submit.
[7] Copy of DR plan and Technical manual for primary production system on
CD.
The following get backed up disk-to-disk T,W,Th,F,S and are included on tape
incremental:
Binary and text dumps of control file.
Script which creates dynamic script to run offline database backups.
Disk to disk backup of database.
Archived redo logs.
I'm thinking some type of crib sheet with useful commands for that DR situation might be useful too.
So what else would you as a DBA like to have in this folder to support a smooth and efficient as possible DR?.
Oh yeah our SLA is that we recover DB as was at time of last working day (M-F) backup.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: O'Neill, Sean INET: Sean.ONeill_at_organon.ie Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Feb 06 2003 - 10:19:41 CST
 |
 |