Re: Please help: Recovery Scenerio

"dsmcd" <dsmcd_at_uswestmail.net> wrote in message news:ClaP7.160$Ui5.293672_at_news.uswest.net...
> Hello...
>
> Let's say I have two drives.
> -Drive #1 has two partitions; C which has Win2k, and D which has Oracle
> 8.1.7
> -Drive #2 has one partition; E which has all tablespaces.
>
> -3 sets of archived redo logs, and control files; on C,D,and E.
> -Cold backups done with BackupExec.
>
> Scenerio #1;
> -Drive #1 dies a horrible death, must be thrown away and replaced with
> a freshly formatted harddrive.
> How do I recover?

This scenerio is not too hard I think ... Reinstall Win2K - Install Oracle 8.1.7 from CD - recreate init.ora/pwd%SID%.ora (orapwd) - recreate Oracle services : oradim -new -sid %SID% pfile 'd:\oracle\ora817\admin\%SID%\pfile\init%SID%.ora' etc - copy controlfiles from E to D&E
- recreate mirrors of redologs

>
> Scenerio #2;
> -The D partition (Orcale 8.1.7) dies, leaving C intact.
> How do I recover?
>

Reinstall Oracle 8.1.7 software
Recreate init.ora/pwd%SID%.ora (orapwd)
Services should be intact
copy controlfiles from E
recreate mirrors of redologs

> Thank you for any help. Need to get a final configuration for my Oracle
> server as soon as possible and this will help me make the decisions.
>
> Keep in mind, these drives will be raid mirrored, but I need to know
> how to recover if the mirror is of no help.
> D.
>
Received on Tue Dec 04 2001 - 15:38:46 CST