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. [EMAIL PROTECTED] -----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. ------------------------- Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -------------------------------------------------------------------- This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -------------------------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).