Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Recovering from a CD or tarball

Recovering from a CD or tarball

From: Desmond Rivet <des_riv_at_sympatico.ca>
Date: Sun, 09 Sep 2001 16:37:46 -0400
Message-ID: <3B9BD31A.A6944AE8@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!

-- 
----------------------------------------------------------------------
Desmond Rivet                                    des_riv_at_sympatico.ca
Programmer Wannabe

  Is life worth living?  That is a question for an embryo, not a man.
		  --Samuel Butler
Received on Sun Sep 09 2001 - 15:37:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US