Re: Need help with Disaster Recovery

On 16 Mar 2003 20:12:03 -0800, condjp_at_chp.edu (Joe Condle) wrote:

>We are in the middle of a disater recovery drill.
>Our Peoplesoft Oracle 8.1.6 Tru64 4.0F machine was mock destroyed.
>
>Here is what I did so far.
>On our test machine were we had alot of disk space. We created all
>the disk mount points from the fallen machine. This machine is
>running Tru64 5.1a and had Oracle 8.1.7 installed on it separate
>parition along with a different People soft version.
>
>The oracle user is the same for both versions but their home
>directories are different.
>I restored the 8.1.6 database from tape without a problem. I can not
>connect internal from svrmgrl. I think there is a group problem. I
>am using the dba group on the new box which as a dfiffernt group
>number. Is there a way to find out how the original machines Oracle
>binaries were installed as?
>
>Assuming I get the database started. What steps do I take to roll the
>database forward? I have the archive logs but technically might not
>have the control file from the crash date. I have a vdump of the
>control file but the database was not shutdown when this daily backup
>was taken. Is it any good?
>
>any help or suggestions would be great. I have never recoverd from a
>crash such as this is.
>
>Joe
>Thanks in Advance

It strikes me you are in a disastery recovery drill when you are fully unprepared. If this would have been a real disaster recovery there would have been 0 time to find things out and/or starting questions.

As for the dba group: I wouldn't bother about finding out the original gid (the source machine went in shambles, didn't it) so I would just chown everything, and not bother.

Provided you do have some controlfile, recover database until cancel using backup controlfile should be capable to help you out.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Mar 17 2003 - 00:20:23 CST