Backup & Recovery

[sumi_ocp]

hi guys,

I have been asked by management to document backup and recovery procedures..
They need a complete recovery procedure in case of a db crash like restoring hot backup/ applying archive files etc..

Now I am really confused what all should I write in this..I mean I know how to do recovery in different scenarios..but really dont know should I include every scenario here in this doc...
my manager is not clear on this..
So any insights on this would be appreciated..

Thanks in advance...

sumi_ocp

[GURUDAS]

see ur answer is in ur question

u say that u know how to recover in different scenarios
so that is it.

put this situations in a piece of paper and u will get the solution by urself.

ur doc should contain situations what could happen
1 datafile lost , corrupt
2 control file corrupt
3 redolog files corrupt
4 rbs files deleted , damaged .
5 machine crash
6 disk failure

-- backup files avaible.
-- archive log files availability
-- restoration method .

i hope u are clear now

-- Good luck.