Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!newshub.northeast.verio.net!verio!newsfeed.sovam.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail Message-ID: <3B9BD31A.A6944AE8@sympatico.ca> From: Desmond Rivet X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc Subject: Recovering from a CD or tarball Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 34 Date: Sun, 09 Sep 2001 16:37:46 -0400 NNTP-Posting-Host: 64.229.33.176 X-Complaints-To: abuse@sympatico.ca X-Trace: news20.bellglobal.com 1000067652 64.229.33.176 (Sun, 09 Sep 2001 16:34:12 EDT) NNTP-Posting-Date: Sun, 09 Sep 2001 16:34:12 EDT Organization: Bell Sympatico Xref: easynews comp.databases.oracle.misc:68505 X-Received-Date: Sun, 09 Sep 2001 13:34:00 MST (news.easynews.com) 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@sympatico.ca Programmer Wannabe Is life worth living? That is a question for an embryo, not a man. --Samuel Butler