Re: Recovery of an Oracle Database from a disk crash

"Kevin" <monster910_at_hotmail.com> 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?
> 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?
> 3. Did I miss anything?
>
> Thanks in advance,
>
> If you do this kind of work, contact me!

Call support.

No backup is any good if you have never tested it and know how to do a recovery. Backups should be tested regularly.

Jim Received on Tue Mar 30 2004 - 18:10:24 CST