Re: Recovering from a CD or tarball

Desmond Rivet <des_riv_at_sympatico.ca> wrote in message news:<3B9BD31A.A6944AE8_at_sympatico.ca>...
> Hi all,
>
> I'm very new to databases in general, and Oracle in particular, so some
> of my qurestions may seem a bit naive. Please bear with me!
>
> I have been given a CD of files that comprise a cold copy of an existing
> Oracle database. That is, the CD contains the control files, the *.dbf
> file and the redo logs of an existing Oracle database (assumedly, the
> files were just copied onto the CD through conventional OS methods). It
> seems to be a complete copy of the original data directories. I also
> have a copy of the initXXX.ora initialization file that was used for the
> database.
>
> My question is: is that enough to "recover" from? That is to say, can I
> simply start the svrmgrl program, issue a "connect internal", then issue
> a "startup" command (with a pfile pointing to the initXXX.oa that came
> with the database) and expect everything to be a-okay, assuming that the
> initXXX.ora points to the original control files? Or am I being naive
> here?
>
> Now let's say that the original databse was an Oracle 7.x database (I
> think it was 7.3.2.1.0) and the database that I have at my disposal now
> is an Oracle 8.x (I think 8.1.6) database. Assuming I do everything like
> I did above, should everything still work?
>
> Thanks in advance!

Won't work with differing versions. You may be able to fire up Oracle 7.x (same version) as the DB was running, copy the files over, startup nomount and create a new controlfile would probably be your easiest way I think. This is assuming you can't duplicate the file layout on your new machine.

Also, remember that copying files from CD will probably mark them as readonly, so change that to r/w first! Received on Mon Sep 10 2001 - 09:54:23 CDT