If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Disaster recovery plan

My boss ask for a disaster recovery plan. Every time we are down or have an error, i deal with it on the spot and i solve the problem usely fast(thanks to meta-link and dbasupport!!).

I search a lot on this subject, and people are saying how to do one, but there is no example. I never see how a disaster recovery plan is suppose to look like. Does anyone have an example, or do not mind showing there plan? I became the dba here (without certification, will take exam this year),reading lots a books and checking web site regulary like this one.

We have 7 database on 3 windows nt platform, we have oracle 8i, we do hot backup all week and friday night cold backup. We need max 2 hour down time.

Every time we have a case where we need to deal with a ora- error, i put it in our recovery plan that i started 3 month ago. like ORA-01034, TNS-12541. We take tape backup every night and keep a tape per month.

We are a small company with 12 programmors on forms/reports. Like i said when we have problem with the database, i solve the problem, but we need to start building documentation, so that when we have a realy small problem, im not the only one that could resolve it.

I would like to suggest you to have a standby database, so in case of database crash you will have second database readily available, this will save your database restore time.

As you have started documentation, it will be nice to document few more things like database recovery, hot-cold backups, or simple imp/export examples, which are quite useful to developers, so that in your absence they can perform basic tasks

Thx for the reply, we have batch file with exp/imp for the developers, we have also no documentation for our backup strategy, but i have documentation on when developper drop or delete object by error, on how to restored them with imp utility, we take full export every week.

What would help you and others is to create a notebook filled with "emergency" procedures. You can cover all the different types of failure scenarios related to Oracle files (log file, data file, control files, etc.). You can cover the commands to move a datafile, rename a file, etc.

Ideally, the notebook would provide step-by-step backup and recovery instructions for the non-DBA (but familiar with Oracle), not go into a lot of detail, and provide references in case more information is needed (bookmarked MetaLink Notes are good for that). That's what I would do and am working on.