Please help: Recovery Scenerio 
Author Message
 Please help: Recovery Scenerio

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?

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

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.



Sun, 23 May 2004 04:28:18 GMT
 Please help: Recovery Scenerio


Quote:
> 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

Quote:

> 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
Quote:
> 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.



Sun, 23 May 2004 05:38:46 GMT
 Please help: Recovery Scenerio
What do you mean by:

Quote:
>- recreate init.ora/pwd%SID%.ora (orapwd)

I see how orapwd would create pwd%SID%.ora, but how does it relate to
init.ora?

Thanks for the relief. If this is it, then I'm much relieved.

Thx,
D.



Sun, 23 May 2004 05:59:59 GMT
 Please help: Recovery Scenerio

On NT init.ora is put on the same partition as ORACLE_HOME
(ORACLE_BASE\admin\%SID%\pfile)... so if that disk crash you'll have to
recreate a new init.ora ... however you could also put the init.ora on
another partition and use a dummy init.ora using ifile=x:\.....\newinit.ora
Also when you create your services using oradim you can specify the location
of the init.ora (-pfile)...

It's been a while (I'm unix based) but I've once done a recovery where I've
lost NT4 OS and Oracle executables - datafiles/controlfiles/redologs where
fine ...
I just reinstalled NT4+Oracle executable and recreated
services/init.ora/orapwd and all was fine ...


Quote:
> What do you mean by:

> >- recreate init.ora/pwd%SID%.ora (orapwd)

> I see how orapwd would create pwd%SID%.ora, but how does it relate to
> init.ora?

> Thanks for the relief. If this is it, then I'm much relieved.

> Thx,
> D.



Sun, 23 May 2004 06:11:18 GMT
 Please help: Recovery Scenerio
Gotcha. My orapwd -help only mentions orpwd file, password, and
entries. No mention of init.ora but I'm thinking I'd grab it from tape.

Thanks for your help. Time for some experimenting.

Thx,
D.

Quote:
>On NT init.ora is put on the same partition as ORACLE_HOME
>(ORACLE_BASE\admin\%SID%\pfile)... so if that disk crash you'll have
>to
>recreate a new init.ora ... however you could also put the init.ora on
>another partition and use a dummy init.ora using
>ifile=x:\.....\newinit.ora
>Also when you create your services using oradim you can specify the
>location
>of the init.ora (-pfile)...



Sun, 23 May 2004 06:27:12 GMT
 Please help: Recovery Scenerio
I think you misunderstood me - init.ora you'll either have to restore from
tape or recreate manually (by typing in the parameters using a text-editor)
this has nothing the do with the orapwd tool


Quote:
> Gotcha. My orapwd -help only mentions orpwd file, password, and
> entries. No mention of init.ora but I'm thinking I'd grab it from tape.

> Thanks for your help. Time for some experimenting.

> Thx,
> D.

> >On NT init.ora is put on the same partition as ORACLE_HOME
> >(ORACLE_BASE\admin\%SID%\pfile)... so if that disk crash you'll have
> >to
> >recreate a new init.ora ... however you could also put the init.ora on
> >another partition and use a dummy init.ora using
> >ifile=x:\.....\newinit.ora
> >Also when you create your services using oradim you can specify the
> >location
> >of the init.ora (-pfile)...



Sun, 23 May 2004 06:30:24 GMT
 Please help: Recovery Scenerio

Understood. Thanks again. Your help is greatly appeciated.

D.

Quote:

>I think you misunderstood me - init.ora you'll either have to restore
>from
>tape or recreate manually (by typing in the parameters using a
>text-editor)
>this has nothing the do with the orapwd tool



Sun, 23 May 2004 07:14:50 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. COMBO BOX, PLEASE HELP, PLEASE HELP, PLEASE HELP!

2. recovery - please help

3. Infinite recovery mode - please help

4. Please help - Recovery taking forever

5. Help With Data Recovery, Please

6. Database in recovery error 3314 - Can I fix This...please help

7. Please help -- urgent MDB recovery problem

8. Recover Help Please - needs more recovery

9. PLEASE HELP URGENT RECOVERY

10. URGENT: Please help with an recovery option...

11. Please help on recovery Data from Oracle DB

12. emergency please help me please please please


 
Powered by phpBB® Forum Software