Re: Recovery of an Oracle Database from a disk crash

monster910_at_hotmail.com (Kevin) wrote in message news:<79c84cd5.0403301424.5590bcdb_at_posting.google.com>...
> Need help!
>
> Basically, a past Oracle DBA setup the database and now we need to
> recover it because the scripts he setup to do backup dumps everynight
> were wrong and the main server crashed! Argh! I have contracted a data
> recovery service and need to give them direction on the exact files to
> recover.
>
> Environment: Solaris 8, Oracle 8.1.6
> Oracle installed: /u01/app/oracle
> Data installed: /u02/oradata
>
> On a machine configured the same, I have the following files
>
> drwxr-xr-x 2 oracle oinstall 512 Oct 22 2000 .
> drwxr-xr-x 3 oracle oinstall 512 Oct 22 2000 ..
> -rw-r----- 1 oracle oinstall 4497408 Mar 30 16:10 control01.ctl
> -rw-r----- 1 oracle oinstall 4497408 Mar 30 16:10 control02.ctl
> -rw-r----- 1 oracle oinstall 4497408 Mar 30 16:10 control03.ctl
> -rw-r----- 1 oracle oinstall 56631296 Mar 30 15:09 indx01.dbf
> -rw-r----- 1 oracle oinstall 20987904 Mar 30 15:09
> oem_repository.dbf
> -rw-r----- 1 oracle oinstall 541073408 Mar 30 15:09 rbs01.dbf
> -rw-r----- 1 oracle oinstall 512512 Mar 30 14:52 redo01.log
> -rw-r----- 1 oracle oinstall 512512 Mar 30 14:54 redo02.log
> -rw-r----- 1 oracle oinstall 512512 Mar 30 14:54 redo03.log
> -rw-r----- 1 oracle oinstall 152313856 Mar 30 15:09 system01.dbf
> -rw-r----- 1 oracle oinstall 71311360 Mar 30 15:09 temp01.dbf
> -rw-r----- 1 oracle oinstall 8396800 Mar 30 15:09 tools01.dbf
> -rw-r----- 1 oracle oinstall 177217536 Mar 30 15:09 users01.dbf
>
>
> Questions
> 1. Is the oradata directory the only directory I need to recover?

Perhaps not. If you have archived logs, you need those too. I don't think you have your data files listed, given the size of the rbs. The very first thing you should do is copy the control files elsewhere.

> 2. Can I stop the database on the backup machine (with files above),
> tar the files, insert the recovered database files and start up the
> database?

No (with some qualifiers that are unlikely). The System Change Number will never be in sync between all the files and the control files and you won't be able to start the db.

> 3. Did I miss anything?

Insufficient data. I don't understand what you mean by backup server - is that a standby database, a propagated database, a reloaded database, a mirrored database, a replicated database or what? 816 isn't necessarily the greatest version in the world. What did the backup do, a hot backup, a cold backup, an export? Why do you think there was something wrong with what the previous DBA did, has he been gone for one day? Are you running in archivelog mode? Do you have the archived logs, and if so, where? Why are you using a data recovery service? Did you have a disk crash?

>
> Thanks in advance,
>
> If you do this kind of work, contact me!

Where in the meatworld are you? I'm in socal.

jg

--
@home.com is bogus, s/home.com/cox.net/.
"A production database that is not up and running when it should be
has terrible
performance!" - Brian Peasland